I am trying to run the following query in VS Code
select
*
from
dw_schema.stuff_things_f fct
inner join dw_schema.location_d locd on locd.location_id = fct.location_id and locd.dw_latest_flag = 'Y'
where
1=1
and trunc(fct.stuff_datetime) between to_date('01/01/2023', 'DD/MM/YYYY') and to_date('01/01/2024', 'DD/MM/YYYY')
and lower(locd.site_location_name) in ('stuff', 'things')
;
Running this in VS Code returns the following output in the extension log for the SQL developer extension
See attached log file due to size limitations
Running the same query in the legacy SQL Developer application works without error
1-SQL Developer.log