LP 1444044, dup col definitions are not detected During a create table or create view, duplicate col names are not being detected and an error is not being returned. This results in an incorect table or view being created. An error may or may not be returned later depending on how that object is being used.
That has been fixed to detect dup cols and return an error message during create time.
Fixing it now so users dont create incorrect objects by mistake.
explain enhancements and fixes. -- support to return explain details from packed explain plan. select * from table(explain(null, 'EXPLAIN_PLAN=<packed-plan>')) This enables caller to retrieve the packed explain plan, ship it to another process and then format it there. DSM will be using this functionality. -- sqlci syntax added to test explain enhancement functionality: get qid for statement s; store explain for s in repository; set qid <qid> for s; -- new tests added to seabase/TEST011 -- some bug fixes to handle 4 byte lengths for explain plan greater than short max. -- changed err enums CLI_DESC_NOT_EXSISTS and CLI_STMT_NOT_EXSISTS to the right EXISTS spelling (this is just for you, Dave). -- added missing copyrights