#9154: Auto Completion -> parsing issues -> not auto completing tables columns

ivangron reported May 27, 2013 · swissarmyknife(*) last modified May 28, 2013

Dev	kin-hong
QA	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

All Comments Change History (2)

kin-hong May 28, 2013

swissarmyknife(*) May 28, 2013

Field	Old Value	New Value
Fixed Build		13.0.1-14
Status	Resolved	Closed