Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.3, 5.5.35
-
None
Description
With SQL_ERROR_LOGS plugin activated, 1146 errors appear in sql_errors.log (but NOT in the client) when I query INFORMATION_SCHEMA.TABLES, VIEWS or COLUMNS and the results are empty.
In the client:
MariaDB [(none)]> SELECT `TABLE_NAME` FROM `information_schema`.`TABLES` WHERE ` |
TABLE_SCHEMA` = 'not_exists' AND `TABLE_NAME` = 'not_exists'; |
Empty set (0.18 sec) |
|
|
MariaDB [(none)]> SHOW WARNINGS;
|
Empty set (0.02 sec) |
|
|
MariaDB [(none)]>
|
In sql_error.log:
2013-08-08 11:58:42 root[root] @ localhost [127.0.0.1] ERROR 1146: Table 'not_exists.not_exists' doesn't exist : SELECT `TABLE_NAME` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA` = 'not_exists' AND `TABLE_NAME` = 'not_exists' |