diff options
| author | vva@eagle.mysql.r18.ru <> | 2004-01-21 02:18:51 +0400 |
|---|---|---|
| committer | vva@eagle.mysql.r18.ru <> | 2004-01-21 02:18:51 +0400 |
| commit | 4a668f95ce1ca17cb56f68d3a57fceb76e189fc5 (patch) | |
| tree | 699c2742fd01d0460be8f03a8029066a29cc9fd7 /mysql-test/r | |
| parent | f982614ae2c007ab46b9b13779faa18fcb91ace1 (diff) | |
| download | mariadb-git-4a668f95ce1ca17cb56f68d3a57fceb76e189fc5.tar.gz | |
added test for bug #2290 "output truncated with ELT when using DISTINCT"
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/func_str.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 35a5ba70e86..7d2668c8cf6 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -266,3 +266,10 @@ CONCAT("</a>",RPAD("",(55 - LENGTH(title)),".")) NULL </a>.......................... DROP TABLE t1; +CREATE TABLE t1 (i int, j int); +INSERT INTO t1 VALUES (1,1),(2,2); +SELECT DISTINCT i, ELT(j, '345', '34') FROM t1; +i ELT(j, '345', '34') +1 345 +2 34 +DROP TABLE t1; |