summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-05-05 21:24:21 +0300
committerunknown <monty@mysql.com>2004-05-05 21:24:21 +0300
commit000f76cfb844eeda1c1c0092d4ab97f3f3acb6cb (patch)
tree7237dcd91649e057a85eb3caca141f3df5892db8 /mysql-test/t/derived.test
parentcd21f7ce40ac4c7d415544a5b2aa07b1278419ac (diff)
downloadmariadb-git-000f76cfb844eeda1c1c0092d4ab97f3f3acb6cb.tar.gz
after merge fixes
client/mysqldump.c: Fixed problem with multiple tables (--skip-quote didn't work properly for second table) myisam/myisamchk.c: after merge fix
Diffstat (limited to 'mysql-test/t/derived.test')
-rw-r--r--mysql-test/t/derived.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test
index f0d5a253bf4..fbfd3ccdef1 100644
--- a/mysql-test/t/derived.test
+++ b/mysql-test/t/derived.test
@@ -146,7 +146,7 @@ drop table t1;
#
CREATE TABLE `t1` (
`N` int(11) unsigned NOT NULL default '0',
- `M` tinyint(1) default '0',
+ `M` tinyint(1) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `t1` (N, M) VALUES (1, 0),(1, 0),(1, 0),(2, 0),(2, 0),(3, 0);
UPDATE `t1` AS P1 INNER JOIN (SELECT N FROM `t1` GROUP BY N HAVING Count(M) > 1) AS P2 ON P1.N = P2.N SET P1.M = 2;