View Issue Details

IDProjectCategoryView StatusLast Update
0000433Database Workbench v6SQL & Parameter Insightpublic2022-01-12 13:14
ReporterDoychin Bondzhev Assigned To 
Status acknowledgedResolutionopen 
Summary0000433: MySQL does not support this syntax join (subquery) as sq(f1, f2...) on sq.f1 = some_filed
DescriptionThis query works for mysql but does not allow sql insight to see fields from tt2:
select * from t1 join (select f1, f2 from t2) tt2 on t1.f1 = tt2.f2

Now this query works for sql insight but fails on mysql:
select * from t1 join (select f1, f2 from t2) tt2(f1, f2) on t1.f1 = tt2.f2

This format is supported from firebird so there are no problems with such queries.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-08-21 13:23 Doychin Bondzhev New Issue
2012-08-21 14:08 Martijn Tonies Status new => acknowledged
2014-09-08 16:36 Martijn Tonies Project Database Workbench v4 => Database Workbench v5
2022-01-12 13:14 Martijn Tonies Project Database Workbench v5 => Database Workbench v6