|
Replies:
0
-
Pages:
1
|
|
|
Posts:
20
Registered:
2/16/10
|
|
|
|
Latest Toad5 beta still generating error with user variables
Posted:
May 31, 2010 5:46 PM
|
|
|
Back on 9 March I reported that the Toad 5 beta throws a "Fatal error encountered during command execution" when I have MySQL user variables included in the code. Unfortunately the error is still present in the latest beta. Sample code (same as before) below.
Thanks,
Linda
THIS ONE WORKS
select distinct *
from information_schema.CHARACTER_SETS as cs
where cs.character_set_name = 'latin1'
;
THIS ONE DOESN'T WORK
set @vVar := 'latin1';
select distinct *
from information_schema.CHARACTER_SETS as cs
where cs.character_set_name = @vVar
;
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
