[JBoss JIRA] (TEIID-4415) OData4 contains(columnname, 'value') eq true filter fails
by J Price (JIRA)
J Price created TEIID-4415:
------------------------------
Summary: OData4 contains(columnname,'value') eq true filter fails
Key: TEIID-4415
URL: https://issues.jboss.org/browse/TEIID-4415
Project: Teiid
Issue Type: Bug
Components: OData
Affects Versions: 9.0.2
Environment: WildFly 10
Teiid 9.0.2
Reporter: J Price
Assignee: Steven Hawkins
I am receiving the following error message when using a contains filter on an odata4 endpoint:
<error><code>null</code><message>TEIID31100 Parsing error: Encountered ") >= 1 [*]=[*] CONVERT(" at line 1, column 247.
Was expecting: "and" | "or" | "," | ")" | "*" | "/" | "+" | "-" | "||" | "&&" ...</message></error>
The URI to reproduce this is as folows:
/odata4/Sandbox.1/Compatibility/USERLIST?$top=6&$filter=contains(FIRSTNAME,'peter') eq true and contains(LASTNAME,'peter') eq false
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-4021) MSSQL Pagination
by Mark Tawk (JIRA)
[ https://issues.jboss.org/browse/TEIID-4021?page=com.atlassian.jira.plugin... ]
Mark Tawk edited comment on TEIID-4021 at 8/25/16 10:39 AM:
------------------------------------------------------------
I have implemented the fix, it works perfectly with SQL Server 2012.
But with SQL Server 2008 and 2005, i'm getting an exception whenever i use pagination in Teiid query.
org.teiid.jdbc.TeiidSQLException: TEIID30504 implify_dataModel_YfVDB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."DbTRX20112015LRed1006_Amoun" AS c_0, g_0."DbTRX20112015LRed1006_Creat" AS c_1, g_0."DbTRX20112015LRed1006_Lastt" AS c_2, g_0."DbTRX20112015LRed1006_RIM" AS c_3, g_0."DbTRX20112015LRed1006_TRX20" AS c_4, g_0."ID" AS c_5 FROM "implify_data"."dbo"."DbTRX20112015LRed1006" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY]
Here is the query plan:
<?xml version='1.0' encoding='UTF-8'?><node name="AccessNode"><property name="Relational Node ID"><value>0</value></property><property name="Output Columns"><value>DbTRX20112015LRed1006_DbTRX2 (double)</value><value>DbTRX20112015LRed1006_DbTRX21 (timestamp)</value><value>DbTRX20112015LRed1006_DbTRX22 (timestamp)</value><value>DbTRX20112015LRed1006_DbTRX23 (integer)</value><value>DbTRX20112015LRed1006_DbTRX24 (integer)</value><value>DbTRX20112015LRed1006_ID (integer)</value></property><property name="Statistics"><value>Node Output Rows: 0</value><value>Node Next Batch Process Time: 0</value><value>Node Cumulative Next Batch Process Time: 16</value><value>Node Cumulative Process Time: 0</value><value>Node Next Batch Calls: 1</value><value>Node Blocks: 1</value></property><property name="Cost Estimates"><value>Estimated Node Cardinality: 10.0</value></property><property name="Query"><value>SELECT g_0.DbTRX20112015LRed1006_Amoun AS c_0, g_0.DbTRX20112015LRed1006_Creat AS c_1, g_0.DbTRX20112015LRed1006_Lastt AS c_2, g_0.DbTRX20112015LRed1006_RIM AS c_3, g_0.DbTRX20112015LRed1006_TRX20 AS c_4, g_0.ID AS c_5 FROM implify_dataModel_Yf.implify_data.dbo.DbTRX20112015LRed1006 AS g_0 LIMIT 10</value></property><property name="Model Name"><value>implify_dataModel_Yf</value></property><property name="Data Bytes Sent"><value>0</value></property><property name="Planning Time"><value>0</value></property></node>
was (Author: mtawk):
I have implemented the fix, it works perfectly with SQL Server 2012.
But with SQL Server 2008 and 2005, i'm getting an exception whenever i use pagination in Teiid query.
org.teiid.jdbc.TeiidSQLException: TEIID30504 implify_dataModel_YfVDB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."DbTRX20112015LRed1006_Amoun" AS c_0, g_0."DbTRX20112015LRed1006_Creat" AS c_1, g_0."DbTRX20112015LRed1006_Lastt" AS c_2, g_0."DbTRX20112015LRed1006_RIM" AS c_3, g_0."DbTRX20112015LRed1006_TRX20" AS c_4, g_0."ID" AS c_5 FROM "implify_data"."dbo"."DbTRX20112015LRed1006" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY]
> MSSQL Pagination
> ----------------
>
> Key: TEIID-4021
> URL: https://issues.jboss.org/browse/TEIID-4021
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1
>
>
> I'm using Teiid 8.11.3 with mssql translator.
> I have a huge table over sql server 2008 on which i'm applying pagination.
> I noticed slowliness in the query execution over this table at each time I increase the pagination.
> I monitored the JDBC queries execute by teiid and found out that it is using top n according to the limit used into the query.
> For example:
> in teiid : Select * from mytable LIMIT 90 , 10
> is translated in JDBC: select top 100 from mytable
> Since my table contains millions of records, when fetching the last page, the executed jdbc query is retrieving the whole table top n, to return in result the last 10 records. And the execution is taking too much time.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-4021) MSSQL Pagination
by Mark Tawk (JIRA)
[ https://issues.jboss.org/browse/TEIID-4021?page=com.atlassian.jira.plugin... ]
Mark Tawk commented on TEIID-4021:
----------------------------------
I have implemented the fix, it works perfectly with SQL Server 2012.
But with SQL Server 2008 and 2005, i'm getting an exception whenever i use pagination in Teiid query.
org.teiid.jdbc.TeiidSQLException: TEIID30504 implify_dataModel_YfVDB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."DbTRX20112015LRed1006_Amoun" AS c_0, g_0."DbTRX20112015LRed1006_Creat" AS c_1, g_0."DbTRX20112015LRed1006_Lastt" AS c_2, g_0."DbTRX20112015LRed1006_RIM" AS c_3, g_0."DbTRX20112015LRed1006_TRX20" AS c_4, g_0."ID" AS c_5 FROM "implify_data"."dbo"."DbTRX20112015LRed1006" g_0 ORDER BY @@version OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY]
> MSSQL Pagination
> ----------------
>
> Key: TEIID-4021
> URL: https://issues.jboss.org/browse/TEIID-4021
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1
>
>
> I'm using Teiid 8.11.3 with mssql translator.
> I have a huge table over sql server 2008 on which i'm applying pagination.
> I noticed slowliness in the query execution over this table at each time I increase the pagination.
> I monitored the JDBC queries execute by teiid and found out that it is using top n according to the limit used into the query.
> For example:
> in teiid : Select * from mytable LIMIT 90 , 10
> is translated in JDBC: select top 100 from mytable
> Since my table contains millions of records, when fetching the last page, the executed jdbc query is retrieving the whole table top n, to return in result the last 10 records. And the execution is taking too much time.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-4414) VDB with old version is removed from the repository
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4414?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4414.
-----------------------------------
Resolution: Rejected
The same EAP deployment name is being used for both versions. A unique deployment name is needed.
> VDB with old version is removed from the repository
> ---------------------------------------------------
>
> Key: TEIID-4414
> URL: https://issues.jboss.org/browse/TEIID-4414
> Project: Teiid
> Issue Type: Bug
> Environment: Fedora 23
> Reporter: Matej Kralik
>
> When I deploy the second version of VDB, first version which is on the server will be undeployed.
> In my opinion, on the server should be both VDB.
> Server log when I deploy the second version of VDB:
> 10:36:29,763 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014900: Content added at location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/f7/642a972e99109eb02cf552cff4bfd06f179724/content
> 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository
> 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40119 VDB DatarolesVDB.1 removed from the repository
> 10:36:29,766 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50026 VDB "DatarolesVDB.1[Products_view{}, Products_source{Products_source=Products_source, oracle, Products_source}]" undeployed.
> 10:36:29,767 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository
> 10:36:29,769 INFO [org.jboss.as.server.deployment] (MSC service thread 1-12) JBAS015877: Stopped deployment DatarolesVDB.vdb (runtime-name: DatarolesVDB.vdb) in 5ms
> 10:36:29,770 INFO [org.jboss.as.server.deployment] (MSC service thread 1-13) JBAS015876: Starting deployment of "DatarolesVDB.vdb" (runtime-name: "DatarolesVDB.vdb")
> 10:36:29,785 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40118 VDB DatarolesVDB.2 added to the repository
> 10:36:29,785 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_view" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM
> 10:36:29,786 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_source" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM
> 10:36:29,791 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB DatarolesVDB.2 model "Products_source" metadata loaded. End Time: 5/30/16 10:36 AM
> 10:36:29,792 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB DatarolesVDB.2 model "Products_view" metadata loaded. End Time: 5/30/16 10:36 AM
> 10:36:29,810 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1) TEIID40003 VDB DatarolesVDB.2 is set to ACTIVE
> 10:36:29,827 INFO [org.jboss.as.server] (management-handler-thread - 11) JBAS015865: Replaced deployment "DatarolesVDB.vdb" with deployment "DatarolesVDB.vdb"
> 10:36:29,827 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014901: Content removed from location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/b0/7f37d82389f48b61922095c3d118870fda6116/content
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-4414) VDB with old version is removed from the repository
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIID-4414?page=com.atlassian.jira.plugin... ]
Barry LaFond moved TEIIDDES-2848 to TEIID-4414:
-----------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-4414 (was: TEIIDDES-2848)
Component/s: (was: VDB & Execution)
Affects Version/s: (was: 10.0)
> VDB with old version is removed from the repository
> ---------------------------------------------------
>
> Key: TEIID-4414
> URL: https://issues.jboss.org/browse/TEIID-4414
> Project: Teiid
> Issue Type: Bug
> Environment: Fedora 23
> Reporter: Matej Kralik
>
> When I deploy the second version of VDB, first version which is on the server will be undeployed.
> In my opinion, on the server should be both VDB.
> Server log when I deploy the second version of VDB:
> 10:36:29,763 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014900: Content added at location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/f7/642a972e99109eb02cf552cff4bfd06f179724/content
> 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository
> 10:36:29,765 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40119 VDB DatarolesVDB.1 removed from the repository
> 10:36:29,766 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50026 VDB "DatarolesVDB.1[Products_view{}, Products_source{Products_source=Products_source, oracle, Products_source}]" undeployed.
> 10:36:29,767 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-3) TEIID40120 VDB DatarolesVDB.1 will be removed from the repository
> 10:36:29,769 INFO [org.jboss.as.server.deployment] (MSC service thread 1-12) JBAS015877: Stopped deployment DatarolesVDB.vdb (runtime-name: DatarolesVDB.vdb) in 5ms
> 10:36:29,770 INFO [org.jboss.as.server.deployment] (MSC service thread 1-13) JBAS015876: Starting deployment of "DatarolesVDB.vdb" (runtime-name: "DatarolesVDB.vdb")
> 10:36:29,785 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-15) TEIID40118 VDB DatarolesVDB.2 added to the repository
> 10:36:29,785 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_view" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM
> 10:36:29,786 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB DatarolesVDB.2 model "Products_source" metadata is currently being loaded. Start Time: 5/30/16 10:36 AM
> 10:36:29,791 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB DatarolesVDB.2 model "Products_source" metadata loaded. End Time: 5/30/16 10:36 AM
> 10:36:29,792 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB DatarolesVDB.2 model "Products_view" metadata loaded. End Time: 5/30/16 10:36 AM
> 10:36:29,810 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1) TEIID40003 VDB DatarolesVDB.2 is set to ACTIVE
> 10:36:29,827 INFO [org.jboss.as.server] (management-handler-thread - 11) JBAS015865: Replaced deployment "DatarolesVDB.vdb" with deployment "DatarolesVDB.vdb"
> 10:36:29,827 INFO [org.jboss.as.repository] (management-handler-thread - 11) JBAS014901: Content removed from location /home/mkralik/newDir/server-installer/dv-6.3.0.ER2/target/jboss-eap-6.4/standalone/data/content/b0/7f37d82389f48b61922095c3d118870fda6116/content
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months
[JBoss JIRA] (TEIID-4413) With DISTINCT an aggregate order by is required to reference the aggregate arguments
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIID-4413:
-----------------------------------
Summary: With DISTINCT an aggregate order by is required to reference the aggregate arguments
Key: TEIID-4413
URL: https://issues.jboss.org/browse/TEIID-4413
Project: Teiid
Issue Type: Bug
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Fix For: 9.0.2
Hi,
I'm using the function STRING_AGG(distinct FORMATTIMESTAMP(somedate,'dd-MM-yyyy'),',' ORDER BY somedate) in a script that was made using 8.11.3. This used to work.
In 9.0.2 I get an error with the following message: With DISTINCT an aggregate order by is required to reference the aggregate arguments
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 6 months