[
https://issues.apache.org/jira/browse/TRAFODION-3216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16649574#comment-16649574
]
ASF GitHub Bot commented on TRAFODION-3216:
-------------------------------------------
Github user robertamarton commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1721#discussion_r225014889
--- Diff: core/sql/sqlcomp/CmpSeabaseDDLinitraf.cpp ---
@@ -692,7 +675,62 @@ short CmpSeabaseDDL::initTrafMD(CmpDDLwithStatusInfo
*dws)
} // switch
}
break;
+ case IT_CREATE_LIBRARIES:
+ {
+ switch (dws->subStep())
+ {
+ case 0:
+ {
+ setValuesInDWS(dws, IT_NO_CHANGE,
+ "Create Libraries Tables: Started", 1,
FALSE,
+ TRUE, FALSE, FALSE);
+
+ return 0;
+ }
+ break;
+
+ case 1:
+ {
+ ExeCliInterface cliInterface(STMTHEAP, 0, NULL,
+
CmpCommon::context()->sqlSession()->getParentQid());
+ if (createLibrariesObject(&cliInterface))
+ {
+ setValuesInDWS(dws, IT_STEP_FAILED,
+ "Create Libraries Tables: Failed", 0,
TRUE,
+ FALSE, TRUE, TRUE);
+ return 0;
+ }
+ // update SPJ info
+ // Note that this is not an existing jar file, the class
+ // loader will attempt to load the class from the
CLASSPATH if
+ // it can't find this jar
+ NAString installJar(getenv("TRAF_HOME"));
+ installJar +=
"/export/lib/trafodion-sql-currversion.jar";
+ const char* sysCat =
+
ActiveSchemaDB()->getDefaults().getValue(SEABASE_CATALOG);
+ if (updateSeabaseMDSPJ(&cliInterface, sysCat,
SEABASE_MD_SCHEMA,
+ SEABASE_VALIDATE_LIBRARY,
+
installJar.data(),SUPER_USER,SUPER_USER,
+ &seabaseMDValidateRoutineInfo,
+
sizeof(seabaseMDValidateRoutineColInfo) / sizeof(ComTdbVirtTableColumnInfo),
+ seabaseMDValidateRoutineColInfo))
+ {
+ setValuesInDWS(dws, IT_STEP_FAILED,
+ "Update MDSPJ : Failed", 0, TRUE,
+ FALSE, TRUE, TRUE);
+
+ return 0;
+ }
+ setValuesInDWS(dws, IT_CREATE_PRIVMGR_REPOS,
+ "Create Libraries Tables: Completed", 0,
TRUE,
+ FALSE, TRUE, TRUE);
--- End diff --
Note to myself, since libraries are upgraded before privmgr, I may be able
to make privmgr upgrade faster since it doesn't have to deal with library privs
- to check
> UDR libraries need to be stored in metadata table as a blob
> -----------------------------------------------------------
>
> Key: TRAFODION-3216
> URL: https://issues.apache.org/jira/browse/TRAFODION-3216
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-general
> Affects Versions: 2.4
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
> Fix For: 2.4
>
> Attachments: Support for LOB storage in metadata for UDR
> libraries.docx
>
>
> This is one of many infrastructure changes for SPJs that was planned.
> * {color:#0070c0}Store UDR libraries in BLOBs {color}
> * {color:#0070c0}Add BLOB column to library metadata table{color}
> * {color:#0070c0}Change CREATE LIBRARY command to store library in
> BLOB{color}
> * {color:#0070c0}Change library file names to include the timestamp (so
> updating a library changes the name){color}
> * {color:#0070c0}Add a cache for libraries (a new directory,
> $TRAF_HOME/udr/public/lib){color}
> * {color:#0070c0}Change UDR code to read library from the metadata table
> when not in cache{color}
> * {color:#0070c0}Upgrade support{color}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
