Hi,

I'm using Fb 1.5 and tried this:

RECREATE TABLE B_TEST
(
ID INTEGER,
B BLOB SUB_TYPE 1
);

Inserted three rows:
insert into B_TEST
values (1, 'test1');
insert into B_TEST
values (2, 'test2');
insert into B_TEST
values (3, 'test3');

Next, try this:
select * from b_test where b = 'test'

This returns ALL 3 ROWS.

This, for example, will update all 3 rows as well:
update b_test set b = null where b = 'test'

Obviously, "b" NEVER equals "test".

Is this a known issue already? If not, I surely consider this a bug.


With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com