May be a mySQL Bug....?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
Todd_Z
Forum Regular
Posts: 708
Joined: Thu Nov 25, 2004 9:53 pm
Location: U Michigan

May be a mySQL Bug....?

Post 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?
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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)
User avatar
Todd_Z
Forum Regular
Posts: 708
Joined: Thu Nov 25, 2004 9:53 pm
Location: U Michigan

Post by Todd_Z »

Maybe its cuz im using 5.0.20a?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post 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)
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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 ;)
User avatar
Todd_Z
Forum Regular
Posts: 708
Joined: Thu Nov 25, 2004 9:53 pm
Location: U Michigan

Post by Todd_Z »

I just install the latest on my dev server [ my laptop ] - production is deffinitely only stable versions.
Post Reply