diff options
| author | Sachin <sachin.setiya@mariadb.com> | 2018-11-27 18:04:39 +0530 |
|---|---|---|
| committer | Sachin <sachin.setiya@mariadb.com> | 2018-12-31 20:35:37 +0530 |
| commit | 05f77a8ec98daab1221a4967cf04c434ba5129eb (patch) | |
| tree | 62967e0f360f72fc57f4d32eb09fc440f4bf4e4f /mysql-test | |
| parent | 83b63f622020d248edec8c4fc63f63402c405fd8 (diff) | |
| download | mariadb-git-05f77a8ec98daab1221a4967cf04c434ba5129eb.tar.gz | |
Architectre change
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/main/long_unique.result | 8 | ||||
| -rw-r--r-- | mysql-test/main/long_unique.test | 2 |
2 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/main/long_unique.result b/mysql-test/main/long_unique.result index 9fbe63d4e7a..c8b44b35cb7 100644 --- a/mysql-test/main/long_unique.result +++ b/mysql-test/main/long_unique.result @@ -367,7 +367,7 @@ Key Start Len Index Type 1 3063 8 multip. ulonglong NULL 2 3055 8 multip. ulonglong NULL 3 3047 8 multip. ulonglong NULL -4 3039 8 multip. ulonglong prefix NULL +4 3039 8 multip. ulonglong NULL select * from information_schema.columns where table_schema = 'test' and table_name = 't1'; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT IS_GENERATED GENERATION_EXPRESSION def test t1 a 1 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob UNI select,insert,update,references NEVER NULL @@ -721,9 +721,9 @@ Recordlength: 5092 table description: Key Start Len Index Type -1 5081 8 multip. ulonglong prefix NULL -2 5073 8 multip. ulonglong prefix NULL -3 5065 8 multip. ulonglong prefix NULL +1 5081 8 multip. ulonglong NULL +2 5073 8 multip. ulonglong NULL +3 5065 8 multip. ulonglong NULL 4 5057 8 multip. ulonglong NULL select * from information_schema.columns where table_schema = 'test' and table_name = 't1'; TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT IS_GENERATED GENERATION_EXPRESSION diff --git a/mysql-test/main/long_unique.test b/mysql-test/main/long_unique.test index c87019492a7..65fcdfcc9e4 100644 --- a/mysql-test/main/long_unique.test +++ b/mysql-test/main/long_unique.test @@ -198,7 +198,7 @@ show create table t1; alter table t1 add column db_row_hash_7 int, add column db_row_hash_5 int , add column db_row_hash_4 int ; alter table t1 drop column db_row_hash_7,drop column db_row_hash_3, drop column db_row_hash_4; desc t1; ---echo #this show now break anything; +--echo #this should not break anything; --error ER_DUP_ENTRY insert into t1 values(1,2,3,4,5,6,23,5,6); --echo #this should also drop the unique index; |