From 05f77a8ec98daab1221a4967cf04c434ba5129eb Mon Sep 17 00:00:00 2001 From: Sachin Date: Tue, 27 Nov 2018 18:04:39 +0530 Subject: Architectre change --- mysql-test/main/long_unique.result | 8 ++++---- mysql-test/main/long_unique.test | 2 +- 2 files changed, 5 insertions(+), 5 deletions(-) (limited to 'mysql-test') 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; -- cgit v1.2.1