[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-188) Database Schema not used in sql query
[
https://jira.jboss.org/jira/browse/TEIIDDES-188?page=com.atlassian.jira.p...
]
Johnny Verhaeg commented on TEIIDDES-188:
-----------------------------------------
This doesn't sound like a problem to me. We always use just the simple table names
when generating queries for the preview action. Teiid Embedded will automatically expand
these names to be fully-qualified during execution, or more accurately will auto-resolve
and bind these names to the appropriate model entity at runtime. However, maybe a more
important question would be, "Does the preview work?" If not, please let us
know what the results/errors are.
Database Schema not used in sql query
-------------------------------------
Key: TEIIDDES-188
URL: https://jira.jboss.org/jira/browse/TEIIDDES-188
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 6.0.0
Environment: Ubuntu 9.x
eclipse 3.4.2
teiid_designer_6.0.0.v20090427_SNAPSHOT
Postgresql 8.2
postgresql-8.3-604.jdbc4.jar
Reporter: Ben Truitt
Attachments: core_dev_public.xmi
It looks like the database schema specified in the XMI file for the model is not being
used when generating the SQL query to preview data from the model.
I'm attaching my model XMI file. Note the schema is named "rollback".
However, the SQL query generated does not include the schema name, instead it only
includes the table name.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira