mySQL5 incompatible
Posted: 29.05.2006, 07:35
I use mySQL 5.0.20a Debian. The problem is the new
syntax of "JOIN" in mySQL 5. I have to put in round
backets the "FROM" elements, when I use "JOIN" in SQL
sentence.
Expl: select * from (a,b)
left join c on (a.id = c.id).
All the tables's id field
type is integer auto_incerement, except for table "a".
'cause table "a" id field is varchar(15). The bug is in
ZGenericSqlAnalyser.pas, at line around 662, in the
FillTableRefs procedure. When it makes the FROM token,
it skips "(...)". Therefore, in my example sentence, in
the field list, the first column type won't be
varchar(15) but integer.
Is it a real bug, or I messed up something?
When I use BDE's TQuery, instead of Zeos's TzQuery it works.)
syntax of "JOIN" in mySQL 5. I have to put in round
backets the "FROM" elements, when I use "JOIN" in SQL
sentence.
Expl: select * from (a,b)
left join c on (a.id = c.id).
All the tables's id field
type is integer auto_incerement, except for table "a".
'cause table "a" id field is varchar(15). The bug is in
ZGenericSqlAnalyser.pas, at line around 662, in the
FillTableRefs procedure. When it makes the FROM token,
it skips "(...)". Therefore, in my example sentence, in
the field list, the first column type won't be
varchar(15) but integer.
Is it a real bug, or I messed up something?
When I use BDE's TQuery, instead of Zeos's TzQuery it works.)