2556862 - Table Function in SQL editor fails with ' invalid number: [6930] attribute value not a number'

• When you execute a a table function, which uses a date variable whose value is initialized to NULL, from the SQL editor as follows:

--------------------------------------------------------------------

DO BEGIN
DECLARE AS_OF_DATE DATE = NULL;
SELECT *
FROM <table function  qualified name>;
END;

-----------------------------------------------------

• This gives an error as follows:

---------------------------------

Could not execute 'DO BEGIN DECLARE AS_OF_DATE DATE = NULL= ...' in 6.157 seconds .
SAP DBTech JDBC: [339]: invalid number: "SAPSUPPORT"."DO": line 7 col 1 (at pos 233), line 2 col 9 (at pos 18), line 3 col 9 (at pos 68), line 5 col 9 (at pos 174): [339] (range 3) invalid number exception: invalid number: search table error: <table function>: line 39................................... line 31 col 5 (at pos 1718): [339] (range 3) invalid number exception: invalid number: [6930] attribute value is not a number (please check lines: 31, 52, 72, 91, 114) (please check lines: 39, 78, 124, 141, 147, 153, 168, 298)
Could not execute 'SELECT * FROM ...'

---------------------------------------------

SAP HANA PLATFORM 1.0

NULL date value, empty date , KBA , HAN-DB-SCR , SAP HANA SQL Script , Problem