File Source | Error due to closed brackets present in column names

[shiveeta.mattoo]

Hi,

Due to presence of closed brackets "()" in column names of a file, although VDS deployment is successful, the query execution does not give any output results for that coulmn.

The file contents - 

(a),b

1,2

3,4

The query is as below. We have tried enclosing the column name in double quotes.

"SELECT A.\"(a)\",A.\"b\" FROM (EXEC closedbracketswithbreak.getFiles('closedbreakbrackets.txt')) AS F, TEXTTABLE(TO_CHARS(F.file,'UTF-8') COLUMNS \"(a)\" INTEGER,\"b\" INTEGER delimiter ',' quote '\u0000' HEADER) AS A"

The output of select * from closedbreakbrackets -

If there is a single open or closed bracket in column name, it works fine.

a(,b  --> works fine

a),b --> works fine

(a),b --> no results

()a,b --> no results

Please let me know if this is a known issue or a bug can be filed for this behaviour.

[shawkins]

I don't see the same behavior.  What client are you submitting from?  Can you double check the server log for the submitted sql?

For example if I issue:

select * from texttable('(a),b\n1,2\n3,4' COLUMNS "(a)" INTEGER,"b" INTEGER delimiter ',' quote '\u0000' HEADER) x

I see the expected results.