diff options
Diffstat (limited to 'mysql-test/main/cte_recursive.result')
-rw-r--r-- | mysql-test/main/cte_recursive.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/cte_recursive.result b/mysql-test/main/cte_recursive.result index 7bf85016f11..bf95ba11a7d 100644 --- a/mysql-test/main/cte_recursive.result +++ b/mysql-test/main/cte_recursive.result @@ -4932,7 +4932,7 @@ t2 CREATE TABLE `t2` ( `mid` int(11) DEFAULT NULL, `name` text DEFAULT NULL, `mname` text DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci insert into t2 WITH RECURSIVE cteReports (level, id, mid, name) AS ( @@ -5013,7 +5013,7 @@ t2 CREATE TABLE `t2` ( `mid` int(11) DEFAULT NULL, `name` text DEFAULT NULL, `mname` text DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci set @@sql_mode=default; drop table t1,t2; # |