diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-11-30 12:58:05 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2006-11-30 12:58:05 +0200 |
| commit | ef42631b5379254fc41fa42a2a75e23dd4fc1f64 (patch) | |
| tree | c58724a249a82f688b96f1728a5c28bebe37f728 | |
| parent | 46d05688887181809b9ba648aa43a3e684e285ba (diff) | |
| download | mariadb-git-ef42631b5379254fc41fa42a2a75e23dd4fc1f64.tar.gz | |
func_gconcat.result, func_gconcat.test:
disabled warnings because their order is undeterministic
mysql-test/t/func_gconcat.test:
disabled warnings because their order is undeterministic
mysql-test/r/func_gconcat.result:
disabled warnings because their order is undeterministic
| -rw-r--r-- | mysql-test/r/func_gconcat.result | 19 | ||||
| -rw-r--r-- | mysql-test/t/func_gconcat.test | 2 |
2 files changed, 2 insertions, 19 deletions
diff --git a/mysql-test/r/func_gconcat.result b/mysql-test/r/func_gconcat.result index 53bcbfafdd5..655cdc4131c 100644 --- a/mysql-test/r/func_gconcat.result +++ b/mysql-test/r/func_gconcat.result @@ -64,25 +64,6 @@ grp group_concat(a order by a,d+c-ascii(c)-a) 1 1 2 2,3 3 4,5,6,7,8,9 -Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'a ' -Warning 1292 Truncated incorrect DOUBLE value: 'a ' -Warning 1292 Truncated incorrect DOUBLE value: 'a ' -Warning 1292 Truncated incorrect DOUBLE value: 'b ' -Warning 1292 Truncated incorrect DOUBLE value: 'b ' -Warning 1292 Truncated incorrect DOUBLE value: 'c ' -Warning 1292 Truncated incorrect DOUBLE value: 'a ' -Warning 1292 Truncated incorrect DOUBLE value: 'E ' -Warning 1292 Truncated incorrect DOUBLE value: 'b ' -Warning 1292 Truncated incorrect DOUBLE value: 'C ' -Warning 1292 Truncated incorrect DOUBLE value: 'b ' -Warning 1292 Truncated incorrect DOUBLE value: 'D ' -Warning 1292 Truncated incorrect DOUBLE value: 'd ' -Warning 1292 Truncated incorrect DOUBLE value: 'd ' -Warning 1292 Truncated incorrect DOUBLE value: 'd ' -Warning 1292 Truncated incorrect DOUBLE value: 'd ' -Warning 1292 Truncated incorrect DOUBLE value: 'c ' -Warning 1292 Truncated incorrect DOUBLE value: 'D ' select grp,group_concat(a order by d+c-ascii(c),a) from t1 group by grp; grp group_concat(a order by d+c-ascii(c),a) 1 1 diff --git a/mysql-test/t/func_gconcat.test b/mysql-test/t/func_gconcat.test index 610c93dfb0f..bdc267d56db 100644 --- a/mysql-test/t/func_gconcat.test +++ b/mysql-test/t/func_gconcat.test @@ -29,7 +29,9 @@ select grp,group_concat(c order by c) from t1 group by grp; select grp,group_concat(c order by c desc) from t1 group by grp; select grp,group_concat(d order by a) from t1 group by grp; select grp,group_concat(d order by a desc) from t1 group by grp; +--disable_warnings select grp,group_concat(a order by a,d+c-ascii(c)-a) from t1 group by grp; +--enable_warnings select grp,group_concat(a order by d+c-ascii(c),a) from t1 group by grp; select grp,group_concat(c order by 1) from t1 group by grp; select grp,group_concat(distinct c order by c) from t1 group by grp; |