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

Add full support for DEFAULT

    XMLWordPrintable

Details

    Description

      Add full support for DEFAULT

      • Support for functions: DEFAULT (1+1)
      • Referring to previous fields in the table
      • Support for DEFAULT for blobs

      In addition this task will lift the current restrictions for virtual columns:

      • Non stored virtual columns can have almost any expression (including constant expression)
      • No 300 character limit. (Limit is 64K for all stored expressions + column definitions)

      Example:

      create table t1 (a bigint default uuid_short(), b blob DEFAULT "look at me!" NOT NULL);

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-9932 provide a default value of the current date for date fields

          • Major - Major loss of function.
          • Closed
          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10201 Bad results for CREATE TABLE t1 (a INT DEFAULT b, b INT DEFAULT 4)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10207 DEFAULT udf(x) does not return an error when UDF is dropped

          • Major - Major loss of function.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-10137 Providing compatibility to other databases

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-6445 UUID column type addition for distributed systems

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10351 Prepared statement with parameters in new DEFAULT syntax fails with syntax error upon execution

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10352 Server crashes in Field::set_default on CREATE TABLE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10353 New DEFAULT logic does not support use of some suitable functions

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10354 Assertion `! is_set()' failed in Diagnostics_area::set_ok_status on CREATE TABLE with invalid default

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10355 Weird error message upon CREATE TABLE with DEFAULT: Function or expression 'cache' cannot be used in the ??? clause

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11137 TIMESTAMP has 2-level logic for default values

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14700 ALTER TABLE fails with bogus "BLOB/TEXT column '(null)' can't have a default value"

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11136 Orpho error in ER_EXPRESSION_REFERS_TO_UNINIT_FIELD text

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

          Activity

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              1 Vote for this issue
              Watchers:
              5 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.