View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007040 | SymmetricDS | New Feature | public | 2025-08-29 13:23 | 2025-10-03 22:47 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.7 | Fixed in Version | 3.16.7 | ||
| Summary | 0007040: Add support for the sql_variant column type (in MS SQL Server) | ||||
| Description | Add support for the sql_variant column type (in MS SQL Server) Values of the sql_variant could be of various sub-types and require additional information in the data batch. | ||||
| Steps To Reproduce | CREATE TABLE test_variant( id INT PRIMARY KEY, varcol SQL_VARIANT ) INSERT INTO test_variant (id, varcol) VALUES (1, 'Hello World'), -- String (2, 123), -- Integer (3, 45.67), -- Decimal (4, GETDATE()); -- Datetime | ||||
| Additional Information | https://learn.microsoft.com/en-us/sql/t-sql/data-types/sql-variant-transact-sql?view=sql-server-ver17 | ||||
| Tags | dialect: sql-server | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-08-29 13:23 | pmarzullo | New Issue | |
| 2025-08-29 13:23 | pmarzullo | Status | new => assigned |
| 2025-08-29 13:23 | pmarzullo | Assigned To | => pmarzullo |
| 2025-08-29 13:23 | pmarzullo | Tag Attached: dialect: sql-server | |
| 2025-08-30 12:36 | pbelov | Product Version | 3.16.6 => 3.16.0 |
| 2025-08-30 12:36 | pbelov | Target Version | 3.16.6 => 3.16.7 |
| 2025-08-30 12:36 | pbelov | Summary | SQL Server sql_variant data type support => Add support for the sql_variant column type (in MS SQL Server) |
| 2025-08-30 12:36 | pbelov | Description Updated | View Revisions |
| 2025-08-30 12:36 | pbelov | Steps to Reproduce Updated | View Revisions |
| 2025-08-30 12:36 | pbelov | Additional Information Updated | View Revisions |
| 2025-09-08 19:59 | pbelov | Status | assigned => resolved |
| 2025-09-08 19:59 | pbelov | Resolution | open => fixed |
| 2025-09-08 19:59 | pbelov | Fixed in Version | => 3.16.7 |
| 2025-10-03 22:47 | pbelov | Note Added: 0003484 | |
| 2025-10-03 22:47 | pbelov | Status | resolved => closed |