[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=15199608#comment-15199608 ] Serge Harnyk commented on DRILL-4436: - Confirmed in postgres > Result data gets mixed up when various

[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=15201364#comment-15201364 ] Serge Harnyk commented on DRILL-4405: - The option to solve the problem lays in creating classes for

[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=15194006#comment-15194006 ] Serge Harnyk commented on DRILL-4405: - Also select PI() from postgres.public.tversion throws

[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=15195088#comment-15195088 ] Serge Harnyk commented on DRILL-4409: - Also: select *, 'FF' from postgres.public.tversion returns id

[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=15195239#comment-15195239 ] Serge Harnyk commented on DRILL-4409: - Dont reproduce in mysql > projecting literal will result in an

[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=15197798#comment-15197798 ] Serge Harnyk commented on DRILL-4409: - PostgreSQL JDBC Driver returns metadata code for literal

[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=15197767#comment-15197767 ] Serge Harnyk commented on DRILL-4405: - Calcite doesnt have a CONCAT() as function, only "||" operator.

[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=15199767#comment-15199767 ] Serge Harnyk commented on DRILL-4436: - I think the problem is more serious. I created two same tables

[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=15216175#comment-15216175 ] Serge Harnyk commented on DRILL-4405: - Doesn't reproduce in Drill 1.7. Solved in DRILL-4372 > invalid

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4403: Assignee: Taras Supyk (was: Serge Harnyk) > AssertionError: Internal error: Conversion to

[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=15210267#comment-15210267 ] Serge Harnyk commented on DRILL-4395: - Same as DRILL-4436 > equi-inner join of two tables in Postgres

[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=15210185#comment-15210185 ] Serge Harnyk commented on DRILL-4399: - Add a bug for Calcite:

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4399: External issue ID: CALCITE-1167 > query using OVERLAPS function executes and returns 0 rows >

[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=15208275#comment-15208275 ] Serge Harnyk commented on DRILL-4399: - Query before optimisation: select 1 from tdt where (date

[jira] [Comment Edited] (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=15208275#comment-15208275 ] Serge Harnyk edited comment on DRILL-4399 at 3/23/16 11:25 AM: --- Query before

[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=15217742#comment-15217742 ] Serge Harnyk commented on DRILL-4404: - Cant reproduce. > Java NPE. Unexpected exception during

[jira] [Closed] (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:all-tabpanel ] Serge Harnyk closed DRILL-4405. --- Resolution: Fixed > invalid Postgres SQL generated for CONCAT (literal, literal) >

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

[ https://issues.apache.org/jira/browse/DRILL-4404?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk closed DRILL-4404. --- Resolution: Cannot Reproduce > Java NPE. Unexpected exception during fragment initialization >

[jira] [Commented] (DRILL-4458) JDBC plugin case sensitive table names

[ https://issues.apache.org/jira/browse/DRILL-4458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15214195#comment-15214195 ] Serge Harnyk commented on DRILL-4458: - Its bug of current version of Calcite that Drill uses:

[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=15214071#comment-15214071 ] Serge Harnyk commented on DRILL-4409: - Resume: 1. PostgreSQL returns "unknown" type for literals. It

[jira] [Updated] (DRILL-4458) JDBC plugin case sensitive table names

[ https://issues.apache.org/jira/browse/DRILL-4458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4458: External issue ID: DRILL-3993 > JDBC plugin case sensitive table names >

[jira] [Created] (DRILL-4865) Add ANSI format for date/time functions

Serge Harnyk created DRILL-4865: --- Summary: Add ANSI format for date/time functions Key: DRILL-4865 URL: https://issues.apache.org/jira/browse/DRILL-4865 Project: Apache Drill Issue Type:

[jira] [Created] (DRILL-4864) Add ANSI format for date/time functions

Serge Harnyk created DRILL-4864: --- Summary: Add ANSI format for date/time functions Key: DRILL-4864 URL: https://issues.apache.org/jira/browse/DRILL-4864 Project: Apache Drill Issue Type:

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Closed] (DRILL-4865) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk closed DRILL-4865. --- Resolution: Duplicate > Add ANSI format for date/time functions >

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4396: Assignee: (was: Serge Harnyk) > Generates invalid cast specification in re-written query to

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4395: Assignee: (was: Serge Harnyk) > equi-inner join of two tables in Postgres returns null one of

[jira] [Updated] (DRILL-4458) JDBC plugin case sensitive table names

[ https://issues.apache.org/jira/browse/DRILL-4458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4458: Assignee: (was: Serge Harnyk) > JDBC plugin case sensitive table names >

[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 ] Serge Harnyk updated DRILL-4436: Assignee: (was: Serge Harnyk) > Result data gets mixed up when various tables have a column

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4399: Assignee: (was: Serge Harnyk) > query using OVERLAPS function executes and returns 0 rows >

[jira] [Updated] (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:all-tabpanel ] Serge Harnyk updated DRILL-4409: Assignee: (was: Serge Harnyk) > projecting literal will result in an empty resultset >

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Attachment: jodatime_ansi.odt > Add ANSI format for date/time functions >

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Attachment: (was: jodatime_ansi.odt) > Add ANSI format for date/time functions >

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serge Harnyk updated DRILL-4864: Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL layer.