column type is Array(Nullable(Int64)) But Null becomes 0 in the result returned

[liumaojing]

resultSet:
[3553669559,3571293165,3851086538,3090702645,3407263362]
[3874870412,3451171182,3922428704,3228944982,3590715072]
[NULL,3989698365,3521029982,NULL,NULL]
[NULL]
[3411652369,3144762202,3230150923,3581921969,3306736155]

getArray:
{0,3989698365,3521029982,0,0}

my code:
while (resultSet.next()) {
Array array = resultSet.getArray(1);
Object array1 = array.getArray();
}

version 0.2.3

[zhicwu]

Thanks for reporting the issue. Primitive type should not be used for nullable types.

[liumaojing]

Thanks for reporting the issue. Primitive type should not be used for nullable types.
How do I get Array(Nullable(Int64)) results ?Can you give me an example ?

[zhicwu]

How do I get Array(Nullable(Int64)) results ?Can you give me an example ?

Not your fault. It's a bug in the driver, not only the version you're using but also the latest. As I recalled, in 0.2.3, there's a connection property called use_object_wrapper, changing it to true will stop using primitive type, which might fix the issue at your end. However, I think the better way is to fix the issue and upgrade driver to latest.

[zhicwu]

Starting from 0.3.2-patch9, Array(Nullable(UInt64)) is mapped to Long[] instead of long[].

[liumaojing]

Starting from 0.3.2-patch9, Array(Nullable(UInt64)) is mapped to Long[] instead of long[].

I use getArray() function and it's still long[] ,I use 0.3.2-patch9 version

[liumaojing]

How Can I get Array(Nullable(Int64)) results ?Can you give me an example ?

[zhicwu]

How Can I get Array(Nullable(Int64)) results ?Can you give me an example ?

Below case works for me:

try (ClickHouseConnection conn = newConnection(new Properties());
        Statement stmt = conn.createStatement()) {
    ResultSet rs = stmt
            .executeQuery(
                    "select [null, 2, null]::Array(Nullable(UInt64))");
    Assert.assertTrue(rs.next());
    Assert.assertEquals(rs.getObject(1), new Long[] {null, 2L, null});
    Assert.assertEquals(rs.getArray(1).getArray(), new Long[] {null, 2L, null});
    Assert.assertFalse(rs.next());
}

[liumaojing]

How Can I get Array(Nullable(Int64)) results ?Can you give me an example ?

Below case works for me:

try (ClickHouseConnection conn = newConnection(new Properties());
        Statement stmt = conn.createStatement()) {
    ResultSet rs = stmt
            .executeQuery(
                    "select [null, 2, null]::Array(Nullable(UInt64))");
    Assert.assertTrue(rs.next());
    Assert.assertEquals(rs.getObject(1), new Long[] {null, 2L, null});
    Assert.assertEquals(rs.getArray(1).getArray(), new Long[] {null, 2L, null});
    Assert.assertFalse(rs.next());
}

Follow your example above,the error log is as follows:
OpenJDK 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended
2022-05-18 10:17:36:215 +0800 [main] WARN ClickHouseDriver - ******************************************************************************************
2022-05-18 10:17:36:220 +0800 [main] WARN ClickHouseDriver - * This driver is DEPRECATED. Please use [com.clickhouse.jdbc.ClickHouseDriver] instead. *
2022-05-18 10:17:36:220 +0800 [main] WARN ClickHouseDriver - * Also everything in package [ru.yandex.clickhouse] will be removed starting from 0.4.0. *
2022-05-18 10:17:36:220 +0800 [main] WARN ClickHouseDriver - ******************************************************************************************
Exception in thread "main" java.lang.AssertionError: expected:ru.yandex.clickhouse.ClickHouseArray@d41f816 but was:<[Ljava.lang.Long;@5c2375a9>
at org.junit.Assert.fail(Assert.java:89)
at org.junit.Assert.failNotEquals(Assert.java:835)
at org.junit.Assert.assertEquals(Assert.java:120)
at org.junit.Assert.assertEquals(Assert.java:146)
at ru.yandex.clickhouse.testconn.main(testconn.java:38)

[zhicwu]

2022-05-18 10:17:36:220 +0800 [main] WARN ClickHouseDriver - * This driver is DEPRECATED. Please use [com.clickhouse.jdbc.ClickHouseDriver] instead. *

Can you switch to the exact driver shown above? If you need to stay with the legacy driver(ru.yandex.*), you may try use_objects_in_arrays property to see if it will work or not.

[liumaojing]

2022-05-18 10:17:36:220 +0800 [main] WARN ClickHouseDriver - * 此驱动程序已弃用。请改用 [com.clickhouse.jdbc.ClickHouseDriver]。*

您可以切换到上面显示的确切驱动程序吗？如果您需要继续使用旧版驱动程序（ru.yandex.*），您可以尝试use_objects_in_arrays使用属性，看看它是否可以工作。

use_objects_in_arrays ==true doesn't take effect, change the driver was successful,but the null values are gone.The length of the array([null, 2L, null]) is 3, but the return value is 2,I don't think it makes sense,Will it improve in future releases?

[zhicwu]

The length of the array([null, 2L, null]) is 3, but the return value is 2

I cannot reproduce this issue. Are you saying above test case not working for you? Could you post a complete program for reproducing?