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

Conflicting declaration is accepted: INT SIGNED ZEROFILL

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.2.8
    • Parser
    • None

    Description

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a INT SIGNED ZEROFILL);
      		 
      INSERT INTO t1 VALUES (-1);
      		 
      SHOW CREATE TABLE t1;
      		 

      +-------+---------------------------------------------------------------------------------------------------------+
      		 
      | Table | Create Table                                                                                            |
      		 
      +-------+---------------------------------------------------------------------------------------------------------+
      		 
      | t1    | CREATE TABLE `t1` (
      		 
        `a` int(10) unsigned zerofill DEFAULT NULL
      		 
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      		 
      +-------+---------------------------------------------------------------------------------------------------------+

      I.e. the "SIGNED" keyword was silently ignored.

      The expected behavior is to return an error.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          bar Alexander Barkov created issue -
          bar Alexander Barkov made changes -
          Field Original Value New Value
          Description {code}
          DROP TABLE IF EXISTS t1;
          CREATE TABLE t1 (a INT SIGNED ZEROFILL);
          INSERT INTO t1 VALUES (-1);
          SHOW CREATE TABLE t1;
          {code}

          {noformat}
          +-------+---------------------------------------------------------------------------------------------------------+
          | Table | Create Table |
          +-------+---------------------------------------------------------------------------------------------------------+
          | t1 | CREATE TABLE `t1` (
            `a` int(10) unsigned zerofill DEFAULT NULL
          ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
          +-------+---------------------------------------------------------------------------------------------------------+
          {noformat}

          I.e. the "SIGNED" keyword was silently ignored.

          The expected behavior is to return error.
          		 {code}
          DROP TABLE IF EXISTS t1;
          CREATE TABLE t1 (a INT SIGNED ZEROFILL);
          INSERT INTO t1 VALUES (-1);
          SHOW CREATE TABLE t1;
          {code}

          {noformat}
          +-------+---------------------------------------------------------------------------------------------------------+
          | Table | Create Table |
          +-------+---------------------------------------------------------------------------------------------------------+
          | t1 | CREATE TABLE `t1` (
            `a` int(10) unsigned zerofill DEFAULT NULL
          ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
          +-------+---------------------------------------------------------------------------------------------------------+
          {noformat}

          I.e. the "SIGNED" keyword was silently ignored.

          The expected behavior is to return an error.
          elenst Elena Stepanova made changes -
          Affects Version/s 10.1 [ 16100 ]
          Affects Version/s 10.0 [ 16000 ]
          Affects Version/s 5.5 [ 15800 ]
          bar Alexander Barkov made changes -
          Component/s Parser [ 10201 ]
          serg Sergei Golubchik made changes -
          Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 5.5 [ 15800 ]
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s 10.1 [ 16100 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.2.8 [ 22544 ]
          Fix Version/s 10.2 [ 14601 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 71166 ] MariaDB v4 [ 149499 ]

          People

            serg Sergei Golubchik
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.