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

MySQL BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.10
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None
        • Sprint:
          10.0.20

          Description

          revno: 3690.1.153
committer: Raghav Kapoor <raghav.kapoor@oracle.com>
branch nick: mysql-trunk-bug-13702397
timestamp: Fri 2012-03-23 15:26:55 +0530
message:
  BUG#13702397 - 64211: 'CREATE TABLE ... LIKE ...' FAILS TO KEEP CASE

  BACKGROUND:
  Regular Create Table Statements properly keep the case on
  a case insensitive file system like Windows or Mac OS X when
  lower_case_table_names= 2 whereas while creating tables LIKE
  another (create table <tablename> LIKE <tablename>), the table
  name case is ignored on a case insensitive file system when
  lower_case_table_names= 2. This problem is mentioned as part
  of this bug report. This behaviour was annoying and not
  consistent with the documentation.

  FIX:
  This bug is fixed by populating the alias in local_create_info
  structure in mysql_create_like_table function when create table
  <tablename> LIKE <tablename> query is issued equal to alias
  information that is stored in create_info structure.This
  assignment was missing due to which this bug was happening.
  Also a testcase has been written in lowercase_table2.test and
  the corresponding result file has also been updated.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      svoj Sergey Vojtovich
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:

                        Agile