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

Support for NULL/NOT NULL syntax for virtual columns

Details

    Description

      Please support NULL/NOT NULL syntax and semantics, for compatibility with MySQL if nothing else.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7687 Deduce nullability of a generated column from its expression

          • Major - Major loss of function.
          • Confirmed

          Activity

            serg Sergei Golubchik added a comment -

            Semantically it should be equivalent to creating a constraint, like

            MySQL

            		 
              col INT GENERATED ALWAYS AS (a+1) NOT NULL

            MariaDB

            		 
              col INT GENERATED ALWAYS AS (a+1),
            		 
              CONSTRAINT col_not_null CHECK (col IS NOT NULL)

            serg Sergei Golubchik added a comment - Semantically it should be equivalent to creating a constraint, like MySQL col INT GENERATED ALWAYS AS (a+1) NOT NULL MariaDB col INT GENERATED ALWAYS AS (a+1), CONSTRAINT col_not_null CHECK (col IS NOT NULL )

            People

              Unassigned Unassigned
              f_razzoli Federico Razzoli
              Votes:
              9 Vote for this issue
              Watchers:
              13 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.