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

CREATE..SELECT with DIV creates columns of a wrong data type

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3(EOL)
    • 10.4(EOL)
    • Data types
    • None

    Description

      SET sql_mode='';
      SELECT 1e14 DIV 2 AS c1, '' DIV 2 AS c2;
      CREATE OR REPLACE TABLE t1 AS SELECT 1e14 DIV 2 AS c1, '' DIV 2 AS c2;
      SELECT * FROM t1;
      SHOW CREATE TABLE t1;
      

      +----------------+------+
      | c1             | c2   |
      +----------------+------+
      | 50000000000000 |    0 |
      +----------------+------+
      

      +------------+------+
      | c1         | c2   |
      +------------+------+
      | 2147483647 |    0 |
      +------------+------+
      

      +-------+-------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                      |
      +-------+-------------------------------------------------------------------------------------------------------------------+
      | t1    | CREATE TABLE `t1` (
        `c1` int(4) DEFAULT NULL,
        `c2` int(0) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      +-------+-------------------------------------------------------------------------------------------------------------------+
      

      Notice:

      • The value of c1 in the second result is wrong. It should be 50000000000000.
      • The data type for t1.c1 is wrong. It should be approximately bigint(14).
      • The data type for t1.c2 is wrong. It should be at least int(1).

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.