Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7526

Unexpected quoting and dropping of comments in DROP TABLE commands

Details

    • Improvement
    • Status: Done
    • Low
    • Resolution: Fixed
    • 5.7.32-35, 8.0.22-13
    • 8.0.26-16 (Q3 2021)
    • None

    Description

      Steps to reproduce:

       

      $ mysql -c
      mysql> use test;
      Database changed
      mysql> /* comment1 */ create table t (a varchar(100));
      Query OK, 0 rows affected (0.07 sec)
      mysql> /* comment1 */ drop table t;
      Query OK, 0 rows affected (0.05 sec)
      
      
      [email protected]:/var/lib/mysql# mysqlbinlog d1-bin.000003  | grep -i  'create\|drop' 
      #210126  8:22:22 server id 1  end_log_pos 123 CRC32 0xdc7c88e9 	Start: binlog v 4, server v 5.7.32-35-log created 210126  8:22:22
      /* comment1 */ create table t (a varchar(100))
      DROP TABLE `t` /* generated by server */
      

      Attachments

        Issue Links

          Activity

            People

              nitendra.bhosle Nitendra Bhosle (Inactive)
              iwo.panowicz Iwo Panowicz
              Votes:
              1 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 weeks, 5 hours, 40 minutes
                  3w 5h 40m

                  Smart Checklist