[MDEV-13320] virtual columns fail when expression references auto increment column Created: 2017-07-13 Updated: 2021-05-13 Resolved: 2017-07-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation, Server, Virtual Columns |
| Affects Version/s: | 10.2.7, 10.2 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Taylor Honsowetz | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
openSUSE 42.2 |
||
| Issue Links: |
|
||||||||
| Description |
|
The following create statement fails on 10.2.7:
Giving the error: The same create statement works fine on 10.1.22 |
| Comments |
| Comment by Sergei Golubchik [ 2017-07-13 ] |
|
This is intentional. Generated columns do not work with auto-incremented columns, they won't see the value. We've introduced the limitation in In 10.1 (and earlier version) this was allowed, but it did not work correctly. To let generated columns work with auto-increment would need a rather big internal refactoring. We want to do that, but it's not a change for 10.2. |
| Comment by Taylor Honsowetz [ 2017-07-13 ] |
|
If this is intentional, it should be included within the documentation for AUTO_INCREMENT. Currently this is an undocumented incompatible change between 10.1 and 10.2. |
| Comment by Ian Gilfillan [ 2017-07-14 ] |
|
Documented in: |