View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0002247 | SymmetricDS | Bug | public | 2015-03-31 18:25 | 2020-02-19 14:37 |
Reporter | natarajan | Assigned To | |||
Priority | urgent | ||||
Status | new | Resolution | open | ||
Product Version | 3.7.11 | ||||
Summary | 0002247: dbexport oracle date type with "default sysdate" not compatible with other databases | ||||
Description | In mysql we don't have default sysdate and date should be converted to datetime. Please let us know if you have solution for this one? Oracle CREATE TABLE CTT1.TTT_USER_METRICS_HISTORY ( USER_ID NUMBER, TRANSACTION_ID VARCHAR2(100 BYTE), TRANSACTION_COUNT NUMBER, LST_UPTD_DTTM DATE DEFAULT SYSDATE NOT NULL ) MYSQL CREATE TABLE `TTT_USER_METRICS_HISTORY`( `USER_ID` DECIMAL, `TRANSACTION_ID` VARCHAR(100) NULL, `TRANSACTION_COUNT` DECIMAL, `LST_UPTD_DTTM` DATE DEFAULT SYSDATE NOT NULL ) | ||||
Tags | ddl/schema | ||||