JDBC-V2: ResultSet inferred type for arrays is always Object[] #2457

  @Test
  void required_testJdbcWithArray() throws Exception {
    final String url = "jdbc:ch://localhost:8123";

    final Properties info = new Properties();
    info.put("user", "default");
    info.put("password", "");

    try (final Connection conn = DriverManager.getConnection(url, info)) {
      conn.prepareStatement("CREATE TABLE test_array_table"
          + " (id Int64, array_field Array(Int64)) ENGINE = MergeTree() ORDER BY id").execute();
      conn.prepareStatement("INSERT INTO test_array_table VALUES (1, [1,2,3])").execute();
      try (final Statement tableStatement = conn.createStatement();
      final ResultSet resultSet = tableStatement.executeQuery("SELECT `array_field` FROM `test_array_table`")) {
        resultSet.next();
        final Array columnValue = resultSet.getArray(1);
        // The 2 assertions below should pass: instead we retrieve Object[]
        Assertions.assertThat(columnValue.getArray()).isExactlyInstanceOf(Long[].class);
        Assertions.assertThat(JDBCType.valueOf(columnValue.getBaseType())).isEqualTo(JDBCType.BIGINT);
      }
    }
  }