mysql (client) problem

Remo Tex <[email protected]> Fri, 18 Nov 2005 11:45:08 +0200
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
mysql client doesn't print field contents after first '\0' character
e.g.:
mysql> select 'A\0AAAAAA' as txt;
+----------+
| txt      |
+----------+
| A        |
+----------+
1 row in set (0.00 sec)

but
/bin/bash would print 'A\0A' as AA

or let's check another way:
mysql> create table test (txt char(8));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test values ('AAAAAAAA'), ('A\0AAAAAA');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from test;
+----------+
| txt      |
+----------+
| AAAAAAAA |
| A        |
+----------+
2 rows in set (0.00 sec)

mysql> status
--------------
mysql  Ver 12.22 Distrib 4.0.26, for pc-linux-gnu (i686)
...
Server version:         4.0.26-standard-log
Protocol version:       10
Connection:             Localhost via UNIX socket

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]