View Issue Details

IDProjectCategoryView StatusLast Update
0006201SymmetricDSImprovementpublic2024-03-18 14:47
Reportercquamme Assigned Tocquamme  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.4Fixed in Version3.15.4 
Summary0006201: Add support for NTypes in XML
DescriptionAny platform that supports NTypes should output this type in its XML, and other platforms should be able to accept this XML.

So for example, currently, the XML of an oracle column of type NVARCHAR2 looks like this:

<column name="NVARCHAR2TEST" type="VARCHAR" size="255">
            <platform-column name="oracle23" type="NVARCHAR2" size="255"/>
</column>

This incorrectly identifies an Oracle NVARCHAR2 as a VARCHAR, when it should be a type NVARCHAR. Here's the correct XML:

<column name="NVARCHAR2TEST" type="NVARCHAR" size="255">
        <platform-column name="oracle23" type="NVARCHAR2" size="255"/>
</column>
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 f971cf8e

2024-01-31 13:19:22

cquamme

Details Diff
0006201: Add support for NTypes in XML Affected Issues
0006201
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlBuilder.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/oracle/OracleDdlReader.java Diff File

SymmetricDS: 3.15 2117b275

2024-01-31 20:04:49

cquamme

Details Diff
0006201: Add support for NTypes in XML Affected Issues
0006201
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlBuilder.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2024-01-23 16:05 cquamme New Issue
2024-01-23 16:05 cquamme Status new => assigned
2024-01-23 16:05 cquamme Assigned To => cquamme
2024-01-23 16:11 cquamme Category Bug => Improvement
2024-01-23 16:11 cquamme Summary Oracle XML incorrectly identifies "NVARCHAR2" as "VARCHAR" => Add support for NTypes in XML
2024-01-23 16:11 cquamme Description Updated View Revisions
2024-01-23 16:29 cquamme Description Updated View Revisions
2024-01-31 20:09 cquamme Status assigned => resolved
2024-01-31 20:09 cquamme Resolution open => fixed
2024-01-31 20:09 cquamme Fixed in Version => 3.15.3
2024-01-31 20:11 cquamme Status resolved => assigned
2024-01-31 20:11 cquamme Resolution fixed => open
2024-01-31 20:11 cquamme Fixed in Version 3.15.3 =>
2024-02-01 15:10 cquamme Target Version 3.15.3 => 3.15.4
2024-02-15 20:28 cquamme Changeset attached => SymmetricDS 3.15 2117b275
2024-02-15 20:28 cquamme Changeset attached => SymmetricDS 3.15 f971cf8e
2024-03-18 14:47 cquamme Status assigned => resolved
2024-03-18 14:47 cquamme Resolution open => fixed
2024-03-18 14:47 cquamme Product Version => 3.15.0
2024-03-18 14:47 cquamme Fixed in Version => 3.15.4
2024-03-19 16:20 admin Status resolved => closed