Page 1 of 1

May be a mySQL Bug....?

Posted: Mon May 15, 2006 12:53 pm
by Todd_Z

Code: Select all

todd@ubuntu:~$ mysql --version
mysql  Ver 14.12 Distrib 5.0.20a, for pc-linux-gnu (i386) using readline 4.3
When I type

Code: Select all

SELECT 0xE;
the entire shell turns into:

Code: Select all

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 5.0.20a-Debian_1.dotdeb.1-log

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

mysql> select 0xE;
+-----+
| 0xE |
+-----+
|    ≠
+-----+
1 ⎼⎺┬ ␋┼ ⎽␊├ (0.00 ⎽␊␌)

└≤⎽─┌> ├␊⎽├
    -> ␤␊┌⎺?
    -> ;
ERROR 1064 (42000): Y⎺┤ ␤▒┴␊ ▒┼ ␊⎼⎼⎺⎼ ␋┼ ≤⎺┤⎼ SQL ⎽≤┼├▒│; ␌␤␊␌┐ ├␤␊ └▒┼┤▒┌ ├␤▒├ ␌⎺⎼⎼␊⎽⎻⎺┼␍⎽ ├⎺ ≤⎺┤⎼ M≤SQL ⎽␊⎼┴␊⎼ ┴␊⎼⎽␋⎺┼ °⎺⎼ ├␤␊ ⎼␋±␤├ ⎽≤┼├▒│ ├⎺ ┤⎽␊ ┼␊▒⎼ '├␊⎽├
␤␊┌⎺?' ▒├ ┌␋┼␊ 1
└≤⎽─┌> ⎽␊┌␊␌├ * °⎼⎺└ ⎻␊⎼⎽⎺┼;
+
Is this expected behavior?

Posted: Mon May 15, 2006 12:57 pm
by Chris Corbyn

Code: Select all

d11wtq root # mysql --version
mysql  Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i386) using readline 4.3

#snip

mysql> select 0xE;
+-----+
| 0xE |
+-----+
|    |
+-----+
1 row in set (0.00 sec)

Posted: Mon May 15, 2006 1:03 pm
by Todd_Z
Maybe its cuz im using 5.0.20a?

Posted: Mon May 15, 2006 1:06 pm
by timvw
I think it depends on your 'console' and installed charsets...


Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.20-nt

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

mysql> SELECT 0xE;
+-----+
| 0xE |
+-----+
| ♫ |
+-----+
1 row in set (0.08 sec)

Posted: Mon May 15, 2006 1:06 pm
by Chris Corbyn
Todd_Z wrote:Maybe its cuz im using 5.0.20a?
Yeah I wouldn't use anything but a final release in production - if you're using anything else you have to go on the assumption that there *will* be bugs with it. Find a stable final release ;)

Posted: Mon May 15, 2006 3:12 pm
by Todd_Z
I just install the latest on my dev server [ my laptop ] - production is deffinitely only stable versions.