revision-id: d07a6e33dd8738d7521e376ca55d5ae3062eb3cf (mariadb-10.3.10-88-gd07a6e33dd8) parent(s): 02b70702d9df049433c4d4d276a9c15d0aaf5427 author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2018-11-20 17:31:07 +0100 message: Check that default() do not see invisible field. --- mysql-test/main/invisible_field_debug.result | 2 ++ mysql-test/main/invisible_field_debug.test | 2 ++ 2 files changed, 4 insertions(+) diff --git a/mysql-test/main/invisible_field_debug.result b/mysql-test/main/invisible_field_debug.result index b3c84d18333..0ea8ab12de8 100644 --- a/mysql-test/main/invisible_field_debug.result +++ b/mysql-test/main/invisible_field_debug.result @@ -17,6 +17,8 @@ a invisible 1 9 insert into t1(a, invisible) values(99,99); ERROR 42S22: Unknown column 'invisible' in 'field list' +select default(invisible) from t1; +ERROR 42S22: Unknown column 'invisible' in 'field list' insert into t1(invisible) values(99); ERROR 42S22: Unknown column 'invisible' in 'field list' insert into t_tmp select a, invisible from t1; diff --git a/mysql-test/main/invisible_field_debug.test b/mysql-test/main/invisible_field_debug.test index c1d6899d16e..86252512386 100644 --- a/mysql-test/main/invisible_field_debug.test +++ b/mysql-test/main/invisible_field_debug.test @@ -13,6 +13,8 @@ select a , invisible from t1; --error ER_BAD_FIELD_ERROR insert into t1(a, invisible) values(99,99); --error ER_BAD_FIELD_ERROR +select default(invisible) from t1; +--error ER_BAD_FIELD_ERROR insert into t1(invisible) values(99); insert into t_tmp select a, invisible from t1; --error ER_WRONG_VALUE_COUNT_ON_ROW