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

Deduce nullability of a generated column from its expression

    XMLWordPrintable

Details

    Description

      Generated columns are always created as nullable. This is not necessarily correct, the server could deduce the nullability of the generated column from its generating expression.

      Making them NOT NULL as appropriate would simplify optimization in some cases and would allow creating, for example, SPATIAL indexes over generated columns.

      Original description

      I don't have the details of error reported , but i remember server complaining about unique index

      The workaround was to materialized the GEOM column not using virtual column :

      alter table zip_all add column coord point not null
      update zip_all set coord = POINT(lat,lon);
      alter table zip_all_bis ADD SPATIAL INDEX(coord)

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12384 Cannot create SPATIAL/RTREE index on virtual column

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-10964 Support for NULL/NOT NULL syntax for virtual columns

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

          Web Link another disappointed user

          Activity

            People

              Unassigned Unassigned
              stephane@skysql.com VAROQUI Stephane
              Votes:
              7 Vote for this issue
              Watchers:
              9 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.