diff options
Diffstat (limited to 'mysql-test/suite/vcol/t/vcol_sql_mode_time.test')
-rw-r--r-- | mysql-test/suite/vcol/t/vcol_sql_mode_time.test | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/mysql-test/suite/vcol/t/vcol_sql_mode_time.test b/mysql-test/suite/vcol/t/vcol_sql_mode_time.test index 05160a43ebb..2ce2a9eb5d7 100644 --- a/mysql-test/suite/vcol/t/vcol_sql_mode_time.test +++ b/mysql-test/suite/vcol/t/vcol_sql_mode_time.test @@ -47,32 +47,29 @@ DROP TABLE t1; --echo # NOT OK: lower FSP + virtual index -#--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED +--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED CREATE TABLE t1 ( t TIME(4), d TIME, v TIME(3) AS (t) VIRTUAL, KEY(v,d) ); -DROP TABLE t1; -#--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED +--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED CREATE TABLE t1 ( t TIME(4), d TIME, v TIME(3) AS (COALESCE(t)) VIRTUAL, KEY(v,d) ); -DROP TABLE t1; -#--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED +--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED CREATE TABLE t1 ( t TIME(4), d TIME, v TIME(3) AS ('2001-01-01 10:20:30.1234') VIRTUAL, KEY(v,d) ); -DROP TABLE t1; --echo # OK: lower FSP + ROUND + virtual index @@ -111,13 +108,12 @@ SET sql_mode=DEFAULT; --echo # MDEV-20423 Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with TIME_ROUND_FRACTIONAL --echo # -#--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED +--error ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED CREATE TABLE t1 ( a TIME(6), v VARCHAR(30) GENERATED ALWAYS AS (CAST(a AS TIME(3))) VIRTUAL, KEY (v) ); -DROP TABLE t1; CREATE TABLE t1 ( a TIME(6), |