View Issue Details

IDProjectCategoryView StatusLast Update
0003419SymmetricDSBugpublic2022-08-30 13:04
Reportersven Assigned Toemiller  
Status closedResolutionfixed 
Product Version3.8.33 
Target Version3.14.1Fixed in Version3.14.1 
Summary0003419: MS SQL -> SQLite, don't translate "NEXT VALUE FOR" default value
DescriptionI have a table in MS SQL Server that has a default value of NEXT VALUE FOR [column]. During the initial load process Symmetric tries to translate this into SQLite, which does not support this default value and therefore throws an error for the outgoing batch, halting progress.
Steps To ReproduceTable in SQL with a default value of NEXT VALUE FOR
Try to replicate to a SQLite database
Additional Information2018-02-13 12:54:48,626 ERROR [v3-mc-0000000] [AcknowledgeService] [qtp1006485584-14] The outgoing batch xxx-250 failed: [,1] [SQLITE_ERROR] SQL error or missing database (near "VALUE": syntax error)

relevant portion of batch file:
        <column name=\"col\" type=\"INTEGER\" size=\"10\" default=\"NEXT VALUE FOR [col]\">
            <platform-column name=\"mssql2008\" type=\"int\" size=\"10\" default=\"NEXT VALUE FOR [col]\"/>
Tagsddl/schema, dialect: sql-server, initial/partial load



2018-02-13 18:15

reporter   ~0001125

I forgot to note that according to the database architecture listed in sym_node, Symmetric is correctly identifying the client DB as SQLite.

Related Changesets

SymmetricDS: 3.14 e6ac8b2d

2022-08-15 19:08:28


Details Diff
0003419: Prevented SQLite from trying to use 'NEXT VALUE FOR' as a default column value Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/ Diff File

Issue History

Date Modified Username Field Change
2018-02-13 18:13 sven New Issue
2018-02-13 18:13 sven Tag Attached: mssql
2018-02-13 18:13 sven Tag Attached: sqlite
2018-02-13 18:15 sven Note Added: 0001125
2019-04-23 20:49 admin Tag Renamed mssql => dialect: mssql
2019-04-23 20:51 admin Tag Renamed sqlite => dialect: sqlite
2019-04-24 12:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2019-04-24 17:33 elong Tag Attached: ddl/schema
2019-04-24 17:33 elong Tag Attached: initial/partial load
2019-04-24 17:33 elong Tag Detached: dialect: sqlite
2022-08-15 19:08 emiller Assigned To => emiller
2022-08-15 19:08 emiller Status new => resolved
2022-08-15 19:08 emiller Resolution open => fixed
2022-08-15 19:08 emiller Fixed in Version => 3.14.1
2022-08-15 20:00 Changeset attached => SymmetricDS 3.14 e6ac8b2d
2022-08-30 13:04 admin Status resolved => closed