diff options
| author | unknown <hf@deer.(none)> | 2003-07-03 19:01:01 +0500 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2003-07-03 19:01:01 +0500 |
| commit | b170d899e8772ea513a04fe8ae9c1f1ec125ea1c (patch) | |
| tree | 66f5d194440e0934b01e078ca1d1b47e50726459 /mysql-test/r/alias.result | |
| parent | 31815f3ad31c88dc0cb20ee792ced4b8dd72092f (diff) | |
| download | mariadb-git-b170d899e8772ea513a04fe8ae9c1f1ec125ea1c.tar.gz | |
Test case for #570 added
mysql-test/r/alias.result:
Appropriate test result
mysql-test/t/alias.test:
Testcase for #570
Diffstat (limited to 'mysql-test/r/alias.result')
| -rw-r--r-- | mysql-test/r/alias.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/alias.result b/mysql-test/r/alias.result index 3954c2d0170..55397705bdf 100644 --- a/mysql-test/r/alias.result +++ b/mysql-test/r/alias.result @@ -59,3 +59,14 @@ SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA', Kundentyp kategorie Privat (Private Nutzung) Mobilfunk drop table t1; +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; |