Simple ddl like

create or replace table df_mdm_dev.foo as
(select 1 x)

Runs fine in native google cloud console

In ADS (legacy sql unchecked)



>[Error] Script lines: 1-2 --------------------------
Syntax error: There are invalid tokens specified in the command.
________________________________

[Executed: 2/12/2020 1:05:29 PM] [Execution: 0ms]


select * from df_mdm_dev.foo (select from earlier console created table is fine)


[Executed: 2/12/2020 1:05:29 PM] [Execution: 0ms]

x
----
1


Same error with legacy checked

(not shown)


Product: Aqua Data Studio
Version: 20.0.4
Build #: 57271
Build Date: 2019-Oct-21 09:27:07 AM

Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_172-b11
Memory: Max=954,728,448; Total=880,803,840; Free=542,831,616; CPUs=8