There's a problem with LIKE in queries produces inconsistent results, whereas = works as expected,
CREATE TABLE TYPETESTS (test blob NULL , id integer NOT NULL) INSERT INTO TYPETESTS (test,id) VALUES (X'616263646566',349) SELECT TEST,ID FROM TYPETESTS WHERE TEST = CAST (X'616263646566' AS blob) Proper results 100% of the times SELECT TEST,ID FROM TYPETESTS WHERE TEST = X'616263646566' Proper results 100% of the times SELECT TEST,ID FROM TYPETESTS WHERE TEST LIKE X'616263646566' Proper results 30-50% of the times, no results otherwise SELECT TEST,ID FROM TYPETESTS WHERE TEST LIKE CAST (X'616263646566' AS blob) Proper results 30-50% of the times, no results otherwise Would this be considered an issue worthy of a bug report? Thanks! -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments. Thank you.
smime.p7s
Description: S/MIME cryptographic signature
