summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-05-05 21:46:16 +0300
committerunknown <monty@mysql.com>2004-05-05 21:46:16 +0300
commit19d3f588f2165ed5025fe0b88c856474b913d6b8 (patch)
tree9a636746150703219815452956e952cfd61dca0d /mysql-test
parente5d43578fdcd87e1f774782ceed811b6f2b0a044 (diff)
downloadmariadb-git-19d3f588f2165ed5025fe0b88c856474b913d6b8.tar.gz
After merge fixes
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/show_check.result4
-rw-r--r--mysql-test/r/subselect.result4
-rw-r--r--mysql-test/t/show_check.test2
-rw-r--r--mysql-test/t/subselect.test4
4 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result
index c462a88ac1b..86a90d553da 100644
--- a/mysql-test/r/show_check.result
+++ b/mysql-test/r/show_check.result
@@ -90,8 +90,8 @@ test_set set( 'val1', 'val2', 'val3' ) not null default '',
name char(20) default 'O''Brien' comment 'O''Brien as default',
c int not null comment 'int column',
`c-b` int comment 'name with a minus',
-`space 2` int comment 'name with a space',
-) comment = 'it\'s a table' ;
+`space 2` int comment 'name with a space'
+ ) comment = 'it\'s a table' ;
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index a6e5d90b6c4..eab80cb9462 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -1151,7 +1151,7 @@ CREATE TABLE `t1` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`pseudo` varchar(35) character set latin1 NOT NULL default '',
PRIMARY KEY (`id`),
-UNIQUE KEY `pseudo` (`pseudo`),
+UNIQUE KEY `pseudo` (`pseudo`)
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
INSERT INTO t1 (pseudo) VALUES ('test');
SELECT 0 IN (SELECT 1 FROM t1 a);
@@ -1256,7 +1256,7 @@ CREATE TABLE `t1` (
`email` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
-UNIQUE KEY `pseudo` (`pseudo`),
+UNIQUE KEY `pseudo` (`pseudo`)
) ENGINE=MyISAM CHARSET=latin1 PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
INSERT INTO t1 (id,pseudo,email) VALUES (1,'test','test'),(2,'test1','test1');
SELECT pseudo as a, pseudo as b FROM t1 GROUP BY (SELECT a) ORDER BY (SELECT id*1);
diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test
index b0307af19bb..deb95af9168 100644
--- a/mysql-test/t/show_check.test
+++ b/mysql-test/t/show_check.test
@@ -55,7 +55,7 @@ create table t1 (
name char(20) default 'O''Brien' comment 'O''Brien as default',
c int not null comment 'int column',
`c-b` int comment 'name with a minus',
- `space 2` int comment 'name with a space',
+ `space 2` int comment 'name with a space'
) comment = 'it\'s a table' ;
show create table t1;
set sql_quote_show_create=0;
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index bf7a8a6292d..1b5bb807b97 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -673,7 +673,7 @@ CREATE TABLE `t1` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`pseudo` varchar(35) character set latin1 NOT NULL default '',
PRIMARY KEY (`id`),
- UNIQUE KEY `pseudo` (`pseudo`),
+ UNIQUE KEY `pseudo` (`pseudo`)
) ENGINE=MyISAM PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
INSERT INTO t1 (pseudo) VALUES ('test');
SELECT 0 IN (SELECT 1 FROM t1 a);
@@ -776,7 +776,7 @@ CREATE TABLE `t1` (
`email` varchar(60) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
- UNIQUE KEY `pseudo` (`pseudo`),
+ UNIQUE KEY `pseudo` (`pseudo`)
) ENGINE=MyISAM CHARSET=latin1 PACK_KEYS=1 ROW_FORMAT=DYNAMIC;
INSERT INTO t1 (id,pseudo,email) VALUES (1,'test','test'),(2,'test1','test1');
SELECT pseudo as a, pseudo as b FROM t1 GROUP BY (SELECT a) ORDER BY (SELECT id*1);