Issue Details (XML | Word | Printable)

Key: CORE-1528
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Piminov Roman
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

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

Created: 18/Oct/07 11:26 AM   Updated: 08/Oct/08 12:34 PM
Component/s: Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1, 2.1 Beta 2
Fix Version/s: 2.1 RC1

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate
 


 Description  « Hide
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

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 07/Oct/08 09:19 AM
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 ?

Adriano dos Santos Fernandes added a comment - 08/Oct/08 12:15 PM
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 (CORE-1828) and fixed in 2.5 alpha1.

Adriano dos Santos Fernandes added a comment - 08/Oct/08 12:22 PM
Note: "many sysfunctions, including DATEDIFF" == "HASH and DATEDIFF". :-)

Philippe Makowski added a comment - 08/Oct/08 12:34 PM
Q/A ok