Details
Description
Before KULRICE-3686 can be resolved, the following SQL needs to be executed against the master databases so that date parsing/formatting works properly with DD searchable attributes outside of the unit test context, and so that the @Ignore annotation on the DataDictionarySearchableAttributeTest class can be safely removed:
UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_DATE_FORMATS' AND APPL_NMSPC_CD='KUALI'
/
UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy hh:mm a;MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_TIMESTAMP_FORMATS' AND APPL_NMSPC_CD='KUALI'
/
CREATE TABLE ACCT_DD_ATTR_DOC (
DOC_HDR_ID VARCHAR2(14),
OBJ_ID VARCHAR2(36),
VER_NBR NUMBER(14),
ACCT_NUM NUMBER(14) NOT NULL,
ACCT_OWNR VARCHAR2(50) NOT NULL,
ACCT_BAL NUMBER(16,2) NOT NULL,
ACCT_OPN_DAT DATE NOT NULL,
ACCT_STAT VARCHAR2(30) NOT NULL,
ACCT_UPDATE_DT_TM TIMESTAMP,
ACCT_AWAKE VARCHAR2(1),
CONSTRAINT ACCT_DD_ATTR_DOC_PK PRIMARY KEY (DOC_HDR_ID)
)
/
Note that the new table shown above is only needed for unit tests, meaning that table may also have to be added to a cleanup script so that non-test databases can easily remove it.
Attachments
Issue Links
- is relied upon by
-
KULRICE-3686 Write Data Dictionary based doc search unit tests
-
- Closed
-
Scripts have been run on the 1.0.1.1 master database.
Files have been updated and committed:
rice-1.0.1.1/scripts/dataset/bootstrap-server-dataset-cleanup.sql
rice-1.0.1.1/scripts/upgrades/1.0.1 to 1.0.1.1/db-updates/12-07-2009.sql