|
Replies:
1
-
Pages:
1
-
Last Post:
Mar 9, 2010 12:25 PM
by: Dwight
|
|
|
Posts:
20
Registered:
2/16/10
|
|
|
|
User variables crash Toad 5 beta
Posted:
Mar 3, 2010 6:03 PM
|
|
|
|
|
In the new Toad 5 beta I can't use MySQL user variables without Toad throwing an error (see the attached image). I have included 2 simple scripts below - the first runs fine but the second generates the error. I am currently running MySQL 5.1.36-community with a localhost connection. Obviously this is working fine in the latest v4.6 GA release.
-----------------------------------
select distinct *
from information_schema.CHARACTER_SETS as cs
where cs.character_set_name = 'latin1'
;
-----------------------------------
set @vVar := 'latin1';
select distinct *
from information_schema.CHARACTER_SETS as cs
where cs.character_set_name = @vVar
;
-----------------------------------
Any hints or tips gratefully received,
Linda
|
|
|
Posts:
68
Registered:
8/22/07
|
|
|
|
Re: User variables crash Toad 5 beta
Posted:
Mar 9, 2010 12:25 PM
in response to: Linda
|
|
|
Opened CR 72,004 for this one.
Hey, you already posted this on the forum. Sorry for th confusion.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
