[JBoss JIRA] (TEIID-2399) Rewriting And-Conjunction does not work properly
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2399?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2399.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-2366
> Rewriting And-Conjunction does not work properly
> ------------------------------------------------
>
> Key: TEIID-2399
> URL: https://issues.jboss.org/browse/TEIID-2399
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7.1, 8.2
> Environment: EDS 5.3.0
> Reporter: Hisanobu Okuda
> Assignee: Steven Hawkins
>
> The following query should return no row, but returns 1 row actually.
> {code}
> select * from (select 1 f1) x where x.f1 = 1 and x.f1 != 1;
> {code}
> The Query Processor rewrites the criteria to x.f1 = 1.
> The following query should return 1 row, but returns no row actually.
> {code}
> select * from (select 1 f1) x where x.f1 = 1 and x.f1 < 2;
> {code}
> The Query Processor rewrites the criteria to 1 = 0.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2366) If where clause contains both equal and greater then conditions then query may return no results
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2366?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-2366:
----------------------------------
Fix Version/s: 7.7.5
> If where clause contains both equal and greater then conditions then query may return no results
> ------------------------------------------------------------------------------------------------
>
> Key: TEIID-2366
> URL: https://issues.jboss.org/browse/TEIID-2366
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.4
> Reporter: Paul Lysak
> Assignee: Steven Hawkins
> Labels: query,, where
> Fix For: 8.3, 7.7.5
>
>
> If WHERE clause contains '>' and '=' conditions for the same field then query may produce no result - depending on conditions order.
> The problem seems to be in org.teiid.query.rewriter.QueryRewriter class, method rewriteAndConjunct(). Pay attention to following piece of code:
> ... if (cc1.getOperator() == CompareCriteria.EQ) {
> if (!Evaluator.compare(cc1, ((Constant)cc1.getRightExpression()).getValue(), ((Constant)cc.getRightExpression()).getValue())) {
> return FALSE_CRITERIA;
> }
> Note that cc1 (which is guaranteed to have EQ criterion) is passed to Evaluator.compare. Thus right expressions of cc and cc1 are required to be equal. But if we have one contition EQ and another GT then it should instead check if right side of EQ is bigger then right side of GT.
> Bug TEIID-1704 describes a bit similar situation but it is still a different case.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2399) Rewriting And-Conjunction does not work properly
by Hisanobu Okuda (JIRA)
Hisanobu Okuda created TEIID-2399:
-------------------------------------
Summary: Rewriting And-Conjunction does not work properly
Key: TEIID-2399
URL: https://issues.jboss.org/browse/TEIID-2399
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.2, 7.7.1
Environment: EDS 5.3.0
Reporter: Hisanobu Okuda
Assignee: Steven Hawkins
The following query should return no row, but returns 1 row actually.
{code}
select * from (select 1 f1) x where x.f1 = 1 and x.f1 != 1;
{code}
The Query Processor rewrites the criteria to x.f1 = 1.
The following query should return 1 row, but returns no row actually.
{code}
select * from (select 1 f1) x where x.f1 = 1 and x.f1 < 2;
{code}
The Query Processor rewrites the criteria to 1 = 0.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2398) Web console in domain mode loose active servers and shows just inactive ones
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2398?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2398:
-------------------------------------
I believe AS7 has made much more progress after we released Teiid plugin. The domain management is completely done through core services of AS7 web-console. I see see if I can upgrade to latest.
> Web console in domain mode loose active servers and shows just inactive ones
> ----------------------------------------------------------------------------
>
> Key: TEIID-2398
> URL: https://issues.jboss.org/browse/TEIID-2398
> Project: Teiid
> Issue Type: Bug
> Components: Web Console
> Affects Versions: 8.2
> Environment: Centos 6.3, JBoss 7.1.1 TEIID 8.2, Java 1.6
> Reporter: luca gioppo
> Assignee: Ramesh Reddy
> Labels: console, domain, web
> Fix For: 8.3
>
> Attachments: teiid.png, teiid2.png, teiid3.png, teiid4.png, teiid5.png
>
>
> I have a domain environment (for now just one host with both the domain controllere and tow servers instances) with two server groups and one servre in each group; it will be configured to be in HA.
> I added the web console to the installation (copyed the stuff in the folder and hope this was the correct way of doing)
> When I go to the runtime only the stopped server are present and canno select the running one.
> This makes the console un-usable since not choosing the server stop all other activity with errors.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2398) Web console in domain mode loose active servers and shows just inactive ones
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-2398?page=com.atlassian.jira.plugin... ]
luca gioppo commented on TEIID-2398:
------------------------------------
To better show the problem:
I added the mysql connector with cli 8it did not work from web console)
now would like to use the web console to add a datasource, but ... you see the error.
With cli all works correctly
Luca
> Web console in domain mode loose active servers and shows just inactive ones
> ----------------------------------------------------------------------------
>
> Key: TEIID-2398
> URL: https://issues.jboss.org/browse/TEIID-2398
> Project: Teiid
> Issue Type: Bug
> Components: Web Console
> Affects Versions: 8.2
> Environment: Centos 6.3, JBoss 7.1.1 TEIID 8.2, Java 1.6
> Reporter: luca gioppo
> Assignee: Ramesh Reddy
> Labels: console, domain, web
> Fix For: 8.3
>
> Attachments: teiid.png, teiid2.png, teiid3.png, teiid4.png, teiid5.png
>
>
> I have a domain environment (for now just one host with both the domain controllere and tow servers instances) with two server groups and one servre in each group; it will be configured to be in HA.
> I added the web console to the installation (copyed the stuff in the folder and hope this was the correct way of doing)
> When I go to the runtime only the stopped server are present and canno select the running one.
> This makes the console un-usable since not choosing the server stop all other activity with errors.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2398) Web console in domain mode loose active servers and shows just inactive ones
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-2398?page=com.atlassian.jira.plugin... ]
luca gioppo updated TEIID-2398:
-------------------------------
Attachment: teiid4.png
teiid5.png
> Web console in domain mode loose active servers and shows just inactive ones
> ----------------------------------------------------------------------------
>
> Key: TEIID-2398
> URL: https://issues.jboss.org/browse/TEIID-2398
> Project: Teiid
> Issue Type: Bug
> Components: Web Console
> Affects Versions: 8.2
> Environment: Centos 6.3, JBoss 7.1.1 TEIID 8.2, Java 1.6
> Reporter: luca gioppo
> Assignee: Ramesh Reddy
> Labels: console, domain, web
> Fix For: 8.3
>
> Attachments: teiid.png, teiid2.png, teiid3.png, teiid4.png, teiid5.png
>
>
> I have a domain environment (for now just one host with both the domain controllere and tow servers instances) with two server groups and one servre in each group; it will be configured to be in HA.
> I added the web console to the installation (copyed the stuff in the folder and hope this was the correct way of doing)
> When I go to the runtime only the stopped server are present and canno select the running one.
> This makes the console un-usable since not choosing the server stop all other activity with errors.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2398) Web console in domain mode loose active servers and shows just inactive ones
by luca gioppo (JIRA)
[ https://issues.jboss.org/browse/TEIID-2398?page=com.atlassian.jira.plugin... ]
luca gioppo updated TEIID-2398:
-------------------------------
Attachment: teiid.png
teiid3.png
teiid2.png
> Web console in domain mode loose active servers and shows just inactive ones
> ----------------------------------------------------------------------------
>
> Key: TEIID-2398
> URL: https://issues.jboss.org/browse/TEIID-2398
> Project: Teiid
> Issue Type: Bug
> Components: Web Console
> Affects Versions: 8.2
> Environment: Centos 6.3, JBoss 7.1.1 TEIID 8.2, Java 1.6
> Reporter: luca gioppo
> Assignee: Ramesh Reddy
> Labels: console, domain, web
> Fix For: 8.3
>
> Attachments: teiid.png, teiid2.png, teiid3.png
>
>
> I have a domain environment (for now just one host with both the domain controllere and tow servers instances) with two server groups and one servre in each group; it will be configured to be in HA.
> I added the web console to the installation (copyed the stuff in the folder and hope this was the correct way of doing)
> When I go to the runtime only the stopped server are present and canno select the running one.
> This makes the console un-usable since not choosing the server stop all other activity with errors.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2398) Web console in domain mode loose active servers and shows just inactive ones
by luca gioppo (JIRA)
luca gioppo created TEIID-2398:
----------------------------------
Summary: Web console in domain mode loose active servers and shows just inactive ones
Key: TEIID-2398
URL: https://issues.jboss.org/browse/TEIID-2398
Project: Teiid
Issue Type: Bug
Components: Web Console
Affects Versions: 8.2
Environment: Centos 6.3, JBoss 7.1.1 TEIID 8.2, Java 1.6
Reporter: luca gioppo
Assignee: Ramesh Reddy
Fix For: 8.3
I have a domain environment (for now just one host with both the domain controllere and tow servers instances) with two server groups and one servre in each group; it will be configured to be in HA.
I added the web console to the installation (copyed the stuff in the folder and hope this was the correct way of doing)
When I go to the runtime only the stopped server are present and canno select the running one.
This makes the console un-usable since not choosing the server stop all other activity with errors.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months
[JBoss JIRA] (TEIID-2330) Failed load shows a loading in the console
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2330?page=com.atlassian.jira.plugin... ]
Ramesh Reddy resolved TEIID-2330.
---------------------------------
Assignee: Ramesh Reddy
Fix Version/s: 8.3
Resolution: Done
Removed the wrapping of the DuplicateRecordException with TranslatorException in jdbc translator
> Failed load shows a loading in the console
> ------------------------------------------
>
> Key: TEIID-2330
> URL: https://issues.jboss.org/browse/TEIID-2330
> Project: Teiid
> Issue Type: Bug
> Components: Tools
> Reporter: Steven Hawkins
> Assignee: Ramesh Reddy
> Fix For: 8.3
>
>
> The metadataexception in the forum post should transition the vdb to failed. I'm logging this initially against the console as we have a similar unit test that correctly reports a failed load given invalid ddl, which is essentially the same exception.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
11 years, 10 months