diff options
| author | unknown <monty@tik.mysql.fi> | 2001-03-23 20:38:42 +0200 |
|---|---|---|
| committer | unknown <monty@tik.mysql.fi> | 2001-03-23 20:38:42 +0200 |
| commit | fd433598fefd92904ff65843bd1ff3070604b857 (patch) | |
| tree | 9691c3978bd401c61959324ed6f6d3ac30a7840d /mysql-test/r/func_str.result | |
| parent | b4098ead8324790a52a70b4b35a3e83bc4c7ed54 (diff) | |
| download | mariadb-git-fd433598fefd92904ff65843bd1ff3070604b857.tar.gz | |
Test case for bug when updating on key
Fixed bug in CONCAT_WS()
Print the default ISOLATION level.
Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT
Docs/manual.texi:
Changelog
mysql-test/r/func_str.result:
Added tests for CONCAT_WS()
mysql-test/r/update.result:
Test case for bug when updating on key
mysql-test/t/func_str.test:
Added tests for CONCAT_WS()
mysql-test/t/update.test:
Test case for bug when updating on key
sql/gen_lex_hash.cc:
Better hash values
sql/handler.cc:
Added missig NullS
sql/item_strfunc.cc:
Fixed bug in CONCAT_WS()
sql/mysql_priv.h:
Print the default ISOLATION level.
sql/mysqld.cc:
Print the default ISOLATION level.
sql/sql_insert.cc:
Remove unnecessary call to setup_tables()
sql/sql_parse.cc:
Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT
sql/sql_yacc.yy:
Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT
BitKeeper/etc/logging_ok:
Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index c1a0c288562..ec421e9f31b 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -34,6 +34,14 @@ concat(':',trim(LEADING '.*' FROM '.*my'),':',trim(TRAILING '.*' FROM 'sql.*.*') :my:sql: TRIM("foo" FROM "foo") TRIM("foo" FROM "foook") TRIM("foo" FROM "okfoo") ok ok +concat_ws(', ','monty','was here','again') +monty, was here, again +concat_ws(NULL,'a') concat_ws(',',NULL,'') +NULL +concat_ws(',','',NULL,'a') +a +CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"') +"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb";"cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc";"dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd" insert('txs',2,1,'hi') insert('is ',4,0,'a') insert('txxxxt',2,4,'es') this is a test replace('aaaa','a','b') replace('aaaa','aa','b') replace('aaaa','a','bb') replace('aaaa','','b') replace('bbbb','a','c') @@ -96,3 +104,9 @@ domain hello.de domain test.de +CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified,bugstatus,submitter), '"') +"Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4" +CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugstatus,submitter), '"') +"Link";"1";"1";"1";"0";"4" +CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modified,bugstatus,submitter) +Link";"1";"1";"1";"aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa";"2001-02-28 08:40:16";"20010228084016";"0";"4 |