[JBoss JIRA] (TEIIDDES-2256) Confusing data type "integer" and "int"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2256?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2256:
--------------------------------------
Assignee: Barry LaFond (was: Paul Richardson)
> Confusing data type "integer" and "int"
> ---------------------------------------
>
> Key: TEIIDDES-2256
> URL: https://issues.jboss.org/browse/TEIIDDES-2256
> Project: Teiid Designer
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.6
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Fix For: 8.6
>
> Attachments: builtin-types.xsd, full-datatypes-1.png, full-datatypes-2.png, set-datatype-dialog.png, set-datatype-dialog_3.png
>
>
> I understand that
> "integer" maps to "xs:biginteger"
> "int" maps "xs:long"
> How they are confusing when there is already one available for biginteger. Also the Table creation wizard does not provide option to to select "int". When user chooses "integer" it often is "int".
> This confusion needs to be resolved. IMO "integer" can be removed, however I am not sure how it effects data type system
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2256) Confusing data type "integer" and "int"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2256?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2256:
-----------------------------------
Fix Version/s: 8.6
(was: 8.7)
(was: 8.6.1)
> Confusing data type "integer" and "int"
> ---------------------------------------
>
> Key: TEIIDDES-2256
> URL: https://issues.jboss.org/browse/TEIIDDES-2256
> Project: Teiid Designer
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.6
> Reporter: Ramesh Reddy
> Assignee: Paul Richardson
> Fix For: 8.6
>
> Attachments: builtin-types.xsd, full-datatypes-1.png, full-datatypes-2.png, set-datatype-dialog.png, set-datatype-dialog_3.png
>
>
> I understand that
> "integer" maps to "xs:biginteger"
> "int" maps "xs:long"
> How they are confusing when there is already one available for biginteger. Also the Table creation wizard does not provide option to to select "int". When user chooses "integer" it often is "int".
> This confusion needs to be resolved. IMO "integer" can be removed, however I am not sure how it effects data type system
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2256) Confusing data type "integer" and "int"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2256?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2256:
-----------------------------------
Attachment: set-datatype-dialog_3.png
> Confusing data type "integer" and "int"
> ---------------------------------------
>
> Key: TEIIDDES-2256
> URL: https://issues.jboss.org/browse/TEIIDDES-2256
> Project: Teiid Designer
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.6
> Reporter: Ramesh Reddy
> Assignee: Paul Richardson
> Fix For: 8.7, 8.6.1
>
> Attachments: builtin-types.xsd, full-datatypes-1.png, full-datatypes-2.png, set-datatype-dialog.png, set-datatype-dialog_3.png
>
>
> I understand that
> "integer" maps to "xs:biginteger"
> "int" maps "xs:long"
> How they are confusing when there is already one available for biginteger. Also the Table creation wizard does not provide option to to select "int". When user chooses "integer" it often is "int".
> This confusion needs to be resolved. IMO "integer" can be removed, however I am not sure how it effects data type system
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2256) Confusing data type "integer" and "int"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2256?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2256:
-----------------------------------
Attachment: (was: set-datatype-dialog_2.png)
> Confusing data type "integer" and "int"
> ---------------------------------------
>
> Key: TEIIDDES-2256
> URL: https://issues.jboss.org/browse/TEIIDDES-2256
> Project: Teiid Designer
> Issue Type: Enhancement
> Security Level: Public(Everyone can see)
> Components: Import/Export
> Affects Versions: 8.6
> Reporter: Ramesh Reddy
> Assignee: Paul Richardson
> Fix For: 8.7, 8.6.1
>
> Attachments: builtin-types.xsd, full-datatypes-1.png, full-datatypes-2.png, set-datatype-dialog.png
>
>
> I understand that
> "integer" maps to "xs:biginteger"
> "int" maps "xs:long"
> How they are confusing when there is already one available for biginteger. Also the Table creation wizard does not provide option to to select "int". When user chooses "integer" it often is "int".
> This confusion needs to be resolved. IMO "integer" can be removed, however I am not sure how it effects data type system
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2316) Excel import creates wrong datatype for ROW_ID column
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2316?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2316:
--------------------------------------
Assignee: Barry LaFond
> Excel import creates wrong datatype for ROW_ID column
> -----------------------------------------------------
>
> Key: TEIIDDES-2316
> URL: https://issues.jboss.org/browse/TEIIDDES-2316
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Import/Export, Modeling, Teiid Integration
> Affects Versions: 8.6
> Environment: Teiid Designer 8.6.0.Alpha1
> Teiid 8.7.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
>
> Following https://community.jboss.org/wiki/MicrosoftExcelDocumentIntoRelationalTable (Option 1 using Teiid Designer), the imported model has the ROW_ID column modeled with datatype "integer", which results in BigInteger runtime datatype. After adding this model to a vdb and deploying, the following queries work ok:
> {code:sql}
> SELECT * FROM Sheet1
> SELECT * FROM Sheet1 WHERE row_id > 2
> {code}
> but the following query fails:
> {code:sql}
> SELECT * FROM Sheet1 WHERE row_id = 2
> {code}
> The error is
> bq. org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: java.math.BigInteger cannot be cast to java.lang.Integer
> After changing the datatype to "int : xs:long" and redeploying, the above query works as expected.
> However, if I copy the generated dynamic vdb (attached) and deploy it on the server (without using Designer), running the query against that works.
> The DDL for import is
> {code:sql}
> SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel;
> CREATE FOREIGN TABLE Sheet1 (
> ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'),
> FirstName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'),
> LastName string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'),
> Age double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'),
> CONSTRAINT PK0 PRIMARY KEY(ROW_ID)
> ) OPTIONS ("teiid_excel:FILE" 'names.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2');
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2331) Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2331?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2331:
-----------------------------------
Assignee: Mark Drilling
> Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2331
> URL: https://issues.jboss.org/browse/TEIIDDES-2331
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.4, 8.6
> Environment: Windows 7
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 8.7, 8.3.5
>
> Attachments: Dataroles_project.zip, log.log, screenshot1.png, screenshot2.png, screenshot3.png, screenshot4.png, screenshot5.png
>
>
> There is couple of issues with renaming source model that is referenced in some view model.
> I am using project Dataroles_project.zip (attached)
> 1. I tried to rename Products_source.xmi to Products_source1.xmi
> * this generates some error in log but it works...
> *[screenshot1.png]
> 2. Rename Products_source1.xmi to Products_source2.xmi
> * this fails to rewrite the reference in view model
> * I changed the references manually
> *[screenshot2.png and screenshot3.png]
> 3. Remane Products_source2.xmi to Products_source3.xmi
> * this deletes tables from view model
> *[screenshot4.png and screenshot5.png]
> This problem occurs only on Windows, Linux is fine...
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2331) Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2331?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2331:
-----------------------------------
Fix Version/s: 8.7
8.3.5
> Issues with renaming Source Model (8.3.4.CR1 and 8.6.0 + Windows 7)
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2331
> URL: https://issues.jboss.org/browse/TEIIDDES-2331
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.4, 8.6
> Environment: Windows 7
> Reporter: Matus Makovy
> Fix For: 8.7, 8.3.5
>
> Attachments: Dataroles_project.zip, log.log, screenshot1.png, screenshot2.png, screenshot3.png, screenshot4.png, screenshot5.png
>
>
> There is couple of issues with renaming source model that is referenced in some view model.
> I am using project Dataroles_project.zip (attached)
> 1. I tried to rename Products_source.xmi to Products_source1.xmi
> * this generates some error in log but it works...
> *[screenshot1.png]
> 2. Rename Products_source1.xmi to Products_source2.xmi
> * this fails to rewrite the reference in view model
> * I changed the references manually
> *[screenshot2.png and screenshot3.png]
> 3. Remane Products_source2.xmi to Products_source3.xmi
> * this deletes tables from view model
> *[screenshot4.png and screenshot5.png]
> This problem occurs only on Windows, Linux is fine...
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2278) Starting server in JBDS(TD) gets stuck on "Performing pre-launch check" (Win 8.1)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2278?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2278:
-----------------------------------
Assignee: Mark Drilling (was: Barry LaFond)
> Starting server in JBDS(TD) gets stuck on "Performing pre-launch check" (Win 8.1)
> ---------------------------------------------------------------------------------
>
> Key: TEIIDDES-2278
> URL: https://issues.jboss.org/browse/TEIIDDES-2278
> Project: Teiid Designer
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Affects Versions: 8.3.3
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Attachments: JBDS.log, screen.png, server.log
>
>
> When I try to start server in JBDS, it gets stuck on "Performing pre-launch check..."
> Not all translators are loaded (for example, translator "ws") so I can not use some VDBs.
> I tried to completely reinstall DV and also JBDS + Teiid Designer, it didn't help.
> WINDOWS 8.1
> JBDS 7.1.1.GA
> Teiid Designer 8.3.3.Final-v20140613-1202-B88
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months