Address LP 1404951 - seabase/TEST010 failing This commit changes the default value for COMP_BOOL_184 to 'ON'. The effect of this is that MDAM probes will now fetch only one row of data rather than the previous default of 100 rows.
NOTE: Because the original problem reported in LP 1404951 does not seem to be reproducible any more, this check-in is being made to improve the performance of MDAM problems.
HOWEVER, it is possible that this change will cause the original problem to occur again. Namely that an incorrect number of rows could be returned for certain SQL queries (as originally reported in LP 1404951.) If anyone does run into this problem again, the default value for COMP_BOOL_184 will need to be changed back to 'OFF' until the root cause for the incorrect number of rows issue can be determined.
repository upgrade and explain enhancements. Details below. -- repository upgrade infrastructure integrated with 'initialize trafodion, upgrade' -- fields have been added/removed/modified in repos tables -- new repos table has been added
-- upgrade enhanced to only upgrade subset of components that need to be upgraded. One or more of metadata, repos, views, priv.
-- metadata version now tracks release version and indicates the traf release where upgrade was needed. Current metadata version will be 1.1.0.
-- packed explain data is now returned to caller so it could be stored in repository -- explain info from repository for a query id could be retrieved and displayed explain qid <query-id>; explain options 'f' qid <query-id> select * from table(explain(null, 'EXPLAIN_QID=<query-id>'));
-- a sql query could be explained and returned in relational format. select * from table(explain(null, 'EXPLAIN_STMT=<query-str>)); Users only need to have select permission on tables referenced in query-str.
-- explain and statistics tables could be invoked invoke table(explain(null, null)); invoke table(statistics(null, null));