[CALCITE-1031] In prepared statement, CsvScannableTable.scan is called twice

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: avatica-1.7.0, 1.7.0
• Component/s: avatica

Environment

jdk 1.8.0_20 linux mint 17.3

• Assignee: Zhen Wang
• Reporter: Anıl Chalil
• Created: 19/Dec/15 12:21
• Updated: 14/Mar/16 15:07
• Resolved: 14/Feb/16 19:59

Description

Hi,

I just noticed something when i am playing with examples.

  Class.forName("org.apache.calcite.jdbc.Driver")
  val properties: Properties = new Properties()
  properties.setProperty("caseSensitive","true")
  val connection = DriverManager.getConnection("jdbc:calcite:", properties)
  val calciteConnection=connection.unwrap(classOf[CalciteConnection])

  val schema= (new CsvSchemaFactory()).create(calciteConnection.getRootSchema,null,Map[String,AnyRef]("directory" -> "src/main/resources/csv","flavor" -> "scannable").asJava)

  calciteConnection.getRootSchema.add("TEST",schema)


  val statement2=calciteConnection.prepareStatement("select \"tarih\" from \"TEST\".\"timeseries\" where \"sensor\" = ?")

  statement2.setString(1,"sensor38")
  val resultSet1=statement2.executeQuery()
  while(resultSet1.next())
    println(resultSet1.getString("tarih"))

My example like above. But when i call executeQuery i noticed that CsvScannableTable.scan called twice and enumerator iterating on values. When i inspected stacktraces i found that one of the call come from AvaticaConnection.java:463 and the other one is AvaticaConnection:489 .