Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.7, 10.2(EOL)
-
None
-
openSUSE 42.2
Description
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
Attachments
Issue Links
- relates to
-
MDEV-12936 upgrade to 10.2.6 failed upon tables with virtual columns
- Closed