View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001168 | Database Workbench v5 | Firebird Module | public | 2015-02-03 15:28 | 2015-05-11 12:25 |
| Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.0.8 | ||||
| Fixed in Version | 5.1.0 | ||||
| Summary | 0001168: Too much recursion in PLAN parser. | ||||
| Description | When trying to prepare a statement that works flawlessly in DBW4, I get the error message "Too much recursion in PLAN parser. This is most likely caused by a bug in the parser, but it could conceivably be the result of a really complex PLAN. Try increasing the "Maximum parser recursion depth" setting on the "Advanced" tab of the Options dialog. If that does not fix the problem, it's probably a bug. In case, please file a bug report." I've looked throughout DBW and searched the internet, but cannot find any Options dialog. | ||||
| Steps To Reproduce | Try preparing the statement below in a newly created SQL Editor (naturally, my real statement is rather different). If you use 38 and not 39 tuples things work. select 1 from rdb$database r1 join rdb$database r2 on r1.rdb$relation_id = r2.rdb$relation_id join rdb$database r3 on r1.rdb$relation_id = r3.rdb$relation_id join rdb$database r4 on r1.rdb$relation_id = r4.rdb$relation_id join rdb$database r5 on r1.rdb$relation_id = r5.rdb$relation_id join rdb$database r6 on r1.rdb$relation_id = r6.rdb$relation_id join rdb$database r7 on r1.rdb$relation_id = r7.rdb$relation_id join rdb$database r8 on r1.rdb$relation_id = r8.rdb$relation_id join rdb$database r9 on r1.rdb$relation_id = r9.rdb$relation_id join rdb$database r10 on r1.rdb$relation_id = r10.rdb$relation_id join rdb$database r11 on r1.rdb$relation_id = r11.rdb$relation_id join rdb$database r12 on r1.rdb$relation_id = r12.rdb$relation_id join rdb$database r13 on r1.rdb$relation_id = r13.rdb$relation_id join rdb$database r14 on r1.rdb$relation_id = r14.rdb$relation_id join rdb$database r15 on r1.rdb$relation_id = r15.rdb$relation_id join rdb$database r16 on r1.rdb$relation_id = r16.rdb$relation_id join rdb$database r17 on r1.rdb$relation_id = r17.rdb$relation_id join rdb$database r18 on r1.rdb$relation_id = r18.rdb$relation_id join rdb$database r19 on r1.rdb$relation_id = r19.rdb$relation_id join rdb$database r20 on r1.rdb$relation_id = r20.rdb$relation_id join rdb$database r21 on r1.rdb$relation_id = r21.rdb$relation_id join rdb$database r22 on r1.rdb$relation_id = r22.rdb$relation_id join rdb$database r23 on r1.rdb$relation_id = r23.rdb$relation_id join rdb$database r24 on r1.rdb$relation_id = r24.rdb$relation_id join rdb$database r25 on r1.rdb$relation_id = r25.rdb$relation_id join rdb$database r26 on r1.rdb$relation_id = r26.rdb$relation_id join rdb$database r27 on r1.rdb$relation_id = r27.rdb$relation_id join rdb$database r28 on r1.rdb$relation_id = r28.rdb$relation_id join rdb$database r29 on r1.rdb$relation_id = r29.rdb$relation_id join rdb$database r30 on r1.rdb$relation_id = r30.rdb$relation_id join rdb$database r31 on r1.rdb$relation_id = r31.rdb$relation_id join rdb$database r32 on r1.rdb$relation_id = r32.rdb$relation_id join rdb$database r33 on r1.rdb$relation_id = r33.rdb$relation_id join rdb$database r34 on r1.rdb$relation_id = r34.rdb$relation_id join rdb$database r35 on r1.rdb$relation_id = r35.rdb$relation_id join rdb$database r36 on r1.rdb$relation_id = r36.rdb$relation_id join rdb$database r37 on r1.rdb$relation_id = r37.rdb$relation_id join rdb$database r38 on r1.rdb$relation_id = r38.rdb$relation_id join rdb$database r39 on r1.rdb$relation_id = r39.rdb$relation_id | ||||
| Additional Information | I found that if I comment out tuple 39, it does prepare and if I then "uncomment" again, prepare succeeds. Hence, this is only a minor niggle for me currently. However, doing this gives an access violation at rtl120 if I then try to resize the window showing the plan. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-02-03 15:28 | Svein Erling Tysvær | New Issue | |
| 2015-02-04 09:34 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2015-02-04 09:34 | Martijn Tonies | Status | new => acknowledged |
| 2015-02-10 13:57 | Martijn Tonies | Status | acknowledged => assigned |
| 2015-02-10 14:04 | Martijn Tonies | Status | assigned => resolved |
| 2015-02-10 14:04 | Martijn Tonies | Fixed in Version | => 5.0.10 |
| 2015-02-10 14:04 | Martijn Tonies | Resolution | open => fixed |
| 2015-02-10 14:11 | Martijn Tonies | Fixed in Version | 5.0.10 => 5.1.0 |
| 2015-05-11 12:25 | Martijn Tonies | Status | resolved => closed |
