ODAC 7.00.0.2 a bug in filtering?

[aparvis]

Hi
I've migrated to Odac 7.00.0.2 recently and I've encountered a problem with filtering. As you can see on pictures below two versions of ODAC behave different for filter *:



I'm wondering if it's on purpose or it's a bug.

Database structure is very simple:
CREATE TABLE test_table
(
id NUMBER,
text VARCHAR2(4000 BYTE)
);

INSERT INTO test_table(id, text) VALUES (1, 'One');
INSERT INTO test_table(id, text) VALUES (2, NULL);
INSERT INTO test_table(id, text) VALUES (3, 'Three');
INSERT INTO test_table(id, text) VALUES (4, NULL);

I use Borland Developer Studio 20006.

[AlexP]

Hello,

It's a bug of CRDBGrid in old versions. It was fixed.
You can check it if you set the dgeLocalFilter extended TCRDBGrid option to false - in this case query returns 0 records.
Its behavior is correct.