diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2017-08-12 18:52:38 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2017-08-14 19:45:59 +0200 |
| commit | 04b288ae47dec8bd1a41902889956c4b0d711cc5 (patch) | |
| tree | 20f850d7109609320dedab2484040ab59b88e1a8 /mysql-test/suite/funcs_1/datadict | |
| parent | 28ddc9b3bbbb56a3146779b1f0ccf42a6ef50f2b (diff) | |
| download | mariadb-git-04b288ae47dec8bd1a41902889956c4b0d711cc5.tar.gz | |
MDEV-11114 Cannot drop column referenced by CHECK constraint
SQL Standard behavior for DROP COLUMN xxx RESTRICT:
* If a constraint (UNIQUE or CHECK) uses only the dropped column,
it's automatically dropped too. If it uses many columns - an error.
Diffstat (limited to 'mysql-test/suite/funcs_1/datadict')
| -rw-r--r-- | mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc | 6 |
1 files changed, 0 insertions, 6 deletions
diff --git a/mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc b/mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc index ee8a923485a..cda5144ecc7 100644 --- a/mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc +++ b/mysql-test/suite/funcs_1/datadict/is_key_column_usage.inc @@ -232,12 +232,6 @@ eval $my_select; ALTER TABLE db_datadict.t1_my_tablex ADD UNIQUE my_idx (f4,first_col); eval $my_select; # -# Check DROP COLUMN -eval $my_select; -ALTER TABLE db_datadict.t1_my_tablex -DROP COLUMN first_col; -eval $my_select; -# # Check impact of DROP TABLE SELECT table_name, column_name FROM information_schema.key_column_usage |