Bug #3836 | concat() does not concatenate | ||
---|---|---|---|
Submitted: | 20 May 2004 11:01 | Modified: | 20 May 2004 15:51 |
Reporter: | Vilius :) | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 4.0.18-8 | OS: | Linux (Debian GNU/Linux 2.6.6) |
Assigned to: | CPU Architecture: | Any |
[20 May 2004 11:01]
Vilius :)
[20 May 2004 15:51]
MySQL Verification Team
I tested this with 4.0.18 on Windows and with 4.0.20 on Suse 9.0 without to repeat the behavior reported: miguel@hegel:~> /usr/local/mysql/bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.20-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. <cut> mysql> select dir, fn, -> concat(dir,fn) from ata_h\G *************************** 1. row *************************** dir: /a/Alytaus_RAAAD_Alytaus_m_raj fn: 10224-143953.dal concat(dir,fn): /a/Alytaus_RAAAD_Alytaus_m_raj10224-143953.dal 1 row in set (0.01 sec) mysql> select concat("a","b"); +-----------------+ | concat("a","b") | +-----------------+ | ab | +-----------------+ 1 row in set (0.00 sec) mysql>