[JBoss JIRA] (TEIID-3551) NPE creating trigger on a view that doesn't exist
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3551:
-------------------------------------
Summary: NPE creating trigger on a view that doesn't exist
Key: TEIID-3551
URL: https://issues.jboss.org/browse/TEIID-3551
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.12
If the target does not exist, then an NPE rather than a meaningful exception will be thrown.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3324) Boolean fields with null are evaluated to false
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3324?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3324:
------------------------------------------------
Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1206576|https://bugzilla.redhat.com/show_bug.cgi?id=1206576] from ON_QA to VERIFIED
> Boolean fields with null are evaluated to false
> -----------------------------------------------
>
> Key: TEIID-3324
> URL: https://issues.jboss.org/browse/TEIID-3324
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 7.1
> Reporter: Salvatore R
> Assignee: Steven Hawkins
> Fix For: 8.10, 8.7.2, 8.7.1.6_2
>
>
> I have a source table defined as follows (e.g. in PostgreSQL):
> {code:sql}
> CREATE TABLE public.test
> (
> id integer,
> iscustomer boolean
> )
> {code}
> and the table contains these rows:
> {code:sql}
> insert into public.test values(1, null);
> insert into public.test values(2, true);
> insert into public.test values(3, false);
> {code}
>
> When I try to get data from this table in Teiid, the "null" value is evaluated as false:
> ||id||iscustomer||
> |1|false|
> |2|true|
> |3|false|
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3296) Some criteria are missing when indexes are used on the source tables
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3296?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3296:
------------------------------------------------
Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1206573|https://bugzilla.redhat.com/show_bug.cgi?id=1206573] from ON_QA to VERIFIED
> Some criteria are missing when indexes are used on the source tables
> --------------------------------------------------------------------
>
> Key: TEIID-3296
> URL: https://issues.jboss.org/browse/TEIID-3296
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.2
> Reporter: Salvatore R
> Assignee: Steven Hawkins
> Priority: Blocker
> Fix For: 8.10, 8.7.2, 8.7.1.6_2
>
>
> The following two tables are defined in two different datasources (PostgreSQL and MySQL):
> {code:sql}
> CREATE TABLE "pg"."tx1"
> (
> a varchar(2147483647),
> b varchar(2147483647),
> c integer,
> d integer,
> e integer
> );
> CREATE INDEX tx1_b ON "pg"."tx1"(b);
> CREATE INDEX tx1_a ON "pg"."tx1"(a);
> CREATE INDEX tx1_e ON "pg"."tx1"(e);
> CREATE INDEX tx1_d ON "pg"."tx1"(d);
> CREATE INDEX tx1_c ON "pg"."tx1"(c);
>
> CREATE TABLE "my"."tx2"
> (
> a integer,
> b integer,
> c integer,
> d integer,
> e integer
> );
> insert into tx1 VALUES(1,1,1,1,1) ;
> insert into tx1 VALUES(1,2,2,2,2) ;
> insert into tx1 VALUES(1,2,3,3,3) ;
> insert into tx1 VALUES(1,2,3,4,4) ;
> insert into tx1 VALUES(1,2,3,4,5) ;
> insert into tx2 VALUES(1,2,3,4,5) ;
> {code}
> Running the following query:
> {code:sql}
> select tx1.* from pg.tx1 as tx1 join my.tx2 as tx2 on tx1.a=tx2.a and tx1.b=tx2.b and tx1.c=tx2.c and tx1.d=tx2.d and tx1.e!=tx2.e;
> {code}
> a wrong result is returned:
> ||a||b||c||d||e||
> |1|2|2|2|2|
> |1|2|3|3|3|
> |1|2|3|4|4|
> If indexes are removed from the source table, the expected result is correctly returned:
> ||a||b||c||d||e||
> |1|2|3|4|4|
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months
[JBoss JIRA] (TEIID-3204) Admin shell throws an IncompatibleClassChangeError
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3204?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3204:
------------------------------------------------
Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1161428|https://bugzilla.redhat.com/show_bug.cgi?id=1161428] from ON_QA to VERIFIED
> Admin shell throws an IncompatibleClassChangeError
> --------------------------------------------------
>
> Key: TEIID-3204
> URL: https://issues.jboss.org/browse/TEIID-3204
> Project: Teiid
> Issue Type: Bug
> Components: Tools
> Affects Versions: 8.7.1
> Environment: OS: fedora 20
> arch: x86_64
> java: oracle 1.7
> Reporter: Juraj Duráni
> Assignee: Van Halbert
> Fix For: 8.7.1.6_2
>
>
> Admin shell throws an IncompatibleClassChangeError when wrong path to groovy script is provided along with load command.
> Actual result:
> ===> [import static org.teiid.adminshell.AdminShell.*; import static org.teiid.adminshell.GroovySqlExtensions.*; import org.teiid.adminapi.*;]
> FATAL: java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5
> java.lang.IncompatibleClassChangeError: the number of constructors during runtime and compile time for java.lang.Exception do not match. Expected 4 but got 5
> at groovy.lang.MetaClassImpl.selectConstructorAndTransformArguments(MetaClassImpl.java:1406)
> at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.selectConstructorAndTransformArguments(ScriptBytecodeAdapter.java:237)
> at org.codehaus.groovy.tools.shell.CommandException.<init>(Command.groovy:60)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ....
> ....
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 9 months