[JBoss JIRA] Created: (TEIIDDES-518) DTP context menu options on Teiid tables should consider whether virtual model supports update.
by Ken Johnson (JIRA)
DTP context menu options on Teiid tables should consider whether virtual model supports update.
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-518
URL: https://jira.jboss.org/browse/TEIIDDES-518
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 7.0
Environment: Teiid Designer 7.0 + JBoss Dev Studio 3.0.1GA
Teiid 7.1 Alpha on EAP 5.1
RHEL 6, OpenJDK 1.6
Reporter: Ken Johnson
In DTP, Context menu for Table contains several options under Data->(Edit, Load, Extract, Sample Contents). For virtual tables, Extract and Sample Contents are fine. Edit and Load will attempt to write data. Thus a few issues:
a) These options should be disabled if the table in question does not have Supports Update checked.
b) These options should be tested when the table *does* have Update and Insert procedures defined.
c) Tables in SYS schema should never be writable.
When working with physical tables, all options should be available and work correctly. Cursory testing indicates this is the case - at least with a MySQL data source underlying the model.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months
[JBoss JIRA] Created: (TEIIDDES-210) Add implicit conversion of NULL to correct datatype in transformation validator
by Marc Shirley (JIRA)
Add implicit conversion of NULL to correct datatype in transformation validator
-------------------------------------------------------------------------------
Key: TEIIDDES-210
URL: https://jira.jboss.org/jira/browse/TEIIDDES-210
Project: Teiid Designer
Issue Type: Feature Request
Components: Transformations, Validation
Affects Versions: 6.0.0, 6.1.0
Reporter: Marc Shirley
When using NULL value as a column (ie, NULL as columnName), it is only implicitly converted to a string. When trying to use the NULL as a column of type date, integer, float, etc., the validator throws a warning that the transformation is not valid. If you wrap the NULL in a convert to the correct column datatype (ie, "convert(NULL,date)"), the transformation can be validated successfully.
--
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
13 years, 9 months
[JBoss JIRA] Created: (TEIIDDES-570) Valid names can have almost any character, except periods. No periods!
by Paul Nittel (JIRA)
Valid names can have almost any character, except periods. No periods!
----------------------------------------------------------------------
Key: TEIIDDES-570
URL: https://jira.jboss.org/browse/TEIIDDES-570
Project: Teiid Designer
Issue Type: Bug
Components: Validation
Affects Versions: 7.1
Environment: All
Reporter: Paul Nittel
This SQL:
SELECT t.* FROM
(EXEC WeatherData.invoke(action = 'GET', endpoint = QUERYSTRING('', '38.99,-77.02 39.70,-104.80 47.6,-122.30' AS listLatLon, 'time-series' AS product, '2004-01-01T00:00:00' AS "begin", '2013-04-20T00:00:00' AS "end", 'maxt' AS maxt, 'mint' AS mint))) AS w, XMLTABLE('/dwml/data/location' PASSING result COLUMNS "location-key" string, lattitude string PATH 'point/@latitude', longitude string PATH 'point/@longitude') AS t
will fail as location-key contains a hyphen. Actually, the only character which is not valid in a name is the period. Please verify with the Teiid server crew, but we should loosen up the validation criteria as appropriate.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 10 months