[JBoss JIRA] (TEIID-3624) No way to associate enterprise data types in dynamic vdb constructs
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3624?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3624:
---------------------------------------
For clarity on terms, we have the following types:
* Basic/Builtin - the atomic types known to Designer
* Runtime - similar to builtin, but with the names matching the teiid types for example the integer builtin types means long to Designer
* Builtin - more commonly Teiid has used the term builtin to mean all of the types that …
[View More]designer knows about including types like nmtokens, however additional types are actually marked as type UDT
* UDT - legacy designer defined type extension. Can be referenced via the UDT extension metadata property. Can be extended via enterprise types (but enterprise types are not referable via the UDT property).
* Domain - the new feature to alias a runtime type including properties such as precision, length, and scale.
> No way to associate enterprise data types in dynamic vdb constructs
> -------------------------------------------------------------------
>
> Key: TEIID-3624
> URL: https://issues.jboss.org/browse/TEIID-3624
> Project: Teiid
> Issue Type: Enhancement
> Components: Grammar, Query Engine
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 9.3
>
>
> I don't find any doc's on how to define enterprise data types in a dynamic vdb.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
[View Less]
8 years, 1 month
[JBoss JIRA] (TEIID-4771) The script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4771:
-----------------------------------
Summary: The script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
Key: TEIID-4771
URL: https://issues.jboss.org/browse/TEIID-4771
Project: Teiid
Issue Type: Bug
Components: Build/Kits
Affects Versions: 9.2
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
The script generates GRANT …
[View More]TEMPORARY_TABLE ON DATABASE statements but these fail.
Apparently the script does accept TEMPORARY TABLE (without the underscore). I also had to explicitly state the database name otherwise I get a message "TEIID31231 Database null.{1} not found".
So this doesn't work: GRANT TEMPORARY_TABLE ON DATABASE TO rouser;
But this does work: GRANT TEMPORARY TABLE ON DATABASE vdb TO rouser;
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
[View Less]
8 years, 1 month
[JBoss JIRA] (TEIID-4771) The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIID-4771?page=com.atlassian.jira.plugin... ]
Bram Gadeyne updated TEIID-4771:
--------------------------------
Summary: The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail. (was: The script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.)
> The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
> ---------------------------------------------------------…
[View More]--------------------------------
>
> Key: TEIID-4771
> URL: https://issues.jboss.org/browse/TEIID-4771
> Project: Teiid
> Issue Type: Bug
> Components: Build/Kits
> Affects Versions: 9.2
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
>
> The script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
> Apparently the script does accept TEMPORARY TABLE (without the underscore). I also had to explicitly state the database name otherwise I get a message "TEIID31231 Database null.{1} not found".
> So this doesn't work: GRANT TEMPORARY_TABLE ON DATABASE TO rouser;
> But this does work: GRANT TEMPORARY TABLE ON DATABASE vdb TO rouser;
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
[View Less]
8 years, 1 month