1 Reply Latest reply on Feb 23, 2015 5:19 AM by Steven Hawkins

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

    Shiveeta Mattoo Newbie

      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.