View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001730 | Database Comparer | General | public | 2022-01-05 18:36 | 2022-01-05 18:36 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | 8.0.0.2400 | ||||
| Target Version | 8.0.0.2400 | ||||
| Summary | 0001730: DB Comparer 8.0 fails when parsing the Firebird 3.0 script. | ||||
| Description | The problem is reproduced in both the VCL and standalone versions. See the attached log, SQL script, and screenshot. | ||||
| Tags | No tags attached. | ||||
|
|
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... 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; |
| 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 |
