[JBoss JIRA] (TEIIDDES-3090) Parsing error on Preview in Teiid Designer if the source column has a default value
3:46 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-3090?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-3090 at 7/17/17 4:45 PM:
-----------------------------------------------------------------
[~dsteigne] This is due to the nature/limitations of "default value" strings.
In this case
*'user name'::text* is the culprit (.. note if you defined the entire string as
*'\'user name\'::text'* it would work)
In TEIIDDES-2888 the default value *('STOCK')* which may be fine for a database,
but Teiid treats that string differently and should probably be entered as
*\'Stock\'*. When exported it ends up as *'\'Stock\''*
In both cases, the Teiid parser expecting a single string enclosed in single quotes and
everything in-between needs to be properly escaped.
Since in your case and TEIIDDES-2888, the default value string is being imported and
I'm not sure if we should auto-correct/alter users's metadata.
was (Author: blafond):
[~dsteigne] This is due to the nature/limitations of "default value" strings.
In this case
*'user name'::text* is the culprit (.. note if you defined the entire string as
*'\'user name\'::text'* it would work)
In TEIIDDES-2888 the default value *('STOCK')*
In both cases, the Teiid parser expecting a single string enclosed in single quotes and
everything in-between needs to be properly escaped.
Since in your case and TEIIDDES-2888, the default value string is being imported and
I'm not sure if we should auto-correct/alter users's metadata.
Parsing error on Preview in Teiid Designer if the source column has a
default value
-----------------------------------------------------------------------------------
Key: TEIIDDES-3090
URL: https://issues.jboss.org/browse/TEIIDDES-3090
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 11.0.1
Reporter: Debbie Steigner
Assignee: Barry LaFond
Parsing error[1] on Preview in Teiid Designer if the source column has a default value.
[1]
13:40:03,990 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB
PREVIEW-32405570-21e1-4a40-ace7-21b408420884.1 model "debschema" metadata failed
to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100
Parsing error: Encountered ") DEFAULT ''[*]user[*] name'::text'"
at line 4, column 47.
Was expecting: "options" | "," | ")":
org.teiid.metadata.ParseException: TEIID30386
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
") DEFAULT ''[*]user[*] name'::text'" at line 4, column 47.
Was expecting: "options" | "," | ")"
at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:769)
[teiid-api-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at
org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at
org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84)
[teiid-runtime-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at
org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
[teiid-jboss-integration-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
[teiid-jboss-integration-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_60]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_60]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_60]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error:
Encountered ") DEFAULT ''[*]user[*] name'::text'" at line 4,
column 47.
Was expecting: "options" | "," | ")"
at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214)
[teiid-engine-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2]
... 11 more
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
2504
days inactive
2504
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
participants (1)
-
Barry LaFond (JIRA)