summaryrefslogtreecommitdiff
path: root/mysql-test/r/strict.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/strict.result')
-rw-r--r--mysql-test/r/strict.result100
1 files changed, 96 insertions, 4 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result
index bdb7576f95e..a835f021d3a 100644
--- a/mysql-test/r/strict.result
+++ b/mysql-test/r/strict.result
@@ -1183,7 +1183,7 @@ drop table t1;
create table t1 (col1 tinyint);
drop procedure if exists t1;
Warnings:
-Note 1305 PROCEDURE t1 does not exist
+Note 1305 PROCEDURE test.t1 does not exist
create procedure t1 () begin declare exit handler for sqlexception
select'a'; insert into t1 values (200); end;|
call t1();
@@ -1304,8 +1304,42 @@ set @@sql_mode= @org_mode;
set @@sql_mode='traditional';
create table t1 (i int)
comment '123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*123456789*';
-ERROR HY000: Comment for table 't1' is too long (max = 60)
+ERROR HY000: Comment for table 't1' is too long (max = 2048)
create table t1 (
i int comment
'123456789*123456789*123456789*123456789*
@@ -1314,8 +1348,28 @@ i int comment
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*');
-ERROR HY000: Comment for field 'i' is too long (max = 255)
+ERROR HY000: Comment for field 'i' is too long (max = 1024)
set @@sql_mode= @org_mode;
create table t1
(i int comment
@@ -1325,9 +1379,29 @@ create table t1
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*');
Warnings:
-Warning 1629 Comment for field 'i' is too long (max = 255)
+Warning 1629 Comment for field 'i' is too long (max = 1024)
select column_name, column_comment from information_schema.columns where
table_schema = 'test' and table_name = 't1';
column_name column_comment
@@ -1337,6 +1411,24 @@ i 123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*123456789*
+ 123456789*123456789*123456789*12345
drop table t1;
set names utf8;
create table t1 (i int)
View Lorry Controller Status