View Issue Details

IDProjectCategoryView StatusLast Update
0003966SymmetricDSBugpublic2019-05-17 19:52
ReporterhanesAssigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.10.2 
Target VersionFixed in Version 
Summary0003966: Oracle's CLOB (and NCLOB) type incorrectly maps to MariaDB's MEDIUMTEXT
DescriptionOracle's CLOB type is incorrectly mapping to MariaDB as a MEDIUMTEXT, and should be a LONGTEXT. Also of interest is that the XML itself shows that the CLOB is of size 4000, which is incorrect. That may be playing a part in the decision of MEDIUMTEXT vs LONGTEXT.

Source Table:

            
create table test10 (myclob clob,
    myId varchar(256), primary key (myId));

Resulting Target Create:



[store-001] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="TEST10">
        <column name="MYID" primaryKey="true" required="true" type="VARCHAR" size="256">
            <platform-column name="oracle" type="VARCHAR2" size="256"/>
        </column>
        <column name="MYCLOB" type="LONGVARCHAR" size="4000">
            <platform-column name="oracle" type="CLOB" size="4000"/>
        </column>
    </table>
</database>
[store-001] - MariaDBDatabasePlatform - Running alter sql:
CREATE TABLE `test10`(
    `myid` VARCHAR(256) NOT NULL,
    `myclob` MEDIUMTEXT NULL,
    PRIMARY KEY (`myid`)
);

[store-001] - PullService - Pull data received from corp:000:000 on queue default. 4 rows and 2 batches were processed. (sym_table_reload_request, test10)
[store-001] - RouterService - Routed 3 data events in 18 ms
[store-001] - PullService - Pull data received from corp:000:000 on queue default. 0 rows and 1 batches were processed. ()
[store-001] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="TEST10">
        <column name="MYID" primaryKey="true" required="true" type="VARCHAR" size="256">
            <platform-column name="oracle" type="VARCHAR2" size="256"/>
        </column>
        <column name="MYCLOB" type="LONGVARCHAR" size="4000">
            <platform-column name="oracle" type="CLOB" size="4000"/>
        </column>
    </table>
</database>
[store-001] - MariaDBDatabasePlatform - Tables up to date. No alters found for test10
[store-001] - PullService - Pull data received from corp:000:000 on queue default. 1 rows and 1 batches were processed. (test10)
[store-001] - StagingManager - Cleaning staging...
[store-001] - StagingManager - Finished cleaning staging in 0 seconds.
[gui] - SqlRunner - [store-001] Executing: drop table test10
[store-001] - ConfigurationChangedDatabaseWriterFilter - About to syncTriggers because new configuration came through the data loader
[store-001] - TriggerRouterService - Synchronizing triggers
[store-001] - TriggerRouterService - Done synchronizing triggers
[store-001] - PullService - Pull data received from corp:000:000 on queue default. 1 rows and 1 batches were processed. (sym_trigger)
[store-001] - RouterService - Routed 1 data events in 50 ms






Tagsddl/schema, dialect: mysql/mariadb

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-05-15 15:10 hanes New Issue
2019-05-15 15:10 hanes Status new => confirmed
2019-05-15 15:26 hanes Summary Oracle's CLOB type incorrectly maps to MariaDB's MEDIUMTEXT => Oracle's CLOB (and NCLOB) type incorrectly maps to MariaDB's MEDIUMTEXT
2019-05-17 19:52 elong Tag Attached: ddl/schema
2019-05-17 19:52 elong Tag Attached: dialect: mysql/mariadb