Re: mysql (client) problem

Remo Tex wrote:
> 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
Same behavior with
C:\mysql-5.0.15-win32\bin

C:\mysql-5.0.15-win32\bin>mysql -u admin -p
Enter password: *******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.15-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select 'A\0A' as txt;
+-----+
| txt |
+-----+
| A   |
+-----+
1 row in set (0.03 sec)

mysql> EXIT;
Bye

but here shell=CMD.EXE prints out: space instead of '\0'
C:\mysql-5.0.15-win32\bin>type zz.txt
A A
C:\mysql-5.0.15-win32\bin>

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