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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.