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

[SourceForge.net <no...@so...>]

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