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

correct nullability for generated columns

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Currently all generated columns are created nullable. Because we don't know whether an expression may be NULL or not until we create an item tree and fix_field it. And this only t happens after the .frm is written.

      A way to workaround it is to create all generated fields nullable, as now. But after the .frm is opened and fields are fixes — check maybe_null property of all generated columns and mark them not nullable, as appropriate (set null_ptr=0, etc). By doing that we'll lose one bit in the null bitmap per generated not nullable field.

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              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.