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
Security changes to support authorization Added support for authorization commands:
- initialize authorization [, drop] - create/drop roles - register/unregister components - create/drop component operations - grant/revoke object privileges - grant/revoke role privileges - grant/revoke component privileges - updates to GET and SHOWDDL statements - checking of privileges for DML requests - checking of privileges for DDL requests - regression tests added to catman1 library
Fixed a testware problem in catman1 TEST135 and TEST139 Fixed a parser problem introduced by compGeneral/TESTTOK2 which was recently introduced.
This delivery was part of code worked on by many people for several months on a remote branch. This team held bi-weekly meetings for several months to design and implement these features. These meetings also included extensive code reviews.
The security features which include authentication (which was delivered in June) and authorization is turned off by default. The traf_authentication_setup script located in $MY_SQROOT/sql/scripts needs to be run to enable both authentication and authorization. This procedure is described on the Trafodion Twiki page and will be updated once this delivery completed to include authorzation.
Updated traf_authentication_setup to return consistent error messages and added a comment to ComSmallDefs.h to address a buf size issue for metadata tables.