mysql parsing
已回答
COALESCE(c.address, "") AS "address"
parser says `unable to resolve column ""` although this is a valid construct
CONCAT(p.caption, ", ", k.caption) AS "fullcaption"
parser says `unable to resolve column ", "` although this is a valid construct
请先登录再写评论。
Hi there,
Please try single quotes instead of double (in places where it complains) -- any better?
Good suggestion, works fine. Unfortunately, for me, it would entail rewriting a large number of tried and tested sql strings written as 'select .... concat(..,"")...' so I'll just have to ignore the warnings.
Thanks, Bill
Sure.
In case if you are interested: https://youtrack.jetbrains.com/issue/DBE-3683 -- watch this ticket (star/vote/comment) to get notified on any progress.
Link much appreciated, many thanks, Bill