summaryrefslogtreecommitdiff
path: root/mysql-test/t/invisible_field_debug.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/invisible_field_debug.test')
-rw-r--r--mysql-test/t/invisible_field_debug.test9
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;