[MDEV-8135] Support primary keys on virtual columns Created: 2015-05-11 Updated: 2016-10-07 Resolved: 2015-11-05 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Virtual Columns |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Minor |
| Reporter: | Artur Formella | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | persistent, primary_key, virtual_columns | ||
| Issue Links: |
|
||||||||
| Description |
|
From the manual I can find out that:
Why PERSISTENT column is Computed when it is stored in the table?
I have an error: It would be very useful to set up an ID algorithm using DDL |
| Comments |
| Comment by Elena Stepanova [ 2015-05-11 ] |
Because it is computed; as per the general definition, "its value automatically calculated using a deterministic expression, in particular from the values of other fields in the table". The fact that primary keys are not supported is also explicitly documented here: https://mariadb.com/kb/en/mariadb/virtual-computed-columns/. If you wish, we can treat this report as a feature request. |
| Comment by Artur Formella [ 2015-05-12 ] |
Yes, It would be great. Thank you. |
| Comment by Sergei Golubchik [ 2015-11-05 ] |
|
Duplicate of MDEV-5590 |