ora2pg icon indicating copy to clipboard operation
ora2pg copied to clipboard

Reserverd word year/month not recognised in with

Open duursma opened this issue 3 years ago • 0 comments

The with part of a query: with data as ( select accumulation_nm, operator_nm, extract (year from t1.start_date) year, extract (month from t1.start_date) month, quantity / 1000 as quantity FROM res_prod_fig_mnth_acc_gas_d t1 )

Get transformed into: with data as ( select accumulation_nm, operator_nm, extract(year FROM t1.start_date) year, extract(month from t1.start_date) month, quantity / 1000 as quantity FROM res_prod_fig_mnth_acc_gas_d t1 )

But both 'year' and 'month' are reserved words and should be quoted as the quoting of reserverd words was enabled in the config.

duursma avatar May 17 '22 15:05 duursma