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

Issue about the operator NOT LIKE on connect-engine

    XMLWordPrintable

    Details

      Description

      The "not like" operator don't work as expected, it don't return any data when it use trought the connect-engine while the "like" works well, and while on sql_server the exactly same sql query return data

      MariaDB [test]> create table ressource  (
       
          ARS_RESSOURCE varchar(10) NULL,
          ARS_TYPERESSOURCE varchar(10) NULL,
          ARS_LIBELLE  varchar(40) NULL,
          ARS_FERME varchar(10) NULL,
          ARS_LIBRERES1 varchar(10) NULL
       
         )
      ENGINE=CONNECT 
      table_type=ODBC
      DEFAULT CHARSET=latin1 
      CONNECTION='Driver=ODBC Driver 11 for SQL Server;Server=******;Database=******;UID=*******;PWD=******';
      

      so the table is on an remote server so when i try

      MariaDB [test]> SELECT ARS_RESSOURCE, ARS_LIBELLE FROM ressource WHERE ARS_RESSOURCE  LIKE "00%"; 
       ARS_RESSOURCE look like '00120', '00230' and the result  throught mariadb of the LIKE operator works well
       
      ||ARS_RESSOURCE||ARS_LIBELLE||
      |00120|foo|
      |00230|bar|
      

      but when i tried even a whatever query with NOT LIKE operator

      MariaDB [test]> SELECT ARS_RESSOURCE, ARS_LIBELLE FROM ressource WHERE ARS_RESSOURCE NOT LIKE "azeraze%"; 
      

      I don't have any result while this query works well directly on the sqlserver

      if you need any more informations, feel free to ask them

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              MacBooc Martin Francois
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: