× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2015-05-19T22:57:45Z  · SachinPrakash last modified 2015-09-09T23:09:49Z

Automate -> Introduce Columns does not take in account Quote Identifier under File->Options->Scripts->[Database]


customer request
Priority Low
Complexity Unknown
Component App - SQL Automation
Version 16.0
Automate -> Introduce Columns does not take in account Quote Identifier under File->Options->Scripts->[Database]-> [Quote Identifier for Table Completion] = "object name"
 
To reproduce:
 
1. Connect to MS SQL Server.
2. Create a new table with below DDL
 
CREATE TABLE "dbo"."TestSpaces 2"  ( 
"Field 1" varchar(25) NULL,
"Field 2." varchar(25) NULL,
"c"       varchar(25) NULL 
)
GO
 
 
3. Now set the below options:
 
File->Options->Scripts->[MS SQL Server]->[Quote Identifier for Table Completion] = "object name" and 
File->Options->Scripts->[MS SQL Server]->[Quote Identifier for Column Completion] = "object name"
 
4. Now open a new query window to SQL Server and type in SELECT  FROM "dbo"."TestSpace 2", keep the cursor between the SELECT and FROM and then go to option Automate -> Introduce Columns, the column names appear without the Quote Identifier.
5. We don't take into consideration the quote identifier. 
2 attachments

Issue #13344

Closed
Fixed
Resolved 2015-05-27T20:44:36Z
 
 
Completion
No due date
Fixed Build v16.0.5-10, v17.0.0-dev-39
No time estimate

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