diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-05-21 20:35:58 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-05-21 20:35:58 +0300 |
| commit | a34e76c66abea6c4971cbdfe3b13cda272a81ca2 (patch) | |
| tree | 9b8ca6f7c941d22f516a5c39bd0013d8ab35310c /mysql-test/r/func_concat.result | |
| parent | db2032fd7311c01e6f9d795a64be7144cf4b0a69 (diff) | |
| download | mariadb-git-a34e76c66abea6c4971cbdfe3b13cda272a81ca2.tar.gz | |
Fixes for gcc 3.1
Fixed bug in new code for regexp LIKE NULL
BUILD/SETUP.sh:
Fixes for gcc 3.1
BUILD/compile-solaris-sparc-debug:
Fixes for gcc 3.1
BUILD/compile-solaris-sparc-purify:
Fixes for gcc 3.1
BUILD/compile-solaris-sparc:
Fixes for gcc 3.1
Docs/manual.texi:
Fixed typo
include/violite.h:
Fixes for gcc 3.1
mysql-test/r/func_concat.result:
Updated test results
sql/item_cmpfunc.cc:
Fixed bug in new code for regexp LIKE NULL
Diffstat (limited to 'mysql-test/r/func_concat.result')
| -rw-r--r-- | mysql-test/r/func_concat.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/func_concat.result b/mysql-test/r/func_concat.result index 75ee8f2bf79..17afd49b54c 100644 --- a/mysql-test/r/func_concat.result +++ b/mysql-test/r/func_concat.result @@ -1,13 +1,28 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 ( number INT NOT NULL, alpha CHAR(6) NOT NULL ); +INSERT INTO t1 VALUES (1413006,'idlfmv'), +(1413065,'smpsfz'),(1413127,'sljrhx'),(1413304,'qerfnd'); +SELECT number, alpha, CONCAT_WS('<---->',number,alpha) AS new +FROM t1 GROUP BY number; number alpha new 1413006 idlfmv 1413006<---->idlfmv 1413065 smpsfz 1413065<---->smpsfz 1413127 sljrhx 1413127<---->sljrhx 1413304 qerfnd 1413304<---->qerfnd +SELECT CONCAT_WS('<---->',number,alpha) AS new +FROM t1 GROUP BY new LIMIT 1; new 1413006<---->idlfmv +SELECT number, alpha, CONCAT_WS('<->',number,alpha) AS new +FROM t1 GROUP BY new LIMIT 1; number alpha new 1413006 idlfmv 1413006<->idlfmv +SELECT number, alpha, CONCAT_WS('-',number,alpha,alpha,alpha,alpha,alpha,alpha,alpha) AS new +FROM t1 GROUP BY new LIMIT 1; number alpha new 1413006 idlfmv 1413006-idlfmv-idlfmv-idlfmv-idlfmv-idlfmv-idlfmv-idlfmv +SELECT number, alpha, CONCAT_WS('<------------------>',number,alpha) AS new +FROM t1 GROUP BY new LIMIT 1; number alpha new 1413006 idlfmv 1413006<------------------>idlfmv +drop table t1; |