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

SYSTEM_INVISIBLE behaviour not consistent

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.3
    • 10.3.5
    • Server
    • None
    • All

    Description

      Currently System Invisible behaviour is inconsistent. We can not create index on them , but we can create virtual column based on them and also check constraint based on SYSTEM_INVISIBLE. This should not be allowed.
      There is one more issue , We can also insert data into SYSTEM_INVISIBLE column if we use
      insert like "Insert into t1(a, invisible) values(1,1)" , (invisible is sytem_invisible column). Which is wrong

      Attachments

        1. a.patch
          2 kB
          Sachin Setiya

        Activity

          People

            serg Sergei Golubchik
            sachin.setiya.007 Sachin Setiya (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.