Select bug or bad indices

[Chris Jones]

Not sure if this is related or different, but if I do a select with more
than one compare:

SELECT RecID,fldKeyword FROM tblKeyword WHERE fldKeyword = 'Col 02
Strands.duf' OR fldKeyword = 'Default' OR fldKeyword = 'Materials' OR
fldKeyword = 'Plant'

The query seems to ignore the columns collation (in this case making it
case sensitive).  If I do the same search:

SELECT RecID,fldKeyword FROM tblKeyword WHERE fldKeyword = 'Default';

without the OR it returns the correct result.  I get the same weirdness
using the IN operator instead of OR,


On Sat, Nov 16, 2013 at 12:41 AM, Ivan Smahin <ivan_smahin at paradigmasoft.com
> wrote:

>
> On Nov 15, 2013, at 5:04 PM, Chris Jones <cjones at daz3d.com> wrote:
>
> @Beatrix : The database with indexes is around 400 mb.
>
> @Ivan:
> I can send the database if you can tell me the best way to do so, zipped
> its about 75 mb.
>
>
> You can put it into dropbox and share that link to me.
>
>
> --
> Best regards,
> Ivan Smahin
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


-- 
Christopher Jones
Software Developer
DAZ 3D
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131118/8f98fc31/attachment.html>