View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0000486 | Database Workbench v6 | SQL & Parameter Insight | public | 2012-11-06 11:25 | 2022-08-04 13:25 |
Reporter | Doychin Bondzhev | Assigned To | |||
Priority | normal | Severity | minor | Reproducibility | always |
Status | acknowledged | Resolution | open | ||
Summary | 0000486: SQL Insight does not recognize sub-selects as left operand in expressions | ||||
Description | I discovered one more problem with SQL insight last night it does not work for this case: select * from some_table where (select count(*) from other_table) <> 0 It fails to list table names in the sub-select. Also it does not work for expressions that will follow the sub-select but it works for expressions before that sub-select. | ||||
Steps To Reproduce | Open some database. In my case I use Firebird 2.1 Open Singl SQL Editor and write some select that will look like the one in the description Try to invoke SQL Insight in the sub-select. Also try to invoke it after the sub-select. It will fail both times. It will only work before that sub-select | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2012-11-06 11:25 | Doychin Bondzhev | New Issue | |
2012-11-08 09:31 | Martijn Tonies | Status | new => acknowledged |
2014-09-08 16:28 | Martijn Tonies | Project | Database Workbench v4 => Database Workbench v5 |
2022-01-12 13:14 | Martijn Tonies | Project | Database Workbench v5 => Database Workbench v6 |
2022-08-04 13:25 | Martijn Tonies | Category | General => SQL & Parameter Insight |