[MDEV-21074]  NOT LIKE filter request not working Created: 2019-11-18  Updated: 2019-11-19  Resolved: 2019-11-19

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.3.13
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sergei Tihonov Assignee: Olivier Bertrand
Resolution: Duplicate Votes: 0
Labels: None
Environment:

RedHat 8


Issue Links:
Duplicate
is duplicated by MDEV-13782 Issue about the operator NOT LIKE on ... Closed

 Description   

Hello!
I am using a JDBC connection to an Oracle database. In principle, everything works, but noticed that when I try to make a request

SELECT * FROM custom_table WHERE custom_field NOT LIKE 'some text'

There is nothing in the results, but if I make a similar request in Oracle, everything is displayed

After talking with our Oracle database specialists and intercepting the request, we noticed that query incoming in Oracle from JDBC by Connect Engine is not NOT LIKE, but just LIKE

Although it is worth noting that even if I send a request like LIKE through Connect Engine - Then the result request appears.

There is a feeling that the Connect Engine somehow does not work correctly with a filter like NOT LIKE, on the Oracle side, an error occurs rather than a NOT exception



 Comments   
Comment by Sergei Tihonov [ 2019-11-18 ]

Ooohh I'm sorry, I found already created issue about this problem (MDEV-13782)

Generated at Thu Feb 08 09:04:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.