View Issue Details

IDProjectCategoryView StatusLast Update
0006446SymmetricDSImprovementpublic2024-05-23 18:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.15 
Target Version3.14.16Fixed in Version3.14.16 
Summary0006446: Provide the ability to specify a no lock hint when reading DDL
DescriptionWhen reading DDL, we should provide the ability to specify a hint for a query that executes the query with no locks.
For example, when determining auto increment columns for SQL Server, we could specify WITH(NOLOCK) on the query since it is extremely unlikely that changes to DDL would be occurring when reading the column metadata for a table.
Tagsddl/schema, dialect: sql-server

Relationships

related to 0006448 closedpmarzullo Provide the ability to specify a no lock hint when reading DDL 

Activities

Related Changesets

SymmetricDS: 3.14 fb69de2c

2024-05-23 16:56:38

pmarzullo

Details Diff
0006446: Provide the ability to specify a no lock hint when reading DDL Affected Issues
0006446
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java Diff File

SymmetricDS: 3.15 01345d28

2024-05-23 16:56:38

pmarzullo

Details Diff
0006446: Provide the ability to specify a no lock hint when reading DDL Affected Issues
0006446
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java Diff File
mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java Diff File

Issue History

Date Modified Username Field Change
2024-05-23 16:51 pmarzullo New Issue
2024-05-23 16:51 pmarzullo Status new => assigned
2024-05-23 16:51 pmarzullo Assigned To => pmarzullo
2024-05-23 16:51 pmarzullo Tag Attached: ddl/schema
2024-05-23 16:51 pmarzullo Tag Attached: dialect: sql-server
2024-05-23 16:52 pmarzullo Project SymmetricDS Pro => SymmetricDS
2024-05-23 16:54 pmarzullo Relationship added related to 0006448
2024-05-23 17:00 pmarzullo Changeset attached => SymmetricDS 3.14 fb69de2c
2024-05-23 17:08 pmarzullo Status assigned => resolved
2024-05-23 17:08 pmarzullo Resolution open => fixed
2024-05-23 17:08 pmarzullo Fixed in Version => 3.14.16
2024-05-23 17:08 pmarzullo Note Added: 0002451
2024-05-23 18:00 pmarzullo Changeset attached => SymmetricDS 3.15 01345d28
2024-08-16 17:44 admin Status resolved => closed