[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 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)
7 years, 10 months
[JBoss JIRA] (TEIID-4771) The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4771?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4771:
----------------------------------
Fix Version/s: 9.3
9.2.1
> The convert 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
> Fix For: 9.3, 9.2.1
>
>
> 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)
7 years, 10 months
[JBoss JIRA] (TEIID-4772) incorrect metadata for array columns in pg metadata
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4772:
-------------------------------------
Summary: incorrect metadata for array columns in pg metadata
Key: TEIID-4772
URL: https://issues.jboss.org/browse/TEIID-4772
Project: Teiid
Issue Type: Bug
Components: ODBC
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.3
The array columns are not correctly defined - they are setting a type and then a separate runtime type. We should just be using the array type name from the start.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[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 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)
7 years, 10 months
[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.
> -----------------------------------------------------------------------------------------
>
> 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)
7 years, 10 months
[JBoss JIRA] (TEIID-4770) The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4770:
-----------------------------------
Summary: The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
Key: TEIID-4770
URL: https://issues.jboss.org/browse/TEIID-4770
Project: Teiid
Issue Type: Enhancement
Components: Build/Kits
Affects Versions: 9.2
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
E.g. GRANT ON SCHEMA glims TO mica;
When you try to deploy the script, the server complains that it expects a permission type (like select or alter) here.
These lines should probably be removed.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months
[JBoss JIRA] (TEIID-4398) Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-4398?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-4398:
-------------------------------------
Yes, that was a limitation. I need to take another look at relaxing that limitation.
> Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format
> -----------------------------------------------------------------------------
>
> Key: TEIID-4398
> URL: https://issues.jboss.org/browse/TEIID-4398
> Project: Teiid
> Issue Type: Task
> Components: Build/Kits
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Fix For: 9.2
>
> Attachments: teiid-convert-vdb.bat, teiid-convert-vdb.sh
>
>
> Write a command line utility and provide in "bin" directory to convert the Designer based .vdb file with index metadata into -vdb.xml file and/or newer DDL format.
> This can be used to migrate the older VDBs mach easier to newer formats without use of Designer tooling.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 10 months