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

Details

    • 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

            elenst Do you know who should be the right developer for this issue?

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - elenst Do you know who should be the right developer for this issue?

            bar, could you please look at it? Feel free to reassign if needed.

            elenst Elena Stepanova added a comment - bar , could you please look at it? Feel free to reassign if needed.

            A smaller test case demonstrating the same problem:

            DROP TABLE IF EXISTS t1;
            DROP EVENT IF EXISTS ev1;
            CREATE TABLE t1 (a INT);
            CREATE EVENT ev1 ON SCHEDULE EVERY 5 SECOND DO DELETE FROM t1;
            SHOW EVENTS;
            SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
            SHOW EVENTS;
            

            The first SHOW EVENTS works fine, the second one fails.

            bar Alexander Barkov added a comment - A smaller test case demonstrating the same problem: DROP TABLE IF EXISTS t1; DROP EVENT IF EXISTS ev1; CREATE TABLE t1 (a INT ); CREATE EVENT ev1 ON SCHEDULE EVERY 5 SECOND DO DELETE FROM t1; SHOW EVENTS; SET sql_mode=PAD_CHAR_TO_FULL_LENGTH; SHOW EVENTS; The first SHOW EVENTS works fine, the second one fails.

            The same problem is also repeatable with the "HELP" command.
            HELP SELECT normally returns:

            Name: 'SELECT'
            Description:
            Syntax:
            SELECT
                [ALL | DISTINCT | DISTINCTROW ]
                  [HIGH_PRIORITY]
                  [STRAIGHT_JOIN]
                  [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
                  [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
            ...
            

            If I set sql_mode to PAD_CHAR_TO_FULL_LENGTH, it stops working:

            SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
            HELP SELECT;
            

            Nothing found
            Please try to run 'help contents' for a list of all accessible topics
            

            bar Alexander Barkov added a comment - The same problem is also repeatable with the "HELP" command. HELP SELECT normally returns: Name: 'SELECT' Description: Syntax: SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] ... If I set sql_mode to PAD_CHAR_TO_FULL_LENGTH, it stops working: SET sql_mode=PAD_CHAR_TO_FULL_LENGTH; HELP SELECT ; Nothing found Please try to run 'help contents' for a list of all accessible topics

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.