dynamobi/dynamobi — Issue #622: [FRG-250] misleading error message for call to UDX with column list but mismatched parameter count
Author: dynamobi-build
Created: 2011-12-30 03:39:13+00:00
State: open
Labels: FRG, SQL Validator

[reporter="jvs", created="Sat, 20 Jan 2007 13:22:41 -0500 (GMT-05:00)"]
select schema_name, crc_value from table(

applib.generate_crc(

cursor(select * from sys_root.dba_schemas),

row(creator)

)

);

gives

Error: From line 4, column 14 to line 4, column 20: Unknown identifier 'CREATOR' (state=,code=0)

but with the correct three-arg invocation, it works:

select schema_name, crc_value from table(

applib.generate_crc(

cursor(select * from sys_root.dba_schemas),

row(creator),

true

)

);