Details
-
Bug
-
Resolution: Done
-
Major
-
7.1.1
-
None
Description
I'm executing the TPCR Text metadata test and ran into the word "value" which is being used as a column name. Since it's reserved, it needs to be enclosed in quotes. Now, as part of a text metadata import, it's already a quoted string, so I need to somehow escape the quotation marks around value.
\" and "" both failed to work. The metadata text is:
Q11, "SELECT PS_PARTKEY, SUM((PS_SUPPLYCOST * PS_AVAILQTY)) AS value FROM TPCR.PARTSUPP, TPCR.SUPPLIER, TPCR.NATION WHERE (PS_SUPPKEY = S_SUPPKEY) AND (S_NATIONKEY = N_NATIONKEY) AND (N_NAME = 'GERMANY') GROUP BY PS_PARTKEY HAVING SUM((PS_SUPPLYCOST * PS_AVAILQTY)) > (SELECT (SUM((PS_SUPPLYCOST * PS_AVAILQTY)) * 1.0E-4) FROM TPCR.PARTSUPP, TPCR.SUPPLIER, TPCR.NATION WHERE (PS_SUPPKEY = S_SUPPKEY) AND (S_NATIONKEY = N_NATIONKEY) AND (N_NAME = 'GERMANY'))", "TPCR Query 11"
The importer and/or parser should take into account the need to escape quotes.