LOAD INLINE

[CarloRomagnano]

In the script below, the variable v_file is not expanded only in the WHERE clause because of ";" after "my_filter=;".
If I change ";" with another char (e.g. my_filter=; -> my_filter=#) then v_file is expanded correctly.

P.S. If in the WHERE clause I add another condition (e.g. OR 1=1) the line is loaded else st_FileName = '$(v_file)' always is false.

Maybe it is a BUG?

LET v_file = 'abc';

SecTab:
LOAD *,'$(v_file)' AS A INLINE [
st_User,st_FileName,st_Filter
AD\ADELE,abc,my_filter=;
]
WHERE st_FileName = '$(v_file)'
;

[MayilVahanan · Accepted solution]

HI @CarloRomagnano 

May be, try like this

LET v_file = 'abc';

SecTab:
LOAD *,'$(v_file)' AS A INLINE [
st_User,st_FileName,st_Filter
AD\ADELE,abc,'my_filter=;'
]
WHERE st_FileName = '$(v_file)'
;