diff options
| author | monty@hundin.mysql.fi <> | 2002-01-02 21:29:41 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-01-02 21:29:41 +0200 |
| commit | 4b877e0088e6f32a606ffaa0fb3c94afb0b24388 (patch) | |
| tree | ef8afaf7a0fed42b30ef0d9d38acccc992b5f87d /mysql-test/r/show_check.result | |
| parent | 5b77e3391050f1f585ab28816ad31761d93e8264 (diff) | |
| download | mariadb-git-4b877e0088e6f32a606ffaa0fb3c94afb0b24388.tar.gz | |
Added macros for nice TIMESPEC usage.
Fixes for building MySQL with gcc 3.0
Added SIGNED / UNSIGNED casts
Fixed core dump bug in net_clear() with libmysqld.
Back to using semaphores in query cache.
Added 'Null' and 'Index_type' to SHOW INDEX.
Diffstat (limited to 'mysql-test/r/show_check.result')
| -rw-r--r-- | mysql-test/r/show_check.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index f66bf22b224..2530e5b09fb 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -21,10 +21,10 @@ check table t1 type=extended; Table Op Msg_type Msg_text test.t1 check status OK show index from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 0 PRIMARY 1 a A 5 NULL NULL -t1 1 b 1 b A 1 NULL NULL -t1 1 b 2 c A 5 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 a A 5 NULL NULL BTREE +t1 1 b 1 b A 1 NULL NULL BTREE +t1 1 b 2 c A 5 NULL NULL BTREE insert into t1 values (5,5,5); Duplicate entry '5' for key 1 optimize table t1; @@ -54,20 +54,20 @@ analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK show index from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 0 PRIMARY 1 f1 A 1 NULL NULL -t1 0 PRIMARY 2 f2 A 3 NULL NULL -t1 0 PRIMARY 3 f3 A 9 NULL NULL -t1 0 PRIMARY 4 f4 A 18 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 f1 A 1 NULL NULL BTREE +t1 0 PRIMARY 2 f2 A 3 NULL NULL BTREE +t1 0 PRIMARY 3 f3 A 9 NULL NULL BTREE +t1 0 PRIMARY 4 f4 A 18 NULL NULL BTREE repair table t1; Table Op Msg_type Msg_text test.t1 repair status OK show index from t1; -Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment -t1 0 PRIMARY 1 f1 A 1 NULL NULL -t1 0 PRIMARY 2 f2 A 3 NULL NULL -t1 0 PRIMARY 3 f3 A 9 NULL NULL -t1 0 PRIMARY 4 f4 A 18 NULL NULL +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 f1 A 1 NULL NULL BTREE +t1 0 PRIMARY 2 f2 A 3 NULL NULL BTREE +t1 0 PRIMARY 3 f3 A 9 NULL NULL BTREE +t1 0 PRIMARY 4 f4 A 18 NULL NULL BTREE drop table t1; create temporary table t1 (a int not null); show create table t1; |