v7 bug: query builder - corelated sub-query

[gad]

Hello,
when trying to edit a query like:
select
t1.f1, t1.f2,
(select sum(t2.f3) from t2 where t2.key=t1.key)
from t1
where t1.x=y ....

with the new QueryBuilder plugin, the plugin gives access violation and when closed, I get plsql dev message box saying the plugin faild, then PLSD dies with access violation (not alwayes immediatley but eventually).

It would also be nice to have some documentation of the plugin.

TIA

 

[ScottMattes]

I wonder if the problem is in the part of the query represented by the .....

I copied the part that was given and PLSD and Query Builder worked just fine..

 

[gad]

Oh I see now,
If I only added one more dot.....
Well it probably worked for you just as written because you have a schema full of t1, t2 and so forth.
For me it does not work but then again I have peskier schema.
This was tried with the new ActiveQueryBuilder plugin. Not working properly!

 

[ScottMattes]

Acutally, I don't have a t anything, I just copied the SQL you left, minus the ...., and invoked the builder.

I'm glad the extra dot helped!