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

Implement optional lengths for string types

    XMLWordPrintable

Details

    Description

      MariaDB currently requires string lengths to be specified, for example:

      CREATE TABLE t1 (
      		 
          a VARCHAR(10),
      		 
          b VARCHAR(20)
      		 
      );

      The 2023 SQL standard no longer requires this, so:

      CREATE TABLE t1 (
      		 
          a VARCHAR,
      		 
          b VARCHAR
      		 
      );

      would be valid code. The limit is then left to the implementation to define, for example in PostgreSQL, characters without lengths become character(1), while character varying without lengths accept strings of any size.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40049 DEFAULT on an optional-length string column is silently truncated to the empty string

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40051 ERROR 1030 (HY000) — Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine" from storage engine MyISAM

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-40079 ERROR 1731 (HY000): Non matching attribute 'TABLE OPTION' between partition and table

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Activity

            People

              ramesh Ramesh Sivaraman
              greenman Ian Gilfillan
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1.5d
                  1.5d

                  Git Integration

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