Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism ---------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-712 URL: https://jira.jboss.org/browse/TEIIDDES-712 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1.1 Environment: JBDS 4.0.0 Beta 1, Fedora 12 Reporter: Paul Nittel Fix For: 7.1.1 Attachments: EscapeQuotes.zip 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.

Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism ---------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-712 URL: https://jira.jboss.org/browse/TEIIDDES-712 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1.1 Environment: JBDS 4.0.0 Beta 1, Fedora 12 Reporter: Paul Nittel Fix For: 7.1.1 Attachments: EscapeQuotes.zip, TpcrQueries.txt, TPCR_ViewTransformations.txt 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.

Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism ---------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-712 URL: https://jira.jboss.org/browse/TEIIDDES-712 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.1.1 Environment: JBDS 4.0.0 Beta 1, Fedora 12 Reporter: Paul Nittel Assignee: Barry LaFond Fix For: 7.1.1 Attachments: EscapeQuotes.zip, TpcrQueries.txt, TPCR_ViewTransformations.txt, VirtualTableRowObject.patch 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.