summaryrefslogtreecommitdiff
path: root/mysql-test/main/sp-anchor-row-type-cursor.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/sp-anchor-row-type-cursor.result')
-rw-r--r--mysql-test/main/sp-anchor-row-type-cursor.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/main/sp-anchor-row-type-cursor.result b/mysql-test/main/sp-anchor-row-type-cursor.result
index add771c534c..e3c6e1fc167 100644
--- a/mysql-test/main/sp-anchor-row-type-cursor.result
+++ b/mysql-test/main/sp-anchor-row-type-cursor.result
@@ -89,7 +89,7 @@ t2 CREATE TABLE `t2` (
`rec.b` varchar(10) DEFAULT NULL,
`rec.c` double DEFAULT NULL,
`rec.d` decimal(10,0) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
CALL p1();
ERROR 42S02: Table 'test.t1' doesn't exist
@@ -118,7 +118,7 @@ t2 CREATE TABLE `t2` (
`rec.b` varchar(10) DEFAULT NULL,
`rec.c` double DEFAULT NULL,
`rec.d` decimal(10,0) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP TABLE t1;
DROP PROCEDURE p1;
#
@@ -146,7 +146,7 @@ t2 CREATE TABLE `t2` (
`rec.b` varchar(10) DEFAULT NULL,
`rec.c` double DEFAULT NULL,
`rec.d` decimal(10,0) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP VIEW v1;
DROP TABLE t1;
DROP PROCEDURE p1;
@@ -175,7 +175,7 @@ t2 CREATE TABLE `t2` (
`rec.b` varchar(10) DEFAULT NULL,
`rec.c` double DEFAULT NULL,
`rec.d` decimal(10,0) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP VIEW v1;
DROP TABLE t1;
DROP PROCEDURE p1;
@@ -999,7 +999,7 @@ CALL p1();
Table Create Table
t1 CREATE TABLE `t1` (
`rec1.a` int(11) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
DROP PROCEDURE p1;
#
# MDEV-14139 Anchored data types for variables
@@ -1024,10 +1024,10 @@ t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` varchar(3) DEFAULT NULL,
`c` time DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
Table Create Table
t2 CREATE TABLE `t2` (
`a` int(11) DEFAULT NULL,
`b` varchar(3) DEFAULT NULL,
`c` time DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci