diff options
author | unknown <serg@serg.mylan> | 2004-01-30 08:56:32 +0100 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-01-30 08:56:32 +0100 |
commit | 150c99dffe2737ef4de7534bf297ff6943612cd0 (patch) | |
tree | 46985d2267b52275d4aa7732cabfd175446ea0bc /mysql-test/t | |
parent | 7bdc4c4faf0be072d0c31328bb21bc894f29c042 (diff) | |
download | mariadb-git-150c99dffe2737ef4de7534bf297ff6943612cd0.tar.gz |
cleanup
Diffstat (limited to 'mysql-test/t')
-rw-r--r-- | mysql-test/t/subselect.test | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 55ca8afe7fd..c4392186055 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1026,7 +1026,7 @@ drop table t1; # Bug 2479 # -CREATE TABLE tab_01 ( +CREATE TABLE t1 ( id int(11) NOT NULL auto_increment, ts timestamp NOT NULL, id_cns tinyint(3) unsigned NOT NULL default '0', @@ -1045,7 +1045,7 @@ UNIQUE KEY idx_cns_gen_anno (anno_dep,id_cns,generale,particolare), UNIQUE KEY idx_cns_par_anno (id_cns,anno_dep,tipo,particolare,bis) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1; -INSERT INTO tab_01 (id, ts, id_cns, id_desc_nota, id_publ_uff, tipo, f_aggiunte, +INSERT INTO t1 (id, ts, id_cns, id_desc_nota, id_publ_uff, tipo, f_aggiunte, anno_dep, data_dep, particolare, generale, bis) VALUES (NULL, NULL, 16, 29, 622, 'UNO', '', 1987, 1218, 2048, 9681, 0), (NULL, NULL, 50, 23, 1717, 'UNO', '', 1987, 1126, 1536, 13987, 0), @@ -1054,7 +1054,7 @@ anno_dep, data_dep, particolare, generale, bis) VALUES (NULL, NULL, 16, 125, 125, 'UNO', '', 1987, 0723, 1025, 10240, 0), (NULL, NULL, 16, 126, 126, 'UNO', '', 1987, 1204, 1026, 7089, 0); -CREATE TABLE tab_02 ( +CREATE TABLE t2 ( id tinyint(3) unsigned NOT NULL auto_increment, descr varchar(40) NOT NULL default '', f_servizi set('UNO','DUE') NOT NULL default '', @@ -1065,13 +1065,13 @@ data_agg int(8) unsigned NOT NULL default '0', PRIMARY KEY (id) ); -INSERT INTO tab_02 (id, descr, f_servizi, data_uno_min, data_due_min, +INSERT INTO t2 (id, descr, f_servizi, data_uno_min, data_due_min, max_anno_dep, data_agg) VALUES (16, 'C_UNO', 'UNO,DUE', 19000000, 30000000, 1987, 0), (50, 'C_TRE', 'UNO', 19000000, 30000000, 1990, 0); -SELECT cns.max_anno_dep = (SELECT s.anno_dep FROM tab_01 AS s WHERE +SELECT cns.max_anno_dep = (SELECT s.anno_dep FROM t1 AS s WHERE s.id_cns = cns.id ORDER BY s.anno_dep DESC LIMIT 1) AS PIPPO FROM -tab_02 AS cns; +t2 AS cns; -DROP TABLE tab_01, tab_02; +DROP TABLE t1, t2; |