View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006621 | SymmetricDS | Bug | public | 2024-10-18 19:51 | 2024-10-18 19:51 |
| Reporter | pbelov | Assigned To | pbelov | ||
| Priority | normal | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.15.0 | ||||
| Summary | 0006621: NVARCHAR(MAX) and VARCHAR(MAX) columns get modified when another column is updated (SQLServer-specific) | ||||
| Description | NVARCHAR(MAX) and VARCHAR(MAX) columns get modified when another column is updated (SQLServer-specific) | ||||
| Steps To Reproduce | Server db=SQL Server (SymmetricRoot schema) Client db=SQL Server (SymmetricClient schema) CREATE TABLE SymmetricRoot (and on SymmetricClient).dbo.test_nvarchar_max( col1 nvarchar(7) ,col2 int NULL ,comments nvarchar(max) NULL ,CONSTRAINT UX_RO_LICNO_RO_NO UNIQUE (col1) ); INSERT INTO SymmetricRoot.dbo.test_nvarchar_max VALUES ('row1', 100, 'TEST_COMMENT_1'); -- Observe row sent over to the Client -- Run two updates (one on Root, one on Client) UPDATE SymmetricRoot.dbo.test_nvarchar_max SET col2=200 WHERE col1='row1'; UPDATE SymmetricClient.dbo.test_nvarchar_max SET COMMENTS='TEST_COMMENT_5' WHERE col1='row1'; -- Observe client row loosing it's new value in the COMMENTS column (reset to match Root) -- Results on Client: col1='row1' col2=200 COMMENTS='TEST_COMMENT_1' | ||||
| Additional Information | This issue is specific to SQL Server dialect in how it triggers handle the NVARCHAR(MAX) and VARCHAR(MAX) data types. | ||||
| Tags | No tags attached. | ||||