[jira] [Commented] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15210149#comment-15210149 ] Taras Supyk commented on DRILL-4374: This bug can't be reproduced. Probably it is already fixed. >

[jira] [Commented] (DRILL-4401) multi-table join projection returning character instead of integer type

[ https://issues.apache.org/jira/browse/DRILL-4401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15204174#comment-15204174 ] Taras Supyk commented on DRILL-4401: This bug can't be reproduced. Looks like it is fixed already. >

[jira] [Commented] (DRILL-4402) pushing unsupported full outer join to Postgres

[ https://issues.apache.org/jira/browse/DRILL-4402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15199542#comment-15199542 ] Taras Supyk commented on DRILL-4402: Looks like this bug is already fixed in new version of calcite.

[jira] [Commented] (DRILL-4409) projecting literal will result in an empty resultset

[ https://issues.apache.org/jira/browse/DRILL-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175585#comment-15175585 ] Taras Supyk commented on DRILL-4409: Can't reproduce in oracle > projecting literal will result in an

[jira] [Commented] (DRILL-4398) SYSTEM ERROR: IllegalStateException: Memory was leaked by query

[ https://issues.apache.org/jira/browse/DRILL-4398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175581#comment-15175581 ] Taras Supyk commented on DRILL-4398: Reproduced with oracle > SYSTEM ERROR: IllegalStateException:

[jira] [Commented] (DRILL-4396) Generates invalid cast specification in re-written query to Postgres

[ https://issues.apache.org/jira/browse/DRILL-4396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175575#comment-15175575 ] Taras Supyk commented on DRILL-4396: Reproduced in oracle > Generates invalid cast specification in

[jira] [Commented] (DRILL-4395) equi-inner join of two tables in Postgres returns null one of the projected columns

[ https://issues.apache.org/jira/browse/DRILL-4395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175574#comment-15175574 ] Taras Supyk commented on DRILL-4395: Reproduced with oracle > equi-inner join of two tables in

[jira] [Commented] (DRILL-4402) pushing unsupported full outer join to Postgres

[ https://issues.apache.org/jira/browse/DRILL-4402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175553#comment-15175553 ] Taras Supyk commented on DRILL-4402: In oracle this query causes SYSTEM ERROR: IllegalStateException:

[jira] [Commented] (DRILL-4403) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

[ https://issues.apache.org/jira/browse/DRILL-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175546#comment-15175546 ] Taras Supyk commented on DRILL-4403: Reproduced with oracle > AssertionError: Internal error:

[jira] [Commented] (DRILL-4405) invalid Postgres SQL generated for CONCAT (literal, literal)

[ https://issues.apache.org/jira/browse/DRILL-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175543#comment-15175543 ] Taras Supyk commented on DRILL-4405: Reproduced with oracle > invalid Postgres SQL generated for

[jira] [Commented] (DRILL-4406) extract () Error: SYSTEM ERROR: ClassCastException. Caused By (java.lang.ClassCastException)

[ https://issues.apache.org/jira/browse/DRILL-4406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175542#comment-15175542 ] Taras Supyk commented on DRILL-4406: Reproduced with oracle > extract () Error: SYSTEM ERROR:

[jira] [Commented] (DRILL-4407) Group by subquery causes Java NPE

[ https://issues.apache.org/jira/browse/DRILL-4407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175536#comment-15175536 ] Taras Supyk commented on DRILL-4407: Reproduced in oracle > Group by subquery causes Java NPE >

[jira] [Commented] (DRILL-4408) re-written query projecting an aggregate on a boolean not supported by Postgres

[ https://issues.apache.org/jira/browse/DRILL-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175533#comment-15175533 ] Taras Supyk commented on DRILL-4408: Reproduced in oracle > re-written query projecting an aggregate

[jira] [Commented] (DRILL-4436) Result data gets mixed up when various tables have a column "label"

[ https://issues.apache.org/jira/browse/DRILL-4436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15175433#comment-15175433 ] Taras Supyk commented on DRILL-4436: Confirmed Reproducing steps: insert into Gender values(1,

[jira] [Updated] (DRILL-4436) Result data gets mixed up when various tables have a column "label"

[ https://issues.apache.org/jira/browse/DRILL-4436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Taras Supyk updated DRILL-4436: --- Description: We have two tables in a MySQL database: CREATE TABLE `Gender` ( `genderId` bigint(20)

[jira] [Commented] (DRILL-4404) Java NPE. Unexpected exception during fragment initialization

[ https://issues.apache.org/jira/browse/DRILL-4404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171855#comment-15171855 ] Taras Supyk commented on DRILL-4404: Can't reproduce > Java NPE. Unexpected exception during

[jira] [Commented] (DRILL-4399) query using OVERLAPS function executes and returns 0 rows

[ https://issues.apache.org/jira/browse/DRILL-4399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171714#comment-15171714 ] Taras Supyk commented on DRILL-4399: Confirmed, Same behavior as in DRILL-4409 > query using OVERLAPS

[jira] [Commented] (DRILL-4409) projecting literal will result in an empty resultset

[ https://issues.apache.org/jira/browse/DRILL-4409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171711#comment-15171711 ] Taras Supyk commented on DRILL-4409: Confirmed > projecting literal will result in an empty resultset

[jira] [Commented] (DRILL-4405) invalid Postgres SQL generated for CONCAT (literal, literal)

[ https://issues.apache.org/jira/browse/DRILL-4405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171710#comment-15171710 ] Taras Supyk commented on DRILL-4405: Confirmed > invalid Postgres SQL generated for CONCAT (literal,

[jira] [Commented] (DRILL-4406) extract () Error: SYSTEM ERROR: ClassCastException. Caused By (java.lang.ClassCastException)

[ https://issues.apache.org/jira/browse/DRILL-4406?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171706#comment-15171706 ] Taras Supyk commented on DRILL-4406: Confirmed, select extract(hour from cts) from public.tts; causes

[jira] [Commented] (DRILL-4402) pushing unsupported full outer join to Postgres

[ https://issues.apache.org/jira/browse/DRILL-4402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171698#comment-15171698 ] Taras Supyk commented on DRILL-4402: Confirmed > pushing unsupported full outer join to Postgres >

[jira] [Commented] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables

[ https://issues.apache.org/jira/browse/DRILL-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171691#comment-15171691 ] Taras Supyk commented on DRILL-4391: Reproduce steps: create sequence user_ids; create table users

[jira] [Commented] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables

[ https://issues.apache.org/jira/browse/DRILL-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171677#comment-15171677 ] Taras Supyk commented on DRILL-4391: Confirmed > browsing metadata via SQLSquirrel shows Postgres

[jira] [Comment Edited] (DRILL-4391) browsing metadata via SQLSquirrel shows Postgres indexes, primary and foreign keys as tables

[ https://issues.apache.org/jira/browse/DRILL-4391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15171677#comment-15171677 ] Taras Supyk edited comment on DRILL-4391 at 2/29/16 10:03 AM: -- Confirmed in

[jira] [Commented] (DRILL-4396) Generates invalid cast specification in re-written query to Postgres

[ https://issues.apache.org/jira/browse/DRILL-4396?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15169050#comment-15169050 ] Taras Supyk commented on DRILL-4396: Confirmed > Generates invalid cast specification in re-written

[jira] [Commented] (DRILL-4408) re-written query projecting an aggregate on a boolean not supported by Postgres

[ https://issues.apache.org/jira/browse/DRILL-4408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15169040#comment-15169040 ] Taras Supyk commented on DRILL-4408: Confirmed > re-written query projecting an aggregate on a

[jira] [Commented] (DRILL-4407) Group by subquery causes Java NPE

[ https://issues.apache.org/jira/browse/DRILL-4407?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15168916#comment-15168916 ] Taras Supyk commented on DRILL-4407: Confirmed > Group by subquery causes Java NPE >

[jira] [Commented] (DRILL-4395) equi-inner join of two tables in Postgres returns null one of the projected columns

[ https://issues.apache.org/jira/browse/DRILL-4395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15168882#comment-15168882 ] Taras Supyk commented on DRILL-4395: Confirmed in psql 9.3.11 > equi-inner join of two tables in

[jira] [Commented] (DRILL-4398) SYSTEM ERROR: IllegalStateException: Memory was leaked by query

[ https://issues.apache.org/jira/browse/DRILL-4398?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15168879#comment-15168879 ] Taras Supyk commented on DRILL-4398: Confirmed in both queries > SYSTEM ERROR: IllegalStateException:

[jira] [Commented] (DRILL-4403) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes

[ https://issues.apache.org/jira/browse/DRILL-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15168877#comment-15168877 ] Taras Supyk commented on DRILL-4403: Confirmed > AssertionError: Internal error: Conversion to

[jira] [Comment Edited] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15158949#comment-15158949 ] Taras Supyk edited comment on DRILL-4374 at 2/23/16 3:00 PM: - I've tried

[jira] [Commented] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15158949#comment-15158949 ] Taras Supyk commented on DRILL-4374: I've tried different jdbc drive and reproduced this bug. So now I

[jira] [Commented] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15157360#comment-15157360 ] Taras Supyk commented on DRILL-4374: I've recreated db structure (simple three tables and join them)

[jira] [Commented] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15157308#comment-15157308 ] Taras Supyk commented on DRILL-4374: I can't reproduce this bug > Drill rewrites Postgres query with

[jira] [Commented] (DRILL-4374) Drill rewrites Postgres query with ambiguous column references

[ https://issues.apache.org/jira/browse/DRILL-4374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15154195#comment-15154195 ] Taras Supyk commented on DRILL-4374: ok > Drill rewrites Postgres query with ambiguous column