search "-cintanotes"

Thomas Lohrum
Posts: 1309
Joined: Tue Mar 08, 2011 11:15 am

search "-cintanotes"

Postby Thomas Lohrum » Mon Mar 19, 2012 1:00 am

I have 874 notes. I search for "cintanotes" in "title+text". I get 33 records, regardless of the "search inside words" (siw) option. When i search for "-cintanotes" i get 841 records when siw is off. Fine. However i get 869 records when siw is turned on. I am confused about this search result. Any explanations?

Thomas
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: search "-cintanotes"

Postby CintaNotes Developer » Mon Mar 19, 2012 10:01 am

Yes, this is a bug: the SQL produced is "NOT title LIKE '%cintanotes%' OR NOT text LIKE '%cintanotes%'", instead of "NOT title LIKE '%cintanotes%' AND NOT text LIKE '%cintanotes%'".
Will be fixed in Beta 2, thanks!
Alex
Thomas Lohrum
Posts: 1309
Joined: Tue Mar 08, 2011 11:15 am

Re: search "-cintanotes"

Postby Thomas Lohrum » Mon Mar 19, 2012 12:16 pm

CintaNotes Developer wrote:Yes, this is a bug: the SQL produced is "NOT title LIKE '%cintanotes%' OR NOT text LIKE '%cintanotes%'", instead of "NOT title LIKE '%cintanotes%' AND NOT text LIKE '%cintanotes%'".
Will be fixed in Beta 2, thanks!
Thank you!
Thomas

Return to “Bug Reports”