× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2013-05-27T15:51:54Z  · swissarmyknife(*) last modified 2013-05-28T21:11:57Z

Auto Completion -> parsing issues -> not auto completing tables columns


customer request
Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component Q Analyzer - Auto-Completion
Version 13.0
open a query analyzer to Oracle 11g R2 at 10.168.11.58:1521    user: sys / ******     as sysdba   SID: AQUA
change to the HR schema and set auto completion to on.  Use the query below.  line 8 is causing the issue in line 9.
select ' ' as annullamento
, substr(to_char(t.COUNTRY_ID,-3) as cod_negozio
, to_char(t.COUNTRY_NAME) as num_bolia
, to_date(t.REGION_ID,'YYYY-MM-DD') as data_bolla
, t.COUNTRY_ID as magazzino
, substr('0000000'||to_char(d.POSTAL_CODE),-7) as cod_articolo
, '?' as utente
, extract(year from to_date(d.CITY, 'YYYY-MM-DD')) as anno_agg
, t.
from HR.COUNTRIES t
left join HR.LOCATIONS d ON t.COUNTRY_ID = d.COUNTRY_ID

 

1 attachment

Issue #9154

Closed
Fixed
Resolved 2013-05-28T15:54:57Z
 
 
Completion
No due date
Fixed Build 13.0.1-14
No time estimate

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