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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • 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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: