Fixes for a few scalar UDF bugs LP 1426605: change in NormRelExpr.cpp. When left linearizing a join backbone sufficients inputs were not being provided. The change ensures that inputs from the old tree and still marked as required inputs for a node in the new tree. LP 1420530: Error handling added to BiArith::bindNode. LP 1420938: Error handling to CREATE FUNCTION statement to flag more than 32 parameters. LP 1421438: showddl [function | procedure | table_mapping function] <name>; now works. If one of the optional tokens is not specified then we will look for a table called <name>.
Patch Set 1 Changes to address comments by Dave. One more fix in ExUdr.cpp. There is no LP for this bug. If a dll is missing at runtime or other LOAD errors during UDF fixup could lead to an assertion, since we try to place an error in UDF's up queue, before there are entries in the corresponding down queue. Fix is to remove this line and let existing error handling report this error. Thanks for your help Hans. Couple of items that I forgot to mention before 1) Changes in Analyzer.cpp related to printing predecessorJBBC are due to Hans. 2) Showddl code is mostly refactored from previous versions.
Specify compiler context when querying natable virtual table interface select * from table(natablecache('ALL','local')) ; select * from table(natablecacheentries('meta','local')) ; select * from table(naroutinecache('user','local')) ;
Following the querycache virtual table interface, now the natable and naroutine cache virtual table interfaces also support specifying the name of the context we want to query. The first parameter can be 'all' or name of context (e.g. 'meta', 'user', 'ustat'). The second parameter can be local or remote. Parameters are case insensitive. For remote compiler we only query the context pointed to by activeschemadb. The column num_entries has been added to natablecache virtual table. This change can be used to monitor memory growth in these caches.
Patch Set 2: Address issues found by Dave. Changes in 4 files sql/arkcmp/NATableSt.cpp sql/arkcmp/NATableSt.h sql/arkcmp/QueryCacheSt.cpp sql/optimizer/NARoutine.cpp
Changes cover A minor leak in in HQCIterator returning FALSE in NATable/RoutineCacheStats iterator getNext methods