[jira] [Commented] (DRILL-2312) JDBC driver returning incorrect data after extended usage

["Daniel Barclay (Drill) (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14337106#comment-14337106 ] 

Daniel Barclay (Drill) commented on DRILL-2312:
-----------------------------------------------

> After executing ~20-30 queries with the JDBC driver, 

1. Does the problem seem to be specific to Drill's JDBC interface?  (By chance have you tried issuing the same query through some Drill interface other than the JDBC interface (e.g., querying through the ODBC interface, querying from a unit test in the java-exec subproject, or querying through the DrillClient class?)

2.  Are your 20 to 30 queries issued on the same JDBC connection or are you creating multiple JDBC connections? Also, are you connecting to an embedded instance(s) of Drill (e.g., using "zk=local" in the JDBC connection URL) or connecting to separately started Drillbits? (JDBC connection closing isn't hooked up right yet, especially for embedded Drill; see DRILL-1735.)  




> JDBC driver returning incorrect data after extended usage
> ---------------------------------------------------------
>
>                 Key: DRILL-2312
>                 URL: https://issues.apache.org/jira/browse/DRILL-2312
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - JDBC
>            Reporter: Norris Lee
>            Assignee: Daniel Barclay (Drill)
>
> After executing ~20-30 queries with the JDBC driver, the data returned from a "Show files" query is incorrect, particularly the isFile and isDirectory columns. The first item in the schema/directory will be correct, but subsequent items will report "false" for isFile and isDirectory.
> This was tested with just a simple program that just loops through executeQuery and prints out the values for isFile and isDirectory. The JDBC driver used was the Drill 0.7 snapshot.
> {code}
> isFile: true
> isDirectory: false
> isFile: false
> isDirectory: false
> isFile: false
> isDirectory: false
> isFile: false
> isDirectory: false
> isFile: false
> isDirectory: false
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)