× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2013-04-15T20:43:14Z  · last modified 2013-04-16T18:21:39Z

Auto-completion doesn't work when the from clause is parenthesized


customer request
Dev
Kin-Hong Wong
kin-hong
QA
Sachin Prakash
SachinPrakash
Priority Major
Complexity Unknown
Component Q Analyzer - Auto-Completion
Version 12.0

 

Version: 12.0.18-8
Build #: 31895
Build Date: 2013-Apr-10 01:26:40 PM

Auto-completion doesn't work when the from clause is parenthesized.

To reproduce:

1. Connect to SQL Server 2000 to the Northwind Database, Open a query analyzer and execute the below 2 queries.

2. Now for the 1st query, place the cursor as in attached pic and prompt for autocompletion, it pops up.

3. For the 2nd query if you place the cursor at the same position, autocompletion wont work. The difference is the () after the FROM clause in the 2 queries. If you remove the () autocompletion pops up correctly.

 

select so.OrderDate,
so.RequiredDate + CONVERT(NVARCHAR,so.ShippedDate,14) as date
from 
Employees E inner join Orders so on so.EmployeeID=E.EmployeeID
where so.ShipCity IN('Reims','Lyon','Bern','Resende','Graz')
go
 
select so.OrderDate,
so.RequiredDate + CONVERT(NVARCHAR,so.ShippedDate,14) as date
from 
(Employees E inner join Orders so on so.EmployeeID=E.EmployeeID)
where so.ShipCity IN('Reims','Lyon','Bern','Resende','Graz')
go
1 attachment
  • 1.png
    1.png

    2013-04-15T20:43:14Z

    81 KB

  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #8672
Closed
Fixed
Resolved 2013-04-16T15:20:25Z
 
 
Completion
No due date
Fixed Build 12.0.19-2
No time estimate

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