× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported May 9, 2016  · NielsGron last modified May 9, 2016

SQL Server -> Jobs -> Command Type should not be case sensitive on compare


customer request
Priority Low
Complexity Unknown
Component DB - SQL Server
Version 17.0

  The creation of job steps in SQL Server through DDL statements allows for creating steps with a none case sensitive subsystem type.  Our code had the subsystem type key as case sensitive.  We need to to modify the keys so that the map does not care about case sensitivity when comparing the data retrieved from the database to the type key string.

1 attachment
ivangron   May 9, 2016
Field Old Value New Value
Description

  The creation of job steps in SQL Server through DDL statements allows for creating steps with a none case sensitive subsystem type.  Our code had the subsystem type key as case sensitive.  I have modified the keys to be upper case and have modified the comparison of the HashMap keys with the extraction data so that the casing is not taken into account.  This will allow users to create steps with the subsystem name in any casing and still have the GUI's correctly work with the job steps type.

  The creation of job steps in SQL Server through DDL statements allows for creating steps with a none case sensitive subsystem type.  Our code had the subsystem type key as case sensitive.  We need to to modify the keys so that the map does not care about case sensitivity when comparing the data retrieved from the database to the type key string.

ivangron   May 9, 2016
Field Old Value New Value
Status New In Progress
ivangron   May 9, 2016
Field Old Value New Value
Fixed Build v17.0.4-5
Resolution Fixed
Resolved Date May 9, 2016 3:13 PM
Status In Progress Resolved
ivangron   May 9, 2016
Field Old Value New Value
QA Assignee tariqrahiman (Tariq Rahiman) NielsGron (Niels Gron)
NielsGron   May 9, 2016
Field Old Value New Value
Status Resolved Closed

Issue #14420

Closed
Fixed
Resolved May 9, 2016
 
 
Completion
No due date
Fixed Build v17.0.4-5
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017