Bug #84496 | CHECK TABLE should support checking virtual column expressions | ||
---|---|---|---|
Submitted: | 12 Jan 2017 21:47 | Modified: | 13 Jan 2017 7:26 |
Reporter: | Morgan Tocker | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S4 (Feature request) |
Version: | 8.0.1 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[12 Jan 2017 21:47]
Morgan Tocker
[12 Jan 2017 21:58]
Morgan Tocker
# demonstrating that testcase does not produce warnings on reads: mysql> select * from t1\G *************************** 1. row *************************** a: 1 b: b c: c bc: bc *************************** 2. row *************************** a: 2 b: bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb c: ccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc bc: bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb 2 rows in set (0.00 sec)
[12 Jan 2017 22:19]
Gabriela Ferrara
I wonder if the discussion shouldn't go beyond and make it check on ALTER TABLES (where VIRTUAL columns are done WITHOUT VALIDATION by default). Make it WITH VALIDATION for virtual if STRICT mode is enabled. The documentation itself says it can cause weird behavior for overflow cases, but it feels inconsistent allowing this to run in a STRICT environment.
[13 Jan 2017 7:25]
MySQL Verification Team
Hello Morgan, Thank you for the report and feature request! Thanks, Umesh