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

Primary key cannot be defined upon persistent virtual column

Details

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

    Description

      ERROR 1903 (HY000): Primary key cannot be defined upon a computed column .

      Virtual column was a nice way to remove stuff like
      PRIMARY KEY (`COD_INV`, `COD_FAM`, `COD_MAG`, `COD_FIL`, `COD_ID_INV`)

      • It's a bad practice to use triggers
      • It's a bad practice to use hidden primary key ,
      • It's a bad practice to use virtual column .

      What could we advice that can be transparent to the application layer to fixe such bad design for InnoDB.

      Rewrite the application is not always a political correct answer.

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-8135 Support primary keys on virtual columns

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • 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

          Activity

            Ascending order - Click to sort in descending order
            stephane@skysql.com VAROQUI Stephane created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Summary Primary key cannot be defined upon persitent virtual column Primary key cannot be defined upon persistent virtual column
            elenst Elena Stepanova made changes -
            Affects Version/s 5.5.34 [ 13700 ]
            Affects Version/s 10.0.7 [ 14100 ]
            Issue Type Bug [ 1 ] Task [ 3 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 33760 ] MariaDB v2 [ 42376 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42376 ] MariaDB v3 [ 61303 ]
            serg Sergei Golubchik made changes -
            greenman Ian Gilfillan made changes -
            Epic Link MDEV-10137 [ 56868 ]
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            Parent MDEV-10137 [ 56868 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            monty Michael Widenius made changes -
            Epic Link MDEV-10137 [ 56868 ]
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            monty Michael Widenius made changes -
            Parent MDEV-10137 [ 56868 ]
            Issue Type Technical task [ 7 ] Task [ 3 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            NRE Projects RM_105_CANDIDATE
            julien.fritsch Julien Fritsch made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Ralf Gebhardt [ ralf.gebhardt@mariadb.com ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 61303 ] MariaDB v4 [ 130191 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Component/s Virtual Columns [ 10803 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 139074
            AirFocus AirFocus made changes -
            Summary Primary key cannot be defined upon persistent virtual column Primary key cannot be defined upon persistent virtual column

            People

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