summaryrefslogtreecommitdiff
path: root/mysql-test/r/show_check.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/show_check.result')
-rw-r--r--mysql-test/r/show_check.result116
1 files changed, 58 insertions, 58 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result
index c3e7588a56d..ce1d8b9d187 100644
--- a/mysql-test/r/show_check.result
+++ b/mysql-test/r/show_check.result
@@ -12,51 +12,51 @@ insert into t1 values (1,2,2),(2,2,3),(3,2,4),(4,2,4);
-- after Bug#29394 is implemented.
check table t1 fast;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 27 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 27 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status Table is already up to date
check table t1 fast;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 27 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 27 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status Table is already up to date
check table t1 changed;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status OK
insert into t1 values (5,5,5);
check table t1 changed;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status OK
check table t1 medium;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status OK
check table t1 extended;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 5 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 5 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 check status OK
show index from t1;
@@ -85,10 +85,10 @@ ERROR 23000: Duplicate entry '5' for key 'PRIMARY'
-- after Bug#29394 is implemented.
optimize table t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 8 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 8 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 optimize status OK
optimize table t1;
@@ -157,10 +157,10 @@ insert into t1 values (1,1,1,0),(1,1,2,0),(1,1,3,0),(1,2,1,0),(1,2,2,0),(1,2,3,0
-- after Bug#29394 is implemented.
analyze table t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 7 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 7 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 analyze status OK
show index from t1;
@@ -174,10 +174,10 @@ t1 0 PRIMARY 4 f4 A 18 NULL NULL BTREE
-- after Bug#29394 is implemented.
repair table t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 128 7 Y 0 31 8
-def Op 253 10 6 Y 0 31 8
-def Msg_type 253 10 6 Y 0 31 8
-def Msg_text 250 393216 2 Y 0 31 8
+def Table 253 128 7 Y 0 39 8
+def Op 253 10 6 Y 0 39 8
+def Msg_type 253 10 6 Y 0 39 8
+def Msg_text 250 393216 2 Y 0 39 8
Table Op Msg_type Msg_text
test.t1 repair status OK
show index from t1;
@@ -886,8 +886,8 @@ latin1_bin latin1 47 Yes 1
----------------------------------------------------------------
SHOW CREATE DATABASE mysqltest1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Database 253 192 10 N 1 31 33
-def Create Database 253 3072 69 N 1 31 33
+def Database 253 192 10 N 1 39 33
+def Create Database 253 3072 69 N 1 39 33
Database Create Database
mysqltest1 CREATE DATABASE `mysqltest1` /*!40100 DEFAULT CHARACTER SET latin1 */
----------------------------------------------------------------
@@ -899,8 +899,8 @@ mysqltest1
----------------------------------------------------------------
SHOW CREATE TABLE t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 192 2 N 1 31 33
-def Create Table 253 3072 102 N 1 31 33
+def Table 253 192 2 N 1 39 33
+def Create Table 253 3072 102 N 1 39 33
Table Create Table
t1 CREATE TABLE `t1` (
`c` int(11) NOT NULL,
@@ -1061,10 +1061,10 @@ def test t1_bi INSERT def test t1 NULL SET @a = 1 ROW BEFORE NULL NULL OLD NEW N
----------------------------------------------------------------
SHOW CREATE VIEW v1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def View 253 192 2 N 1 31 33
-def Create View 253 3072 103 N 1 31 33
-def character_set_client 253 96 6 N 1 31 33
-def collation_connection 253 96 6 N 1 31 33
+def View 253 192 2 N 1 39 33
+def Create View 253 3072 103 N 1 39 33
+def character_set_client 253 96 6 N 1 39 33
+def collation_connection 253 96 6 N 1 39 33
View Create View character_set_client collation_connection
v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select 1 AS `1` binary binary
----------------------------------------------------------------
@@ -1088,12 +1088,12 @@ def test v1 select 1 AS `1` NONE NO root@localhost DEFINER binary binary UNDEFIN
----------------------------------------------------------------
SHOW CREATE PROCEDURE p1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Procedure 253 192 2 N 1 31 33
-def sql_mode 253 126 42 N 1 31 33
-def Create Procedure 253 3072 59 Y 0 31 33
-def character_set_client 253 96 6 N 1 31 33
-def collation_connection 253 96 6 N 1 31 33
-def Database Collation 253 96 17 N 1 31 33
+def Procedure 253 192 2 N 1 39 33
+def sql_mode 253 126 42 N 1 39 33
+def Create Procedure 253 3072 59 Y 0 39 33
+def character_set_client 253 96 6 N 1 39 33
+def collation_connection 253 96 6 N 1 39 33
+def Database Collation 253 96 17 N 1 39 33
Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
p1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
SELECT 1 binary binary latin1_swedish_ci
@@ -1143,12 +1143,12 @@ p1 def test p1 PROCEDURE NULL SQL SELECT 1 NULL NULL SQL NO CONTAINS SQL NULL DE
----------------------------------------------------------------
SHOW CREATE FUNCTION f1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Function 253 192 2 N 1 31 33
-def sql_mode 253 126 42 N 1 31 33
-def Create Function 253 3072 74 Y 0 31 33
-def character_set_client 253 96 6 N 1 31 33
-def collation_connection 253 96 6 N 1 31 33
-def Database Collation 253 96 17 N 1 31 33
+def Function 253 192 2 N 1 39 33
+def sql_mode 253 126 42 N 1 39 33
+def Create Function 253 3072 74 Y 0 39 33
+def character_set_client 253 96 6 N 1 39 33
+def collation_connection 253 96 6 N 1 39 33
+def Database Collation 253 96 17 N 1 39 33
Function sql_mode Create Function character_set_client collation_connection Database Collation
f1 NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
RETURN 1 binary binary latin1_swedish_ci
@@ -1268,8 +1268,8 @@ PRIMARY KEY (Codigo)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
show create table t1;
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def Table 253 64 2 N 1 31 7
-def Create Table 253 1024 445 N 1 31 7
+def Table 253 64 2 N 1 39 7
+def Create Table 253 1024 445 N 1 39 7
Table Create Table
t1 CREATE TABLE `t1` (
`Codigo` int(10) unsigned NOT NULL AUTO_INCREMENT,
View Lorry Controller Status