release/src/router/mysql/mysql-test/r/log_tables_upgrade.result

   1 #
   2 # Bug#49823: mysql_upgrade fatal error due to general_log / slow_low CSV NULL
   3 #
   4 USE test;
   5 SET @saved_general_log = @@GLOBAL.general_log;
   6 SET GLOBAL general_log = OFF;
   7 USE mysql;
   8 FLUSH TABLES;
   9 REPAIR TABLE test.bug49823;
  10 Table   Op      Msg_type        Msg_text
  11 test.bug49823   repair  status  OK
  12 RENAME TABLE general_log TO renamed_general_log;
  13 RENAME TABLE test.bug49823 TO general_log;
  14 mtr.global_suppressions                            OK
  15 mtr.test_suppressions                              OK
  16 mysql.columns_priv                                 OK
  17 mysql.db                                           OK
  18 mysql.event                                        OK
  19 mysql.func                                         OK
  20 mysql.general_log
  21 Error    : You can't use locks with log tables.
  22 status   : OK
  23 mysql.help_category                                OK
  24 mysql.help_keyword                                 OK
  25 mysql.help_relation                                OK
  26 mysql.help_topic                                   OK
  27 mysql.host                                         OK
  28 mysql.ndb_binlog_index                             OK
  29 mysql.plugin                                       OK
  30 mysql.proc                                         OK
  31 mysql.procs_priv                                   OK
  32 mysql.renamed_general_log                          OK
  33 mysql.servers                                      OK
  34 mysql.slow_log
  35 Error    : You can't use locks with log tables.
  36 status   : OK
  37 mysql.tables_priv                                  OK
  38 mysql.time_zone                                    OK
  39 mysql.time_zone_leap_second                        OK
  40 mysql.time_zone_name                               OK
  41 mysql.time_zone_transition                         OK
  42 mysql.time_zone_transition_type                    OK
  43 mysql.user                                         OK
  44 DROP TABLE general_log;
  45 RENAME TABLE renamed_general_log TO general_log;
  46 SET GLOBAL general_log = @saved_general_log;
  47 USE test;