| 1 |
show variables like 'sql_error_log%'; |
| 2 |
Variable_name Value |
| 3 |
sql_error_log_filename sql_errors.log |
| 4 |
sql_error_log_rate 1 |
| 5 |
sql_error_log_rotate OFF |
| 6 |
sql_error_log_rotations 9 |
| 7 |
sql_error_log_size_limit 1000000 |
| 8 |
sql_error_log_warnings ON |
| 9 |
sql_error_log_with_db_and_thread_info ON |
| 10 |
set global sql_error_log_rate=1; |
| 11 |
# Trying to set the variable at runtime |
| 12 |
SET sql_error_log_with_db_and_thread_info=OFF; |
| 13 |
ERROR HY000: Variable 'sql_error_log_with_db_and_thread_info' is a read only variable |
| 14 |
# |
| 15 |
# Using test database from mtr |
| 16 |
# |
| 17 |
DROP DATABASE db; |
| 18 |
ERROR HY000: Can't drop database 'db'; database doesn't exist |
| 19 |
# |
| 20 |
# Using no database at all |
| 21 |
# |
| 22 |
connect con1,localhost,root,,*NO-ONE*; |
| 23 |
DROP DATABASE dbnodb; |
| 24 |
ERROR HY000: Can't drop database 'dbnodb'; database doesn't exist |
| 25 |
disconnect con1; |
| 26 |
connection default; |
| 27 |
# |
| 28 |
# Using database with name `NULL` |
| 29 |
# |
| 30 |
CREATE DATABASE `NULL`; |
| 31 |
USE `NULL`; |
| 32 |
DROP DATABASE db; |
| 33 |
ERROR HY000: Can't drop database 'db'; database doesn't exist |
| 34 |
TIME THREAD_ID HOSTNAME `mtr` WARNING 1286: Unknown storage engine 'InnoDB' : SELECT CONCAT(table_schema, '.', table_name) AS columns_in_mysql, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_scale, character_set_name, collation_name, column_type, column_key, extra, column_comment FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema='mysql' ORDER BY columns_in_mysql |
| 35 |
TIME THREAD_ID HOSTNAME `mtr` WARNING 1286: Unknown storage engine 'InnoDB' : SELECT CONCAT(table_schema, '.', table_name) AS columns_in_mysql, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_scale, character_set_name, collation_name, column_type, column_key, extra, column_comment FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema='mysql' ORDER BY columns_in_mysql |
| 36 |
TIME THREAD_ID HOSTNAME `mtr` WARNING 1286: Unknown storage engine 'InnoDB' : SELECT CONCAT(table_schema, '.', table_name) AS columns_in_mysql, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_scale, character_set_name, collation_name, column_type, column_key, extra, column_comment FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema='mysql' ORDER BY columns_in_mysql |
| 37 |
TIME THREAD_ID HOSTNAME `test` ERROR 1238: Variable 'sql_error_log_with_db_and_thread_info' is a read only variable : SET sql_error_log_with_db_and_thread_info=OFF |
| 38 |
TIME THREAD_ID HOSTNAME `test` ERROR 1008: Can't drop database 'db'; database doesn't exist : DROP DATABASE db |
| 39 |
TIME THREAD_ID HOSTNAME NULL ERROR 1008: Can't drop database 'dbnodb'; database doesn't exist : DROP DATABASE dbnodb |
| 40 |
TIME THREAD_ID HOSTNAME `NULL` ERROR 1008: Can't drop database 'db'; database doesn't exist : DROP DATABASE db |
| 41 |
DROP DATABASE `NULL`; |