Concat. operator ||

[Hassan Shaikh]

Hi All,

I am running MySQL in ANSI standard mode. However the following 
statement is giving unexpected result. Am I missing something?

   mysql> select 'This is a' || ' test string';
   +-------------------------------+
   | 'This is a' || ' test string' |
   +-------------------------------+
   |                             0 |
   +-------------------------------+
   1 row in set (0.00 sec)
Here's a part of my my.ini, indicating that I am in ANSI mode.

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable    = sql-mode=ansi
set-variable    = key_buffer=32M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=32
set-variable    = net_buffer_length=8K
set-variable    = sort_buffer=1M
set-variable    = record_buffer=512K
set-variable    = myisam_sort_buffer_size=4M
set-variable    = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable    = thread_concurrency=8
log-bin
server-id    = 1
Thanks.

Hassan

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]