diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2018-11-20 17:31:07 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2018-11-20 17:31:07 +0100 |
| commit | d07a6e33dd8738d7521e376ca55d5ae3062eb3cf (patch) | |
| tree | 6b1417b5a6584371162736d9a009ee8152588d9e /mysql-test | |
| parent | 02b70702d9df049433c4d4d276a9c15d0aaf5427 (diff) | |
| download | mariadb-git-d07a6e33dd8738d7521e376ca55d5ae3062eb3cf.tar.gz | |
Check that default() do not see invisible field.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/invisible_field_debug.result | 2 | ||||
| -rw-r--r-- | mysql-test/main/invisible_field_debug.test | 2 |
2 files changed, 4 insertions, 0 deletions
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 |