[#CORE-1875] Error on script with current_date - Firebird RDBMS Issue Tracker

Firebird Core

Error on script with current_date

Created: 30/Apr/08 10:45 AM Updated: 18/Nov/08 12:48 PM

Return to search

Issue 7 of 8 issue(s)

<< Previous | CORE-1875 | Next >>

Component/s:

Scripts

Affects Version/s:

2.1.0

Fix Version/s:

2.5 Alpha 1, 2.1.1

Time Tracking:

Not Specified

Environment:

Windows Server 2003, Server Version: WI-V2.1.0.17798 Firebird 2.1 Classic

Planning Status:

Unspecified

Description

« Hide

DDL:

SET SQL DIALECT 3;

SET NAMES WIN1251;

CREATE TABLE NEW_TABLE (
    F1 VARCHAR(30),
    F2 VARCHAR(30),
    F3 VARCHAR(30),
    DATA_REG DATE
);

Error on script:

EXECUTE BLOCK(
IN_F1 VARCHAR(30) = :IN_F1,
IN_F2 VARCHAR(30) = :IN_F2,
IN_F3 VARCHAR(30) = :IN_F3)
AS
BEGIN
    IF (NOT(EXISTS(SELECT * FROM NEW_TABLE NT WHERE NT.F1=:IN_F1 AND NT.F2=:IN_F2 AND NT.DATA_REG=CURRENT_DATE))) THEN
        BEGIN
        END ELSE
        BEGIN
        END
END

Server closes connection on script:

EXECUTE BLOCK(
IN_F1 VARCHAR(30) = :IN_F1,
IN_F2 VARCHAR(30) = :IN_F2,
IN_F3 VARCHAR(30) = :IN_F3)
AS
BEGIN
    IF (NOT(EXISTS(SELECT * FROM NEW_TABLE NT WHERE NT.F1=:IN_F1 AND NT.F2=:IN_F2 AND NT.DATA_REG=CAST(CURRENT_DATE AS DATE) ))) THEN
        BEGIN
        END ELSE
        BEGIN
        END
END

No problem on script, eg:

EXECUTE BLOCK(
IN_F1 VARCHAR(30) = :IN_F1,
IN_F2 VARCHAR(30) = :IN_F2,
IN_F3 VARCHAR(30) = :IN_F3)
AS
BEGIN
    IF (NOT(EXISTS(SELECT * FROM NEW_TABLE NT WHERE NT.F1=:IN_F1 AND NT.F2=:IN_F2 AND NT.DATA_REG='dd.mm.yyyy'))) THEN
        BEGIN
        END ELSE
        BEGIN
        END
END

All

Comments

Work Log

Change History

Version Control

Sort Order:

The cvs commits can not be displayed for repository Firebird at the moment since the log has not yet been parsed. The log will be parsed the next time the VcsService runs. If you have administrators privileges you can hasten the next time the service will run in the service section of the Administration pages.