[Refdb-devel] [ refdb-Bugs-1552020 ] :UR:!~ search does not return expected set

[SourceForge.net]

Bugs item #1552020, was opened at 2006-09-04 16:46
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: :UR:!~ search does not return expected set

Initial Comment:
If searching for records that do not match a certain
string in their URL, I expect to get all records that
do not include this string in the URL, including
records with an empty URL. However, the query seems not
to return records with empty URL. The sql-string should
include "t_link.link_url!~'string' OR
ISNULL(t_link.link_url)". This might also apply to
other exclusive searches.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

[SourceForge.net]

Bugs item #1552020, was opened at 2006-09-04 16:46
Message generated for change (Comment added) made by mhoenicka
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None
Status: Open

Resolution: Fixed

Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: :UR:!~ search does not return expected set

Initial Comment:
If searching for records that do not match a certain
string in their URL, I expect to get all records that
do not include this string in the URL, including
records with an empty URL. However, the query seems not
to return records with empty URL. The sql-string should
include "t_link.link_url!~'string' OR
ISNULL(t_link.link_url)". This might also apply to
other exclusive searches.

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)

Date: 2006-09-06 01:46

Message:
Logged In: YES
user_id=85809

I've fixed three bugs that prevented exclusive author,
keyword, and link (UR, L1-L4) queries to work properly. I've
tested a database containing 48 references. Only 11 of these
have an URL. :UR:~.* returns 11 datasets, :UR:!~.* returns
39 datasets. I assume this is what you intended to get.
Please see whether the current SVN version works ok for you.
If not, I'd appreciate a simple and concise testcase
including the datasets, the queries, the results you get,
and the results you'd expect.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

[SourceForge.net]

Bugs item #1552020, was opened at 2006-09-04 16:46
Message generated for change (Comment added) made by mhoenicka
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None
Status: Open
Resolution: Fixed
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: :UR:!~ search does not return expected set

Initial Comment:
If searching for records that do not match a certain
string in their URL, I expect to get all records that
do not include this string in the URL, including
records with an empty URL. However, the query seems not
to return records with empty URL. The sql-string should
include "t_link.link_url!~'string' OR
ISNULL(t_link.link_url)". This might also apply to
other exclusive searches.

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)

Date: 2006-09-06 01:51

Message:
Logged In: YES
user_id=85809

The test database contained 50 datasets, not 48. Therefore
11+39 does add up. Sorry for the confusion.

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-09-06 01:46

Message:
Logged In: YES
user_id=85809

I've fixed three bugs that prevented exclusive author,
keyword, and link (UR, L1-L4) queries to work properly. I've
tested a database containing 48 references. Only 11 of these
have an URL. :UR:~.* returns 11 datasets, :UR:!~.* returns
39 datasets. I assume this is what you intended to get.
Please see whether the current SVN version works ok for you.
If not, I'd appreciate a simple and concise testcase
including the datasets, the queries, the results you get,
and the results you'd expect.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

[SourceForge.net]

Bugs item #1552020, was opened at 2006-09-04 16:46
Message generated for change (Comment added) made by dreusser
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: refdbd
Group: None

Status: Closed

Resolution: Fixed
Priority: 5
Submitted By: Dominik (dreusser)
Assigned to: Markus Hoenicka (mhoenicka)
Summary: :UR:!~ search does not return expected set

Initial Comment:
If searching for records that do not match a certain
string in their URL, I expect to get all records that
do not include this string in the URL, including
records with an empty URL. However, the query seems not
to return records with empty URL. The sql-string should
include "t_link.link_url!~'string' OR
ISNULL(t_link.link_url)". This might also apply to
other exclusive searches.

----------------------------------------------------------------------

Comment By: Dominik (dreusser)

Date: 2006-09-07 14:03

Message:
Logged In: YES
user_id=1572139

I tested the current SVN version and got the results as I
expected them to be. Thank you very much :)

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-09-06 01:51

Message:
Logged In: YES
user_id=85809

The test database contained 50 datasets, not 48. Therefore
11+39 does add up. Sorry for the confusion.

----------------------------------------------------------------------

Comment By: Markus Hoenicka (mhoenicka)
Date: 2006-09-06 01:46

Message:
Logged In: YES
user_id=85809

I've fixed three bugs that prevented exclusive author,
keyword, and link (UR, L1-L4) queries to work properly. I've
tested a database containing 48 references. Only 11 of these
have an URL. :UR:~.* returns 11 datasets, :UR:!~.* returns
39 datasets. I assume this is what you intended to get.
Please see whether the current SVN version works ok for you.
If not, I'd appreciate a simple and concise testcase
including the datasets, the queries, the results you get,
and the results you'd expect.

----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1552020&group_id=26091