LEAD() and LAG() do not allow to specify 3rd argument ("DEFAULT" value when pointer is out of scope) of INT128 datatype. ------------------------------------------------------------------------------------------------------------------------
Key: CORE-6357 URL: http://tracker.firebirdsql.org/browse/CORE-6357 Project: Firebird Core Issue Type: Bug Reporter: Pavel Zotov recreate table test1 (a smallint); recreate table test2 (a bigint); recreate table test3 (a int128); recreate table test4 (a decfloat); insert into test1 values (1); insert into test1 values (2); insert into test2 select * from test1; insert into test3 select * from test1; insert into test4 select * from test1; set list on; set sqlda_display on; select a, lead(a, 1, 32767)over(order by a) lead_for_smallint from test1; select a, lag(a, 1, -32768)over(order by a) lag_for_smallint from test1; select a, lead(a, 1, 9223372036854775807)over(order by a) lead_for_bigint from test2; select a, lag(a, 1, -9223372036854775808)over(order by a) lag_for_bigint from test2; select a, lead(a, 1, 170141183460469231731687303715884105727)over(order by a) lead_for_int128 from test3; select a, lag(a, 1, -170141183460469231731687303715884105728)over(order by a) lag_for_int128 from test3; select a, lag(a, 1, -9.999999999999999999999999999999999e6144) over (order by a) lag_for_decfloat_1 from test4; select a, lag(a, 1, -1.0e-6143)over(order by a) lag_for_decfloat_2 from test4; select a, lag(a, 1, 1.0e-6143)over(order by a) lag_for_decfloat_3 from test4; select a, lag(a, 1, 9.999999999999999999999999999999999e6144)over(order by a) lag_for_decfloat_4 from test4; Result of LEAD() and LAG() for INT128 is: ===== Statement failed, SQLSTATE = 22000 Decimal float invalid operation. An indeterminant error occurred during an operation. ===== All other work OK. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel