diff options
| author | Sachin Setiya <sachin.setiya@maridb.com> | 2017-12-28 18:09:28 +0530 |
|---|---|---|
| committer | Sachin Setiya <sachin.setiya@maridb.com> | 2017-12-28 18:09:28 +0530 |
| commit | 1f4d1fbe2c0344c35b109cee45ac22ea69e43fb9 (patch) | |
| tree | bf1998c668ce169592e52f3f3455f61688e6555b /mysql-test/t/invisible_field_debug.test | |
| parent | 7a66e0ab8f52f3bd32850463daa05f9a2401e6b1 (diff) | |
| download | mariadb-git-bb-10.3-hidden.tar.gz | |
MDEV-14785 SYSTEM_INVISIBLE behavior not Consistentbb-10.3-hidden
//TODO patch commit message
Diffstat (limited to 'mysql-test/t/invisible_field_debug.test')
| -rw-r--r-- | mysql-test/t/invisible_field_debug.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/invisible_field_debug.test b/mysql-test/t/invisible_field_debug.test index 89a856fe970..3c2febf1606 100644 --- a/mysql-test/t/invisible_field_debug.test +++ b/mysql-test/t/invisible_field_debug.test @@ -8,6 +8,15 @@ set debug_dbug=@old_debug; desc t1; show create table t1; insert into t1 values(1); +##field should not be resolved in Item_field::set_field +--error ER_BAD_FIELD_ERROR +insert into t1(a, invisible) values(99,99); +--error ER_BAD_FIELD_ERROR +alter table t1 add constraint a check (invisble > 2); +set debug_dbug= "+d,test_pseudo_invisible"; +--error ER_BAD_FIELD_ERROR +create table t2(a int, b int as (invisible +2) virtual); +set debug_dbug=@old_debug; select * from t1; select invisible ,a from t1; drop table t1; |