Parameter in offset expression in LAG, LEAD, NTH_VALUE window functions requires explicit cast to BIGINT or INTEGER [CORE6421] #6659
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
|
Commented by: @pavel-zotov Server version: select rdb$relation_name, lag(rdb$relation_name, ?) over (order by rdb$relation_name) from rdb$relations; PLAN SORT (RDB$RELATIONS NATURAL) --############################################### select rdb$relation_name, lead(rdb$relation_name, ?) over (order by rdb$relation_name) from rdb$relations; --############################################### select rdb$relation_name, nth_value(rdb$relation_name, ?) over (order by rdb$relation_name) from rdb$relations; PLAN SORT (RDB$RELATIONS NATURAL) |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: See note 23/Oct/20 08:26 PM |
|
Commented by: @mrotteveel Should this be reopened if LEAD is still failing? |
|
Commented by: @asfernandes > Should this be reopened if LEAD is still failing? Fixed now. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: See note 23/Oct/20 08:26 PM => |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
firebird-automations
added
affect-version: 3.0.6
affect-version: 4.0 Beta 2
affect-version: 3.0.5
affect-version: 4.0 Beta 1
affect-version: 3.0.4
affect-version: 3.0.3
affect-version: 4.0 Alpha 1
affect-version: 3.0.2
affect-version: 3.0.1
affect-version: 3.0.0
fix-version: 4.0 RC 1
resolution: fixed
priority: major
component: engine
type: bug
qa: done successfully
labels
Submitted by: @mrotteveel
When using a parameter in LAG, LEAD or NTH_VALUE window functions, Firebird returns the error "Dynamic SQL Error; SQL error code = -804; Data type unknown [SQLState:HY004, ISC error code:335544573]"
For example:
select rdb$relation_name, lag(rdb$relation_name, ?) over (order by rdb$relation_name) from rdb$relations
The workaround is to add an explicit cast:
select rdb$relation_name, lag(rdb$relation_name, cast(? as bigint)) over (order by rdb$relation_name) from rdb$relations
The same applies to LEAD and NTH_VALUE.
Firebird should identify the parameter as BIGINT.
Commits: 7b0a29d e73973a
The text was updated successfully, but these errors were encountered: