View Issue Details

IDProjectCategoryView StatusLast Update
0004001SymmetricDSBugpublic2019-07-17 10:24
ReporterSaihtam8Assigned To 
Status confirmedResolutionopen 
Product Version3.10.2 
Target VersionFixed in Version 
Summary0004001: Default value being passed as string for MS Sql Server
Descriptionin sql server to sql server replication the default value functions of newid() and newsequentialid() are being passed as strings i.e. 'newid()' and 'newsequentialid()'
Steps To Reproducecreate a table with a column with the data type of uniqueidentifier
set the default value to either newid() or newsequentialid()
replicate the table allowing symmetric to create the table
check the new table and the functions will show up as strings
any inserts into the table will then fail as it try's to insert a string into a uniqueidentifier column
Tagsddl/schema, dialect: sql-server


related to 0001753 new Default values that are functions do not work while creating tables in MySQL 



2019-07-17 10:21

developer   ~0001557

create table foo (id varchar(50), myid uniqueidentifier default newid(), primary key (id));

Table is created on the target using a string value, not a function. Inserts to the target table then fail.

Issue History

Date Modified Username Field Change
2019-06-13 08:20 Saihtam8 New Issue
2019-06-13 08:33 elong Tag Attached: ddl/schema
2019-06-13 08:33 elong Tag Attached: dialect: sql-server
2019-07-17 10:21 hanes Status new => confirmed
2019-07-17 10:21 hanes Note Added: 0001557
2019-07-17 10:23 hanes Relationship added related to 0001753
2019-07-17 10:24 hanes Summary Default value being passed as string => Default value being passed as string for MS Sql Server