[JBoss JIRA] (TEIID-3550) Missing status of VDB in jboss-cli console
by Juraj Duráni (JIRA)
Juraj Duráni created TEIID-3550:
-----------------------------------
Summary: Missing status of VDB in jboss-cli console
Key: TEIID-3550
URL: https://issues.jboss.org/browse/TEIID-3550
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Priority: Trivial
There is missing status in failure description of command "get-vdb".
"failure-description" => "TEIID50096 VDB xyz.1 is {2} and not ACTIVE. "
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3549) Join conditions with OR generate a wrong JDBC query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3549?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3549:
----------------------------------
Priority: Major (was: Critical)
> Join conditions with OR generate a wrong JDBC query
> ---------------------------------------------------
>
> Key: TEIID-3549
> URL: https://issues.jboss.org/browse/TEIID-3549
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> I'm using Teiid 8.10 with h2 translator
> I have the following query containing a join with conditions separated by OR logical operator:
> select "BilanBanque"."SIGNEDDATA" as "CalculatedField1"
> from "implify_data"."Evolution_PCy_050615" "Evolution_PCy_050615"
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "MidCat" ON "Evolution_PCy_050615"."ID" = "MidCat"."PID" AND ( ( ("MidCat"."Level" IN (1) ) ) )
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "Data" ON ( ( ("Data"."Level" IN (2) ) ) AND ( ("Data"."PID" = "Evolution_PCy_050615"."ID") OR ("Data"."PID" = "MidCat"."ID") ) )
> LEFT JOIN "implify_data"."Sheet1_haU_010615" "BilanBanque" ON "Data"."ID" = "BilanBanque"."Account"
> where ("BilanBanque"."BankName" IN ('Bank1') )
> The corresponding JDBC query executed by Teiid contains 2 times ON after the join:
> SELECT g_3."SIGNEDDATA" FROM "implify_data"."Evolution_PCy_050615" AS g_0 LEFT OUTER JOIN "implify_data"."Evolution_PCy_050615" AS g_1 ON g_0."ID" = g_1."PID" AND g_1."Level" = 1 INNER JOIN "implify_data"."Evolution_PCy_050615" AS g_2 INNER JOIN "implify_data"."Sheet1_haU_010615" AS g_3 ON g_2."ID" = g_3."Account" ON g_2."PID" = g_0."ID" OR g_2."PID" = g_1."ID" WHERE g_2."Level" = 2 AND g_3."BankName" = 'Bank1'
> if I remove the conditions with OR from the join, the query executes with success.
> You find below the execution 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>CalculatedField1 (bigdecimal)</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: -1.0</value></property><property name="Query"><value>SELECT g_3.SIGNEDDATA FROM (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_0 LEFT OUTER JOIN implify_dataModel.implify_data.Evolution_PCy_050615 AS g_1 ON g_0.ID = g_1.PID AND g_1.Level = 1) INNER JOIN (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_2 INNER JOIN implify_dataModel.implify_data.Sheet1_haU_010615 AS g_3 ON g_2.ID = g_3.Account) ON ((g_2.PID = g_0.ID) OR (g_2.PID = g_1.ID)) WHERE (g_2.Level = 2) AND (g_3.BankName = 'Bank1')</value></property><property name="Model Name"><value>implify_dataModel</value></property><property name="Data Bytes Sent"><value>0</value></property></node>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3549) Join conditions with OR generate a wrong JDBC query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3549?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3549.
-----------------------------------
Resolution: Done
Updated the translator to use parens for joins.
> Join conditions with OR generate a wrong JDBC query
> ---------------------------------------------------
>
> Key: TEIID-3549
> URL: https://issues.jboss.org/browse/TEIID-3549
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> I'm using Teiid 8.10 with h2 translator
> I have the following query containing a join with conditions separated by OR logical operator:
> select "BilanBanque"."SIGNEDDATA" as "CalculatedField1"
> from "implify_data"."Evolution_PCy_050615" "Evolution_PCy_050615"
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "MidCat" ON "Evolution_PCy_050615"."ID" = "MidCat"."PID" AND ( ( ("MidCat"."Level" IN (1) ) ) )
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "Data" ON ( ( ("Data"."Level" IN (2) ) ) AND ( ("Data"."PID" = "Evolution_PCy_050615"."ID") OR ("Data"."PID" = "MidCat"."ID") ) )
> LEFT JOIN "implify_data"."Sheet1_haU_010615" "BilanBanque" ON "Data"."ID" = "BilanBanque"."Account"
> where ("BilanBanque"."BankName" IN ('Bank1') )
> The corresponding JDBC query executed by Teiid contains 2 times ON after the join:
> SELECT g_3."SIGNEDDATA" FROM "implify_data"."Evolution_PCy_050615" AS g_0 LEFT OUTER JOIN "implify_data"."Evolution_PCy_050615" AS g_1 ON g_0."ID" = g_1."PID" AND g_1."Level" = 1 INNER JOIN "implify_data"."Evolution_PCy_050615" AS g_2 INNER JOIN "implify_data"."Sheet1_haU_010615" AS g_3 ON g_2."ID" = g_3."Account" ON g_2."PID" = g_0."ID" OR g_2."PID" = g_1."ID" WHERE g_2."Level" = 2 AND g_3."BankName" = 'Bank1'
> if I remove the conditions with OR from the join, the query executes with success.
> You find below the execution 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>CalculatedField1 (bigdecimal)</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: -1.0</value></property><property name="Query"><value>SELECT g_3.SIGNEDDATA FROM (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_0 LEFT OUTER JOIN implify_dataModel.implify_data.Evolution_PCy_050615 AS g_1 ON g_0.ID = g_1.PID AND g_1.Level = 1) INNER JOIN (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_2 INNER JOIN implify_dataModel.implify_data.Sheet1_haU_010615 AS g_3 ON g_2.ID = g_3.Account) ON ((g_2.PID = g_0.ID) OR (g_2.PID = g_1.ID)) WHERE (g_2.Level = 2) AND (g_3.BankName = 'Bank1')</value></property><property name="Model Name"><value>implify_dataModel</value></property><property name="Data Bytes Sent"><value>0</value></property></node>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3506) Move downloads off of sourceforge
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3506?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3506:
---------------------------------------
The downloads now point to nexus. I think the repository also maintains stats, but there is still a .org issue open on that.
> Move downloads off of sourceforge
> ---------------------------------
>
> Key: TEIID-3506
> URL: https://issues.jboss.org/browse/TEIID-3506
> Project: Teiid
> Issue Type: Quality Risk
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> We need to move our downloads off of sourceforge onto an infrastructure we have more control over. This can be as simple as just pointing to the maven artifacts (which means that the server uber dist needs added) or we can start using the jboss.org download site.
> More than likely we'll leave the old downloads in place.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3511) usage of BITAND function in exists statement results in duplicate rows
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3511?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3511:
---------------------------------------
> I'm sorry but I can not give you the data because it is medical data. I tried to reproduce this with less joins but then everything seems to work out fine.
Would it be possible to provide a post execution query plan that shows the row counts for the processing nodes? That may provide a clue as to where the processing is not correct.
> Do you have any idea what might have caused this?
Bitand is not a source supported function (which sources are you accessing?) and so the subquery does not pushdown and the resulting plan is different than without the bitand predicate. From there it's not clear where the problem is.
> I now also used a temp table joined with 2 tables and then a where clause that has an exists condition with and without a BITAND function call.
Are you saying that it also appears to return duplicate results?
> usage of BITAND function in exists statement results in duplicate rows
> ----------------------------------------------------------------------
>
> Key: TEIID-3511
> URL: https://issues.jboss.org/browse/TEIID-3511
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.9.1
> Reporter: Bram Gadeyne
> Assignee: Steven Hawkins
> Fix For: 8.12
>
> Attachments: debugplan_bitand.txt, debugplan_bitand_correct.txt, debugplan_nobitand.txt, debugplan_nobitand_correct.txt
>
>
> I've added the debug plan for the query without the BITAND function and with the BITAND function as an attachment.
> The version without the BITAND function returns 438 rows and the version with BITAND function returns 833 rows. I can see however that rows are duplicated in this second result. I've checked this by executing the version with BITAND statement with select *.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3549) Join conditions with OR generate a wrong JDBC query
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3549?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3549:
----------------------------------
Fix Version/s: 8.12
Component/s: JDBC Connector
The source sql is valid, but is not supported by h2. It appears to require nesting parens.
> Join conditions with OR generate a wrong JDBC query
> ---------------------------------------------------
>
> Key: TEIID-3549
> URL: https://issues.jboss.org/browse/TEIID-3549
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.12
>
>
> I'm using Teiid 8.10 with h2 translator
> I have the following query containing a join with conditions separated by OR logical operator:
> select "BilanBanque"."SIGNEDDATA" as "CalculatedField1"
> from "implify_data"."Evolution_PCy_050615" "Evolution_PCy_050615"
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "MidCat" ON "Evolution_PCy_050615"."ID" = "MidCat"."PID" AND ( ( ("MidCat"."Level" IN (1) ) ) )
> LEFT JOIN "implify_data"."Evolution_PCy_050615" "Data" ON ( ( ("Data"."Level" IN (2) ) ) AND ( ("Data"."PID" = "Evolution_PCy_050615"."ID") OR ("Data"."PID" = "MidCat"."ID") ) )
> LEFT JOIN "implify_data"."Sheet1_haU_010615" "BilanBanque" ON "Data"."ID" = "BilanBanque"."Account"
> where ("BilanBanque"."BankName" IN ('Bank1') )
> The corresponding JDBC query executed by Teiid contains 2 times ON after the join:
> SELECT g_3."SIGNEDDATA" FROM "implify_data"."Evolution_PCy_050615" AS g_0 LEFT OUTER JOIN "implify_data"."Evolution_PCy_050615" AS g_1 ON g_0."ID" = g_1."PID" AND g_1."Level" = 1 INNER JOIN "implify_data"."Evolution_PCy_050615" AS g_2 INNER JOIN "implify_data"."Sheet1_haU_010615" AS g_3 ON g_2."ID" = g_3."Account" ON g_2."PID" = g_0."ID" OR g_2."PID" = g_1."ID" WHERE g_2."Level" = 2 AND g_3."BankName" = 'Bank1'
> if I remove the conditions with OR from the join, the query executes with success.
> You find below the execution 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>CalculatedField1 (bigdecimal)</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: -1.0</value></property><property name="Query"><value>SELECT g_3.SIGNEDDATA FROM (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_0 LEFT OUTER JOIN implify_dataModel.implify_data.Evolution_PCy_050615 AS g_1 ON g_0.ID = g_1.PID AND g_1.Level = 1) INNER JOIN (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_2 INNER JOIN implify_dataModel.implify_data.Sheet1_haU_010615 AS g_3 ON g_2.ID = g_3.Account) ON ((g_2.PID = g_0.ID) OR (g_2.PID = g_1.ID)) WHERE (g_2.Level = 2) AND (g_3.BankName = 'Bank1')</value></property><property name="Model Name"><value>implify_dataModel</value></property><property name="Data Bytes Sent"><value>0</value></property></node>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3549) Join conditions with OR generate a wrong JDBC query
by Mark Tawk (JIRA)
Mark Tawk created TEIID-3549:
--------------------------------
Summary: Join conditions with OR generate a wrong JDBC query
Key: TEIID-3549
URL: https://issues.jboss.org/browse/TEIID-3549
Project: Teiid
Issue Type: Bug
Reporter: Mark Tawk
Assignee: Steven Hawkins
Priority: Critical
I'm using Teiid 8.10 with h2 translator
I have the following query containing a join with conditions separated by OR logical operator:
select "BilanBanque"."SIGNEDDATA" as "CalculatedField1"
from "implify_data"."Evolution_PCy_050615" "Evolution_PCy_050615"
LEFT JOIN "implify_data"."Evolution_PCy_050615" "MidCat" ON "Evolution_PCy_050615"."ID" = "MidCat"."PID" AND ( ( ("MidCat"."Level" IN (1) ) ) )
LEFT JOIN "implify_data"."Evolution_PCy_050615" "Data" ON ( ( ("Data"."Level" IN (2) ) ) AND ( ("Data"."PID" = "Evolution_PCy_050615"."ID") OR ("Data"."PID" = "MidCat"."ID") ) )
LEFT JOIN "implify_data"."Sheet1_haU_010615" "BilanBanque" ON "Data"."ID" = "BilanBanque"."Account"
where ("BilanBanque"."BankName" IN ('Bank1') )
The corresponding JDBC query executed by Teiid contains 2 times ON after the join:
SELECT g_3."SIGNEDDATA" FROM "implify_data"."Evolution_PCy_050615" AS g_0 LEFT OUTER JOIN "implify_data"."Evolution_PCy_050615" AS g_1 ON g_0."ID" = g_1."PID" AND g_1."Level" = 1 INNER JOIN "implify_data"."Evolution_PCy_050615" AS g_2 INNER JOIN "implify_data"."Sheet1_haU_010615" AS g_3 ON g_2."ID" = g_3."Account" ON g_2."PID" = g_0."ID" OR g_2."PID" = g_1."ID" WHERE g_2."Level" = 2 AND g_3."BankName" = 'Bank1'
if I remove the conditions with OR from the join, the query executes with success.
You find below the execution 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>CalculatedField1 (bigdecimal)</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: -1.0</value></property><property name="Query"><value>SELECT g_3.SIGNEDDATA FROM (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_0 LEFT OUTER JOIN implify_dataModel.implify_data.Evolution_PCy_050615 AS g_1 ON g_0.ID = g_1.PID AND g_1.Level = 1) INNER JOIN (implify_dataModel.implify_data.Evolution_PCy_050615 AS g_2 INNER JOIN implify_dataModel.implify_data.Sheet1_haU_010615 AS g_3 ON g_2.ID = g_3.Account) ON ((g_2.PID = g_0.ID) OR (g_2.PID = g_1.ID)) WHERE (g_2.Level = 2) AND (g_3.BankName = 'Bank1')</value></property><property name="Model Name"><value>implify_dataModel</value></property><property name="Data Bytes Sent"><value>0</value></property></node>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months