View Issue Details

IDProjectCategoryView StatusLast Update
0005724SymmetricDSBugpublic2023-03-06 17:04
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.5 
Target Version3.14.6Fixed in Version3.14.6 
Summary0005724: SQL Server timestamp (rowversion) data type can not specify column size
DescriptionThe timestamp data type is a deprecated data type, and is now a rowversion data type.
This data type can not specify the size for the rowversion data type. It causes an error with the SQL Server.
The platform column should be stripped of the column size information for this data type.
Steps To Reproduce1. Create a table with a rowversion data type.
2. DB Export the table.
3. DB Import the exported table definition.
Tagsddl/schema, dialect: sql-server

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 168146b5

2023-03-06 15:38:57

pmarzullo

Details Diff
0005724: SQL Server timestamp (rowversion) data type can not specify
column size
Affected Issues
0005724
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2023-03-06 15:37 pmarzullo New Issue
2023-03-06 15:37 pmarzullo Status new => assigned
2023-03-06 15:37 pmarzullo Assigned To => pmarzullo
2023-03-06 15:37 pmarzullo Tag Attached: ddl/schema
2023-03-06 15:37 pmarzullo Tag Attached: dialect: sql-server
2023-03-06 16:00 pmarzullo Changeset attached => SymmetricDS 3.14 168146b5
2023-03-06 17:04 pmarzullo Status assigned => resolved
2023-03-06 17:04 pmarzullo Resolution open => fixed
2023-03-06 17:04 pmarzullo Fixed in Version => 3.14.6
2023-03-17 17:25 admin Status resolved => closed