View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005415SymmetricDSImprovementpublic2022-08-19 17:042022-08-30 13:04
Reporterjosh-a-hicks Assigned Tojosh-a-hicks  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.1Fixed in Version3.14.1 
Summary0005415: Detection of MSSQL Azure Managed Instance
DescriptionMSSQL Azure managed instance databases have a version number 12 which conflicts with standalone versioning. As a result they are assigned to the 2008 MSSQL Platform at startup. This results in the wrong disable trigger function versions being installed and will not work. The fix is now to also use the following query to determine the engine edition. The engine edition of 8 is reserved for managed instances of MSSQL in Azure.

SELECT CAST(SERVERPROPERTY('EngineEdition') AS INT)

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 7159836f

2022-08-19 17:05:06

joshahicks

Details Diff 		0005415: Detection of MSSQL Azure Managed Instance Affected Issues
0005415
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseNamesConstants.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/JdbcDatabasePlatformFactory.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2016DatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2022-08-19 17:04 josh-a-hicks New Issue
2022-08-19 17:04 josh-a-hicks Status new => assigned
2022-08-19 17:04 josh-a-hicks Assigned To => josh-a-hicks
2022-08-24 17:39 josh-a-hicks Status assigned => resolved
2022-08-24 17:39 josh-a-hicks Resolution open => fixed
2022-08-24 17:39 josh-a-hicks Fixed in Version => 3.14.1
2022-08-29 19:00 Changeset attached => SymmetricDS 3.14 7159836f
2022-08-30 13:04 admin Status resolved => closed