[
https://issues.jboss.org/browse/TEIIDDES-2248?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-2248 at 7/21/14 2:47 PM:
-----------------------------------------------------------------
The parser works if the '' are removed from the parens
{code:sql}
CREATE FOREIGN TABLE "dballo00.dbo.t1" (
c1 string(10) DEFAULT ('c1') OPTIONS (NAMEINSOURCE '"c1"',
NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"',
UPDATABLE TRUE, CARDINALITY 0);
{code}
is '(''c1'')' valid syntax?
was (Author: blafond):
The parser works if the '' are removed from the parens
{code:sql}
CREATE FOREIGN TABLE "dballo00.dbo.t1" (
c1 string(10) DEFAULT ('c1') OPTIONS (NAMEINSOURCE '"c1"',
NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"',
UPDATABLE TRUE, CARDINALITY 0);
{code}
Teiid Connection import fails to parse DDL when table contains
VARCHAR column with DEFAULT value
------------------------------------------------------------------------------------------------
Key: TEIIDDES-2248
URL:
https://issues.jboss.org/browse/TEIIDDES-2248
Project: Teiid Designer
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Import/Export, Teiid Integration
Affects Versions: 8.3.3
Environment: Teiid Designer 8.3.3
Teiid 8.4.1-redhat-7
Reporter: Andrej Šmigala
Assignee: Barry LaFond
Attachments: screen-1.png
Create a table with
{code:sql}
CREATE TABLE t1 ( c1 VARCHAR(10) DEFAULT 'c1' )
{code}
When trying to import it through Teiid Connection Importer, the importer DDL is shown as
{code:sql}
CREATE FOREIGN TABLE "dballo00.dbo.t1" (
c1 string(10) DEFAULT '(''c1'')' OPTIONS (NAMEINSOURCE
'"c1"', NATIVE_TYPE 'varchar')
) OPTIONS (NAMEINSOURCE '"dballo00"."dbo"."t1"',
UPDATABLE TRUE, CARDINALITY 0);
{code}
but on the next page, the following error is shown (see screenshot):
The DDL failed to parse with message: "Unparsable table body".
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)