Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6, 10.2(EOL)
-
None
-
Windows Server 2008, sql server
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
- duplicates
-
-
- Closed
-
- relates to
-
-
- Closed
-