Details
Description
Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH
mysql Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64) using readline 5.1
Steps to reproduce:
MariaDB [test]> create table test1 (col1 INT);
|
MariaDB [test]> insert into test1 values(100);
|
MariaDB [test]> select * from test1;
|
+------+
|
| col1 |
|
+------+
|
| 100 |
|
+------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> create event event1 ON SCHEDULE every 5 SECOND do insert into test.test1 (col1) values(200);
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> show events;
|
ERROR 1728 (HY000): Cannot load from mysql.event. The table is probably corrupted
|
MariaDB [test]> show variables like 'sql_mode'\G
|
*************************** 1. row ***************************
|
Variable_name: sql_mode
|
Value: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> show events;
|
ERROR 1728 (HY000): Cannot load from mysql.event. The table is probably corrupted
|
|
MariaDB [test]> set sql_mode = 'STRICT_TRANS_TABLES';
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [test]> show variables like 'sql_mode'\G
|
*************************** 1. row ***************************
|
Variable_name: sql_mode
|
Value: STRICT_TRANS_TABLES
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> show events \G
|
*************************** 1. row ***************************
|
Db: test
|
Name: event1
|
Definer: root@localhost
|
Time zone: SYSTEM
|
Type: RECURRING
|
Execute at: NULL
|
Interval value: 5
|
Interval field: SECOND
|
Starts: 2016-01-27 17:52:40
|
Ends: NULL
|
Status: ENABLED
|
Originator: 1
|
character_set_client: utf8
|
collation_connection: utf8_general_ci
|
Database Collation: utf8_general_ci
|
1 row in set (0.00 sec)
|
While searching I have found https://bugs.mysql.com/bug.php?id=74947
looks like the same problem.
Attachments
Issue Links
- relates to
-
MDEV-9830 Plugins unable to load with sql_mode PAD_CHAR_TO_FULL_LENGTH
- Closed