Hassan Shaikh <[EMAIL PROTECTED]> wrote: > > 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 >
What version of MySQL do you use? If you use version < 4.1 , you should put in the my.cnf [mysqld] ansi ... or [musqld] sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY transaction-isolation=SERIALIZABLE .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
