View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001177 | Database Workbench v5 | Firebird Module | public | 2015-02-25 11:59 | 2018-02-15 14:50 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | duplicate | ||
| Product Version | 5.0.10 | ||||
| Summary | 0001177: Error on prepare: 'TPlanParser.ParsePlanJoin: Unrecognized text: "("' | ||||
| Description | The below SQL gives the above error if preparing in a newly opened SQL window. | ||||
| Steps To Reproduce | with tmp1(Martijn) as (select (select 'Martijn' from rdb$database) from rdb$database), tmp2(Tonies) as (select 'Tonies' from rdb$database), tmp3 as (select tmp1.Martijn, tmp2.Tonies from tmp1 join tmp2 on tmp1.Martijn = tmp2.Tonies) select * from tmp3 | ||||
| Additional Information | If first preparing without the innermost subselect, then it will work after putting the subselect back in. This query works in 4.4.8, but not in 5.0.10 I almost sent you a 183 line SQL (+ DDL) since my first attempt to simplify my problem resulted in error 0001168, which I failed to notice was fixed in 5.1.0 and not 5.0.10. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-02-25 11:59 | Svein Erling Tysvær | New Issue | |
| 2015-02-26 11:43 | Martijn Tonies | Note Added: 0000363 | |
| 2015-02-26 11:43 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-02-26 11:43 | Martijn Tonies | Status | new => acknowledged |
| 2018-02-15 14:50 | Martijn Tonies | Note Added: 0000456 | |
| 2018-02-15 14:50 | Martijn Tonies | Status | acknowledged => closed |
| 2018-02-15 14:50 | Martijn Tonies | Resolution | open => duplicate |
