[JBoss JIRA] (TEIIDDES-2304) VDB Reuse - View model says it is read only
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2304?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2304:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1131937|https://bugzilla.redhat.com/show_bug.cgi?id=1131937] from MODIFIED to ON_QA
> VDB Reuse - View model says it is read only
> -------------------------------------------
>
> Key: TEIIDDES-2304
> URL: https://issues.jboss.org/browse/TEIIDDES-2304
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 8.3.3
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 8.3.4, 8.6
>
> Attachments: screen1.png, screen2.png
>
>
> I am working on a test script for Data roles and I am also testing Data roles with VDB Reuse.
> I connected to VDB using the process described in section 10.6 in [1]
> This process creates a source model.
> Then I created view model using transformation from this source model.
> Now, when I try to copy some procedure to this view model everthing works, but when I try to delete this coppied procedure JBDS gives me an error warning that this model is READ ONLY. I shouldn't be read only, should it?
> BUT, when I try to cut this procedure from the model (Ctrl + X) everything works, without error warnings. Also in the properties of this model isn't the checkbox for "read only" checked.
> [1] http://docs.jboss.org/teiid/designer/8.3/user-guide/en-US/html_single/
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
9 years, 5 months
[JBoss JIRA] (TEIIDDES-2316) Excel import creates wrong datatype for ROW_ID column
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2316?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2316:
---------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1134006|https://bugzilla.redhat.com/show_bug.cgi?id=1134006] from MODIFIED to ON_QA
> 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
> 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
> Fix For: 8.6
>
>
> 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.8#6338)
9 years, 5 months