Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9524

Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH

    XMLWordPrintable

    Details

    • Sprint:
      10.0.26

      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

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                nirbhay_c Nirbhay Choubey (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: