View Revisions: Issue #5313

Back to Issue
Summary 0005313: Null default values become string values when replicating tables from Oracle to MariaDB
Revision 2022-05-27 15:10 by emiller
Steps To Reproduce
Revision 2022-05-27 20:29 by elong
Steps To Reproduce Oracle:
create table mytest (id integer primary key, name varchar(30) default (null));

Replicate table to MySQL
create table mytest (id integer primary key, name varchar(30) default '(null)');

<database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="dbexport" encoding="UTF-8">
    <table name="MYNULLTEST">
        <column name="ID" primaryKey="true" primaryKeySeq="1" required="true" type="NUMERIC" size="38">
            <platform-column name="oracle" type="NUMBER" size="38"/>
        </column>
        <column name="NAME" type="VARCHAR" size="30" default="(null)">
            <platform-column name="oracle" type="VARCHAR2" size="30" default="(null)"/>
        </column>
    </table>
</database>

CREATE TABLE MYNULLTEST(
    ID NUMBER(38,0) NOT NULL,
    NAME VARCHAR2(30) DEFAULT 'null'
);
ALTER TABLE MYNULLTEST
    ADD CONSTRAINT MYNULLTEST_PK PRIMARY KEY (ID);