Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21074

NOT LIKE filter request not working

    XMLWordPrintable

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              sergtih Sergei Tihonov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: