-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2, 10.2.7
-
Fix Version/s: N/A
-
Component/s: Documentation, Server, Virtual Columns
-
Labels:None
-
Environment:openSUSE 42.2
The following create statement fails on 10.2.7:
CREATE TABLE t1 ( id INT NOT NULL AUTO_INCREMENT, v INT AS (id) VIRTUAL, PRIMARY KEY (id) ) ENGINE=InnoDB; |
Giving the error:
#1901 - Function or expression 'AUTO_INCREMENT' cannot be used in the GENERATED ALWAYS AS clause of `id`
The same create statement works fine on 10.1.22
- relates to
-
MDEV-12936 upgrade to 10.2.6 failed upon tables with virtual columns
-
- Closed
-