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/t/func_str.test | |
| 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/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 33d89b3ca37..2fecf26d7c3 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -154,3 +154,12 @@ INSERT INTO t1 VALUES ('House passes the CAREERS bill'); SELECT CONCAT("</a>",RPAD("",(55 - LENGTH(title)),".")) from t1; DROP TABLE t1; + +# +# test for Bug #2290 "output truncated with ELT when using DISTINCT" +# + +CREATE TABLE t1 (i int, j int); +INSERT INTO t1 VALUES (1,1),(2,2); +SELECT DISTINCT i, ELT(j, '345', '34') FROM t1; +DROP TABLE t1;
\ No newline at end of file |