[JBoss JIRA] (TEIIDDES-2306) Unable to change constant data type in Expression Builder
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2306?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2306:
----------------------------------------
I set up a virtual table with a ROW_ID column of type *int*
Verified in the T-Editor that *'12345' AS ROW_ID* is valid as is *12345 AS ROW_ID* as is *12345.999 AS ROW_ID*
In the first instance, the ROW_ID would be expected to be a *string*, in the second, ROW_ID datatype is an *integer*, and the third the runtime datatype is *bigdecimal*. In the first and third instances, the SQL validation resulted in unresolved/mismatched datatypes.
So it appears that the Expression builder isn't accounting for that flexibility. Not sure what other datatypes would be supported by SQL. Is it just *integer, bigdecimal and string*?
Not sure how we address this....
> Unable to change constant data type in Expression Builder
> ---------------------------------------------------------
>
> Key: TEIIDDES-2306
> URL: https://issues.jboss.org/browse/TEIIDDES-2306
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.3.3
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 8.7
>
>
> In Expression Builder, if the Constant radio button is selected, changing Type from the dropdown has no effect (on Windows, the newly selected type flashes briefly in the dropdown before reverting back to 'string').
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2335) Profile and analyze for memory leaks
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2335:
--------------------------------------
Summary: Profile and analyze for memory leaks
Key: TEIIDDES-2335
URL: https://issues.jboss.org/browse/TEIIDDES-2335
Project: Teiid Designer
Issue Type: Task
Components: Usability
Affects Versions: 8.6
Reporter: Barry LaFond
Assignee: Paul Richardson
Fix For: 8.6.1
Been quite some time since we did a memory analysis/check of Teiid Designer.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2161) Merge various fixes from master into 8.3.4
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2161?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2161:
-----------------------------------
Description:
*Candidates*
* NONE
*Completed Upstream*
* NONE
*Merged*
* TEIIDDES-1998 Connection Profile loses Binding Type
* TEIIDDES-2017 NPE while using Teiid Connection Importer
* TEIIDDES-2018 DDL importer creates wrong data type for "integer"
* TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
* TEIIDDES-2111 NPE trying to Preview Data (partial merge)
* TEIIDDES-2131 With Teiid Designer, user can't set "System Table Access" for "VDB Data Role" with a small display
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project
* TEIIDDES-2139 2 Connections to same VDB in JBDS seem to share one password
* TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
* TEIIDDES-2151 Create relational model from WS (SOAP) using default procedures generates both models in one subdirectory
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override ( partial related commit)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions (*Already commited in 8.3.3 release*)
* TEIIDDES-2164 Editing teiid importer connection url can't be finished
* TEIIDDES-2170 Add VDB Version text entry to VDB Editor
* TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
* TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
* TEIIDDES-2191 Create VDB Data Source Menu Item not i18n
* TEIIDDES-2192 VDB Context Menu in server view should have an option for creating vdb data source
* TEIIDDES-2196 Data Roles dialog issues (addresses TEIIDDES-2261)
* TEIIDDES-2205 Remove table name error validation for names that include '.' delimiter (related to TEIIDDES-2100)
* TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
* TEIIDDES-2221 Deleted XSD schema from VDB can't be added back
* TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
* TEIIDDES-2260 Teiid Designer doesn't clean up vdb.xml properly (Data Roles - conditions)
* TEIIDDES-2266 Unexpected internal error near index 1 on Windows
* TEIIDDES-2267 JNDI Name selection on VDB Explorer does not function on Windows
* TEIIDDES-2274 Row-based Security creates incorrect permission
* TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
* TEIIDDES-2139 - 2 Connections to same VDB in JBDS seem to share one password
* TEIIDDES-2237 - Server credentials for multiple Teiid instances sharing password
* [91fc48c8|https://github.com/Teiid-Designer/teiid-designer/commit/91fc48c8...] - Miscellaneous fixes found while debugging TEIIDDES-2139 and TEIIDDES-2237
* [35a73da0|https://github.com/Teiid-Designer/teiid-designer/commit/35a73da0...] - Removes debug messages erroneously added by TEIIDDES-2139
* TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
* TEIIDDES-2291 (Windows only) New VDB datarole checkboxes problems
* TEIIDDES-2295 Issues with table viewer selection and editing on Windows (various jiras) (TEIIDDES-2276, TEIIDDES-2293, TEIIDDES-2294, TEIIDDES-2309, TEIIDDES-2302)
* TEIIDDES-2298 Wrong message in LDAP import dialog
* TEIIDDES-2304 VDB Reuse - View model says it is read only
* TEIIDDES-2314 VDB editor in TD 8.6 allows user to add source model from reused VDB
* TEIIDDES-2320 Creating masking on column using "Security" column in Edit VDB Data Role dialogue doesn't work
* TEIIDDES-2330 Unhandled event loop exception when creating Relational View Procedure
was:
*Candidates*
* NONE
*Completed Upstream*
* NONE
*Merged*
* TEIIDDES-2017 NPE while using Teiid Connection Importer
* TEIIDDES-2018 DDL importer creates wrong data type for "integer"
* TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
* TEIIDDES-2111 NPE trying to Preview Data (partial merge)
* TEIIDDES-2131 With Teiid Designer, user can't set "System Table Access" for "VDB Data Role" with a small display
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project
* TEIIDDES-2139 2 Connections to same VDB in JBDS seem to share one password
* TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
* TEIIDDES-2151 Create relational model from WS (SOAP) using default procedures generates both models in one subdirectory
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override ( partial related commit)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions (*Already commited in 8.3.3 release*)
* TEIIDDES-2164 Editing teiid importer connection url can't be finished
* TEIIDDES-2170 Add VDB Version text entry to VDB Editor
* TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
* TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
* TEIIDDES-2191 Create VDB Data Source Menu Item not i18n
* TEIIDDES-2192 VDB Context Menu in server view should have an option for creating vdb data source
* TEIIDDES-2196 Data Roles dialog issues (addresses TEIIDDES-2261)
* TEIIDDES-2205 Remove table name error validation for names that include '.' delimiter (related to TEIIDDES-2100)
* TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
* TEIIDDES-2221 Deleted XSD schema from VDB can't be added back
* TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
* TEIIDDES-2260 Teiid Designer doesn't clean up vdb.xml properly (Data Roles - conditions)
* TEIIDDES-2266 Unexpected internal error near index 1 on Windows
* TEIIDDES-2267 JNDI Name selection on VDB Explorer does not function on Windows
* TEIIDDES-2274 Row-based Security creates incorrect permission
* TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
* TEIIDDES-2139 - 2 Connections to same VDB in JBDS seem to share one password
* TEIIDDES-2237 - Server credentials for multiple Teiid instances sharing password
* [91fc48c8|https://github.com/Teiid-Designer/teiid-designer/commit/91fc48c8...] - Miscellaneous fixes found while debugging TEIIDDES-2139 and TEIIDDES-2237
* [35a73da0|https://github.com/Teiid-Designer/teiid-designer/commit/35a73da0...] - Removes debug messages erroneously added by TEIIDDES-2139
* TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
* TEIIDDES-2291 (Windows only) New VDB datarole checkboxes problems
* TEIIDDES-2295 Issues with table viewer selection and editing on Windows (various jiras) (TEIIDDES-2276, TEIIDDES-2293, TEIIDDES-2294, TEIIDDES-2309, TEIIDDES-2302)
* TEIIDDES-2298 Wrong message in LDAP import dialog
* TEIIDDES-2304 VDB Reuse - View model says it is read only
* TEIIDDES-2314 VDB editor in TD 8.6 allows user to add source model from reused VDB
* TEIIDDES-2320 Creating masking on column using "Security" column in Edit VDB Data Role dialogue doesn't work
* TEIIDDES-2330 Unhandled event loop exception when creating Relational View Procedure
> Merge various fixes from master into 8.3.4
> ------------------------------------------
>
> Key: TEIIDDES-2161
> URL: https://issues.jboss.org/browse/TEIIDDES-2161
> Project: Teiid Designer
> Issue Type: Task
> Components: Patch Release
> Reporter: Barry LaFond
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.3.4
>
>
> *Candidates*
> * NONE
> *Completed Upstream*
> * NONE
> *Merged*
> * TEIIDDES-1998 Connection Profile loses Binding Type
> * TEIIDDES-2017 NPE while using Teiid Connection Importer
> * TEIIDDES-2018 DDL importer creates wrong data type for "integer"
> * TEIIDDES-2089 Teiid connection import throws "java.lang.IllegalArgumentException: The supplied model folder refers to an existing non-model project" on Windows
> * TEIIDDES-2111 NPE trying to Preview Data (partial merge)
> * TEIIDDES-2131 With Teiid Designer, user can't set "System Table Access" for "VDB Data Role" with a small display
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project
> * TEIIDDES-2139 2 Connections to same VDB in JBDS seem to share one password
> * TEIIDDES-2142 & TEIIDDES-2131 New VDB Data Role' Dialog needs layout improvement
> * TEIIDDES-2151 Create relational model from WS (SOAP) using default procedures generates both models in one subdirectory
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override ( partial related commit)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions (*Already commited in 8.3.3 release*)
> * TEIIDDES-2164 Editing teiid importer connection url can't be finished
> * TEIIDDES-2170 Add VDB Version text entry to VDB Editor
> * TEIIDDES-2186 SWT Illegal Argument exception from Teiid Server Editor page
> * TEIIDDES-2189 Add ModelType validation in the New MED wizard to prevent creating MED without one selected
> * TEIIDDES-2191 Create VDB Data Source Menu Item not i18n
> * TEIIDDES-2192 VDB Context Menu in server view should have an option for creating vdb data source
> * TEIIDDES-2196 Data Roles dialog issues (addresses TEIIDDES-2261)
> * TEIIDDES-2205 Remove table name error validation for names that include '.' delimiter (related to TEIIDDES-2100)
> * TEIIDDES-2214 Cannot generate CXF WAR from VDB created in 8.3.3
> * TEIIDDES-2221 Deleted XSD schema from VDB can't be added back
> * TEIIDDES-2244 Exception in TeiidServerVersion parsing "8.4.1-redhat-7"
> * TEIIDDES-2260 Teiid Designer doesn't clean up vdb.xml properly (Data Roles - conditions)
> * TEIIDDES-2266 Unexpected internal error near index 1 on Windows
> * TEIIDDES-2267 JNDI Name selection on VDB Explorer does not function on Windows
> * TEIIDDES-2274 Row-based Security creates incorrect permission
> * TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
> * TEIIDDES-2139 - 2 Connections to same VDB in JBDS seem to share one password
> * TEIIDDES-2237 - Server credentials for multiple Teiid instances sharing password
> * [91fc48c8|https://github.com/Teiid-Designer/teiid-designer/commit/91fc48c8...] - Miscellaneous fixes found while debugging TEIIDDES-2139 and TEIIDDES-2237
> * [35a73da0|https://github.com/Teiid-Designer/teiid-designer/commit/35a73da0...] - Removes debug messages erroneously added by TEIIDDES-2139
> * TEIIDDES-2275 Invalid Model Name, when trying to use Teiid Connection Importer
> * TEIIDDES-2291 (Windows only) New VDB datarole checkboxes problems
> * TEIIDDES-2295 Issues with table viewer selection and editing on Windows (various jiras) (TEIIDDES-2276, TEIIDDES-2293, TEIIDDES-2294, TEIIDDES-2309, TEIIDDES-2302)
> * TEIIDDES-2298 Wrong message in LDAP import dialog
> * TEIIDDES-2304 VDB Reuse - View model says it is read only
> * TEIIDDES-2314 VDB editor in TD 8.6 allows user to add source model from reused VDB
> * TEIIDDES-2320 Creating masking on column using "Security" column in Edit VDB Data Role dialogue doesn't work
> * TEIIDDES-2330 Unhandled event loop exception when creating Relational View Procedure
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months