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/r/statistics.result | |
| 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/r/statistics.result')
| -rw-r--r-- | mysql-test/r/statistics.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/statistics.result b/mysql-test/r/statistics.result index a64a69ad368..ffaaf09acc8 100644 --- a/mysql-test/r/statistics.result +++ b/mysql-test/r/statistics.result @@ -1162,7 +1162,7 @@ test t2 idx4 1 6.2000 test t2 idx4 2 1.7222 test t2 idx4 3 1.1154 test t2 idx4 4 1.0000 -ALTER TABLE t2 DROP COLUMN b; +ALTER TABLE t2 DROP COLUMN b, DROP PRIMARY KEY, ADD PRIMARY KEY(a); SELECT * FROM mysql.index_stats ORDER BY index_name, prefix_arity, table_name; db_name table_name index_name prefix_arity avg_frequency test t2 idx2 1 7.0000 |