View Issue Details

IDProjectCategoryView StatusLast Update
0001730Database ComparerGeneralpublic2022-01-05 18:36
Reportershirokov Assigned Tobarry  
PrioritynormalSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Product Version8.0.0.2400 
Target Version8.0.0.2400 
Summary0001730: DB Comparer 8.0 fails when parsing the Firebird 3.0 script.
DescriptionThe problem is reproduced in both the VCL and standalone versions.
See the attached log, SQL script, and screenshot.
TagsNo tags attached.

Activities

shirokov

2022-01-05 18:36

administrator  

dbcCompare.Log (1,906 bytes)   
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Connect to: '127.0.0.1/3050:C:\Program Files (x86)\Heitz System\Data\2003.V12_MASTER.HTZ'...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Charset: ISO8859_1
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Server version: WI-V6.3.7.33374 Firebird 3.0 (Firebird/Windows/Intel/i386)
Client library: C:\Program Files (x86)\Heitz System\Program\fbclient.dll
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Server Version (user defined): FireBird 3.0
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting collations...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting functions...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting domains...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting tables...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting views...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting generators...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting procedures...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 ---TEST
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting triggers...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting indices...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting exceptions...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting unique constraints...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting primary keys...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting foreign keys...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting check constraints...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting roles...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Extracting grants...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Parsing bodies...
09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Error: Procedure TEST: Missing: <)> (<Ident>: WEEK)
Script:  Line:14 Pos:63

09.12.2021 17:20:32(I)  09/12/2021 17:20:32 Linking dependencies...
dbcCompare.Log (1,906 bytes)   
dbc-firebird30-parse-error.jpg (260,640 bytes)   
dbc-firebird30-parse-error.jpg (260,640 bytes)   
TEST.sql (783 bytes)   
SET TERM ^ ;

CREATE OR ALTER PROCEDURE TEST (
    UNIT INTEGER)
RETURNS (
    RESULT DATE)
AS
DECLARE VARIABLE START_DATE DATE;
DECLARE VARIABLE START_VALIDITY INTEGER;
DECLARE VARIABLE END_VALIDITY INTEGER;
BEGIN
  START_DATE = '01/01/2021';
  START_VALIDITY = 5;
  END_VALIDITY = 10;

  RESULT =
    CASE
      WHEN UNIT = 4 -- Day
        THEN DATEADD((END_VALIDITY - START_VALIDITY + 1) DAY TO START_DATE)
      WHEN UNIT = 5 -- Week
        THEN DATEADD((END_VALIDITY - START_VALIDITY + 1) WEEK TO START_DATE)
      WHEN UNIT = 7 -- Month
        THEN DATEADD((END_VALIDITY - START_VALIDITY + 1) MONTH TO START_DATE)
    END;

  SUSPEND;
END^

SET TERM ; ^

/* Existing privileges on this procedure */

GRANT EXECUTE ON PROCEDURE TEST TO SYSDBA;
TEST.sql (783 bytes)   

Issue History

Date Modified Username Field Change
2022-01-05 18:36 shirokov New Issue
2022-01-05 18:36 shirokov Status new => assigned
2022-01-05 18:36 shirokov Assigned To => barry
2022-01-05 18:36 shirokov File Added: dbcCompare.Log
2022-01-05 18:36 shirokov File Added: dbc-firebird30-parse-error.jpg
2022-01-05 18:36 shirokov File Added: TEST.sql