Functions DATEDIFF, ABS(integer const) does not work in dialect 1 [CORE1528]

[firebird-automations]

Submitted by: Piminov Roman (ramzes)

Is related to QA195
Is duplicated by CORE1532

SELECT DATEDIFF(DAY, CAST('18.10.2007' AS DATE), CAST('23.10.2007' AS DATE)) FROM RDB$DATABASE
SELECT ABS(5) FROM RDB$DATABASE

Data type unknown
Client SQL dialect 1 does not support reference to BIGINT datatype

Commits: c744055

[firebird-automations]

Modified by: Piminov Roman (ramzes)

Component: Engine [ 10000 ]

[firebird-automations]

Modified by: Piminov Roman (ramzes)

description: Data type unknown
Client SQL dialect 1 does not support reference to BIGINT datatype

=>

Data type unknown
Client SQL dialect 1 does not support reference to BIGINT datatype

summary: Function DATEDIFF does not work in dialect 1 => Function DATEDIFF, ABS(5) does not work in dialect 1

[firebird-automations]

Modified by: Piminov Roman (ramzes)

summary: Function DATEDIFF, ABS(5) does not work in dialect 1 => Functions DATEDIFF, ABS(5) does not work in dialect 1

[firebird-automations]

Modified by: Piminov Roman (ramzes)

description: Data type unknown
Client SQL dialect 1 does not support reference to BIGINT datatype

=>

SELECT DATEDIFF(DAY, CAST('18.10.2007' AS DATE), CAST('23.10.2007' AS DATE)) FROM RDB$DATABASE
SELECT ABS(5) FROM RDB$DATABASE

Data type unknown
Client SQL dialect 1 does not support reference to BIGINT datatype

summary: Functions DATEDIFF, ABS(5) does not work in dialect 1 => Functions DATEDIFF, ABS(integer const) does not work in dialect 1

[firebird-automations]

Modified by: @asfernandes

Link: This issue is duplicated by CORE1532 [ CORE1532 ]

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

Version: 2.1 RC1 [ 10201 ] =>

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC1 [ 10201 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA195 [ QA195 ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 13331 ] => Firebird [ 13941 ]

[firebird-automations]

Commented by: @pmakowski

Adriano, can you explain me what was solved here ?
if I run under dialect 1 :
SELECT ABS(5) FROM RDB$DATABASE ;
I get :
Statement failed, SQLCODE = -804
Dynamic SQL Error
-SQL error code = -804
-Data type unknown
-Client SQL dialect 1 does not support reference to BIGINT datatype
Is that what it is expected ?

[firebird-automations]

Commented by: @asfernandes

Philippe, yes ABS was still broken in this fix, sorry. This one fixed many sysfunctions, including DATEDIFF.

But later, bug of ABS was registered again (CORE1828) and fixed in 2.5 alpha1.

[firebird-automations]

Commented by: @asfernandes

Note: "many sysfunctions, including DATEDIFF" == "HASH and DATEDIFF". :-)

[firebird-automations]

Commented by: @pmakowski

Q/A ok

[firebird-automations]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully