Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.10
-
None
-
Linux Debian 8 64 bits
LAMP server (web development server)
2cpu/4Go ram
mariaDB packages (rom mariaDB apt repository)
ii libmariadbclient18 10.1.9+maria-1~jessie amd64 MariaDB database client library
ii mariadb-client-10.1 10.1.9+maria-1~jessie amd64 MariaDB database client binaries
ii mariadb-client-core-10.1 10.1.9+maria-1~jessie amd64 MariaDB database core client binaries
ii mariadb-common 10.1.9+maria-1~jessie all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-server-10.1 10.1.9+maria-1~jessie amd64 MariaDB database server binaries
ii mariadb-server-core-10.1 10.1.9+maria-1~jessie amd64 MariaDB database core server filesLinux Debian 8 64 bits LAMP server (web development server) 2cpu/4Go ram mariaDB packages (rom mariaDB apt repository) ii libmariadbclient18 10.1.9+maria-1~jessie amd64 MariaDB database client library ii mariadb-client-10.1 10.1.9+maria-1~jessie amd64 MariaDB database client binaries ii mariadb-client-core-10.1 10.1.9+maria-1~jessie amd64 MariaDB database core client binaries ii mariadb-common 10.1.9+maria-1~jessie all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) ii mariadb-server-10.1 10.1.9+maria-1~jessie amd64 MariaDB database server binaries ii mariadb-server-core-10.1 10.1.9+maria-1~jessie amd64 MariaDB database core server files
Description
Using a query with "NOT IN (SELECT" triggers a syntax error despite the fact that the query is syntaxically correct. Removing the "NOT" in the query does not trigger an error anymore.
We simplified the query to show the issue (mytable can be any table)
select * from mytable where 2 not in ( select 1 from mytable )
Exact error message is :
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 1
Executing the same query under mysql 5.5.46 works as expected.