From b170d899e8772ea513a04fe8ae9c1f1ec125ea1c Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 3 Jul 2003 19:01:01 +0500 Subject: Test case for #570 added mysql-test/r/alias.result: Appropriate test result mysql-test/t/alias.test: Testcase for #570 --- mysql-test/t/alias.test | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'mysql-test/t/alias.test') diff --git a/mysql-test/t/alias.test b/mysql-test/t/alias.test index 5c6813d93aa..0dafc62430e 100644 --- a/mysql-test/t/alias.test +++ b/mysql-test/t/alias.test @@ -62,3 +62,22 @@ INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05 SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie; drop table t1; + +# +# test case for #570 +# + +CREATE TABLE t1 ( + AUFNR varchar(12) NOT NULL default '', + PLNFL varchar(6) NOT NULL default '', + VORNR varchar(4) NOT NULL default '', + xstatus_vor smallint(5) unsigned NOT NULL default '0', + +); + +INSERT INTO t1 VALUES ('40004712','000001','0010',9); +INSERT INTO t1 VALUES ('40004712','000001','0020',0); + +UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = +"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr +ASC LIMIT 1; -- cgit v1.2.1 From 8d7eb4a0e5b7d71e09c689fcc0318382c780302e Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 3 Jul 2003 20:57:51 +0500 Subject: Proposed fix for #751 Fields in key_expr (mysql_ha_read) wasn't linked to tables. Hmm. How did it work at all? mysql-test/r/alias.result: It's better to delete table after the test mysql-test/r/handler.result: appropriate result mysql-test/t/alias.test: it's better to drop table after test mysql-test/t/handler.test: test case for #751 sql/sql_handler.cc: fix_fields called --- mysql-test/t/alias.test | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/t/alias.test') diff --git a/mysql-test/t/alias.test b/mysql-test/t/alias.test index 0dafc62430e..57b46181fa1 100644 --- a/mysql-test/t/alias.test +++ b/mysql-test/t/alias.test @@ -81,3 +81,5 @@ INSERT INTO t1 VALUES ('40004712','000001','0020',0); UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = "40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr ASC LIMIT 1; + +drop table t1; -- cgit v1.2.1