[MDEV-20472] Document MDEV-18156 - sql_mode dependency in vcol expressions Created: 2019-09-03 Updated: 2022-03-12 Resolved: 2019-09-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Documentation |
| Fix Version/s: | 10.2.27, 10.3.18, 10.4.8, 10.5.0 |
| Type: | Task | Priority: | Blocker |
| Reporter: | Alexander Barkov | Assignee: | Kenneth Dyer (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
I have pushed two patches for Part 1: Part 2: Please add documentation for Short description: The fix disallows generated column expressions that depend on:
if a generated columns is:
Note, virtual columns that depend on the mentioned flags, These table modification statements:
introducing a new "bad" generated column are not allowed The server can still open old tables (created by older server versions) This patch fixes the problem for two sql_mode flags only. Thanks. |
| Comments |
| Comment by Alexander Barkov [ 2019-09-07 ] |
|
Update: In earlier versions only a warning is issued, even in the table modification statements. The third patch is here: |