Since recent upgrade (now on QueryTool 22.0.578) it seems that something is broken with the files object:
select * from files('C:\jobs\','*.xml',false)@Os
QueryTool says:
mismatched input ‘@’ expecting {, ‘;’}.
Since recent upgrade (now on QueryTool 22.0.578) it seems that something is broken with the files object:
select * from files('C:\jobs\','*.xml',false)@Os
QueryTool says:
mismatched input ‘@’ expecting {, ‘;’}.
The updated syntax is files@os
, so table and data container alias together.
I think this was updated by mistake on 22.0 too instead of just on the new 22.1.
Thanks, how to pass the parameters with the new syntax then ?
Like so:
select *
from files@os('C:\jobs\','*.xml',false)
It works thanks.
Same remark for read_file_text@os(parameters...)