View Issue Details

IDProjectCategoryView StatusLast Update
0001648Database Comparer utilityGeneralpublic2021-04-13 15:21
Reporterhubeny Assigned Tobarry  
PrioritynormalSeverityblockReproducibilityalways
Status resolvedResolutionfixed 
PlatformFirebirdOSWindows 7 
Fixed in Version8.0.0.2400 
Summary0001648: Database Comparer Utility fail on syntax analysis of CTE in firebird namely CTE where "WITH recursive" is USED
DescriptionTHe database comparer fail to compare stored procedures of our database on firebird version 2.5.9. The comparer fails when trying to syntactycally analayze stored procedure which uses select with CTE defined by "WITH recursive". A screenshot is added.
TagsNo tags attached.

Relationships

related to 0001662 resolvedbarry DBComparer fails on parsing "with recursive", "merge into query", and "extract (week from...)" 

Activities

hubeny

2020-08-25 17:08

reporter  

screenshot.png (192,088 bytes)   
screenshot.png (192,088 bytes)   

barry

2020-11-10 08:52

administrator   ~0004426

Can You send full text of problematic procedure?

barry

2020-11-10 09:48

administrator   ~0004427

(WITH [RECURSIVE] ...) in expression fixed.

shirokov

2020-12-04 17:17

administrator   ~0004441

Still doesn't work. See the bugreport no 1662

barry

2021-04-13 15:07

administrator   ~0004494

(+) WITH ... SELECT for MERGE statement (1662).

barry

2021-04-13 15:19

administrator   ~0004498

Fixed on Build 2400 (cleverCOmponentsExport.sql).

Issue History

Date Modified Username Field Change
2020-08-25 17:08 hubeny New Issue
2020-08-25 17:08 hubeny File Added: screenshot.png
2020-09-15 23:22 shirokov Assigned To => barry
2020-09-15 23:22 shirokov Status new => assigned
2020-11-10 08:40 barry Status assigned => acknowledged
2020-11-10 08:52 barry Note Added: 0004426
2020-11-10 09:41 barry Status acknowledged => confirmed
2020-11-10 09:48 barry Status confirmed => resolved
2020-11-10 09:48 barry Resolution open => fixed
2020-11-10 09:48 barry Fixed in Version => 8.0.0.2359
2020-11-10 09:48 barry Note Added: 0004427
2020-12-04 17:17 shirokov Status resolved => assigned
2020-12-04 17:17 shirokov Note Added: 0004441
2021-04-13 14:48 barry Relationship added related to 0001662
2021-04-13 15:07 barry Note Added: 0004494
2021-04-13 15:07 barry Status assigned => confirmed
2021-04-13 15:19 barry Note Added: 0004498
2021-04-13 15:21 barry Status confirmed => resolved
2021-04-13 15:21 barry Fixed in Version 8.0.0.2359 => 8.0.0.2400