Hi,
I discovered the following behavior:
CREATE TABLE "TABLE_1" ("TEST" VARCHAR2(255));
INSERT INTO TABLE_1 values ('TEST TEST/TEST_TEST_TEST');
SELECT * from TABLE_1 where test COLLATE BINARY_CI like '%t\_t%' ESCAPE '\';
Which gives back the expected result (one row) on Oracle 12.2.0.1.0 but will give back no result on Oracle 19.0.0.3.
The question would be whether I hit a (known) bug or I simply need to adjust a setting?
Maybe someone can give me a hint.