[teiid-issues] [JBoss JIRA] (TEIID-2827) Not sure why Teiid is creating errors based on the database metadata
Steven Hawkins (JIRA)
issues at jboss.org
Wed Jan 29 12:23:28 EST 2014
[ https://issues.jboss.org/browse/TEIID-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12939820#comment-12939820 ]
Steven Hawkins commented on TEIID-2827:
---------------------------------------
Presumably the source does allow for those columns to be defaultable. It's just not reflected in the created external table statements you're showing here. When you change the column s to be null able then we know there is an appropriate default.
> Not sure why Teiid is creating errors based on the database metadata
> --------------------------------------------------------------------
>
> Key: TEIID-2827
> URL: https://issues.jboss.org/browse/TEIID-2827
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.4.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Attachments: createdb.sql, perf-vdb-postgres.xml
>
>
> Using the attached dynamic vdb, against the database that was created using the attached DDL, produces the following errors:
> ERROR: Element Perf.HISTORY."TIME" of history is neither nullable nor has a default value. A value must be specified in the insert.
> ERROR: Element Perf.HISTORY.FILL of history is neither nullable nor has a default value. A value must be specified in the insert.
> Because of these errors, the VDB isn't deployed.
> Not sure why these are not just WARNINGS.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list