View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000433 | Database Workbench v6 | SQL & Parameter Insight | public | 2012-08-21 13:23 | 2024-06-27 14:43 |
| Reporter | Doychin Bondzhev | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | no change required | ||
| Summary | 0000433: MySQL does not support this syntax join (subquery) as sq(f1, f2...) on sq.f1 = some_filed | ||||
| Description | This 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. | ||||
| Tags | No tags attached. | ||||
| 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 |
| 2024-06-27 14:43 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2024-06-27 14:43 | Martijn Tonies | Status | acknowledged => closed |
| 2024-06-27 14:43 | Martijn Tonies | Resolution | open => no change required |
| 2024-06-27 14:43 | Martijn Tonies | Note Added: 0000615 |
