[teiid-issues] [JBoss JIRA] (TEIID-2827) Not sure why Teiid is creating errors based on the database metadata

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12939807#comment-12939807 ] 

Steven Hawkins commented on TEIID-2827:
---------------------------------------

You are inserting into a table with 6 columns but only providing 4 values.  It is valid for us to complain about this as the missing columns are not nullable nor have a default.  So I think your chief complaint here may be that there wasn't enough context to the error.
                
> 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