View Issue Details

IDProjectCategoryView StatusLast Update
0003964SymmetricDSBugpublic2019-05-17 19:52
ReporterhanesAssigned To 
Prioritynormal 
Status confirmedResolutionopen 
Product Version3.10.2 
Target VersionFixed in Version 
Summary0003964: Oracle's REAL datatype should map to DOUBLE in MariaDB, not FLOAT
DescriptionCurrently, REAL is mapped to a FLOAT in MariaDB. Should be mapped to a DOUBLE.

Interestingly, the XML passes FLOAT over as a FLOAT(63) from Oracle, which is accurate (FLOAT has a binary precision of 63 on Oracle)

create table test26 (myreal real,
     myId varchar(256), primary key (myId));


Results in the following Create Table on MariaDB side:



[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="TEST26">
        <column name="MYID" primaryKey="true" required="true" type="VARCHAR" size="256">
            <platform-column name="oracle" type="VARCHAR2" size="256"/>
        </column>
        <column name="MYREAL" type="REAL" size="63">
            <platform-column name="oracle" type="FLOAT" size="63"/>
        </column>
    </table>
</database>
[store-001] - MariaDBDatabasePlatform - Running alter sql:
CREATE TABLE `test26`(
    `myid` VARCHAR(256) NOT NULL,
    `myreal` FLOAT,
    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, test26)
[store-001] - RouterService - Routed 3 data events in 18 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 14:57 hanes New Issue
2019-05-15 14:57 hanes Status new => confirmed
2019-05-17 19:52 elong Tag Attached: ddl/schema
2019-05-17 19:52 elong Tag Attached: dialect: mysql/mariadb