Bad cast from type DB::ColumnVector<short> to DB::ColumnVector<char8_t>

[chayaye]

Observed

I query this sql in clickhouse server, it is right.
however, when I use ClickHouse-go driver in my code to query the same sql, It will return error:
code: 49, message: Bad cast from type DB::ColumnVector to DB::ColumnVector<char8_t>

why?

Expected behaviour

Code example

SELECT
  *
FROM
  (
    SELECT
      CASE
        WHEN (test_name LIKE '%bob%')
        OR (test_name LIKE '%amy%') THEN 1
        WHEN (test_name LIKE '%mike%')
        OR (test_name LIKE '%jay%') THEN 2
        WHEN (test_name LIKE '%jane%') THEN 3
        WHEN (test_name LIKE '%tracy%') THEN 4
      END AS field_81000,
      CASE
        WHEN CAST('20240829' AS INT) <= CAST(
          concat(
            left(test_time, 4),
            right(left(test_time, 7), 2),
            right(left(test_time, 10), 2)
          ) AS INT
        )
        AND CAST('20240829' AS INT) >= CAST(
          concat(
            left(test_time, 4),
            right(left(test_time, 7), 2),
            right(left(test_time, 10), 2)
          ) AS INT
        ) THEN 1
        ELSE 0
      END AS field_50000,
      COUNT(DISTINCT(approval_id)) AS distinct__approval_id
    FROM
      (
        SELECT
          *
        FROM
          (
            SELECT
              ftime,
              id,
              approval_id,
              test_time,
              test_name
            FROM
              (
                SELECT
                  *
                FROM
                  testdb.testtable
                WHERE
                  (
                    ftime BETWEEN 20240829
                    AND 20240829
                  )
              ) AS t1
          ) AS sql1
        WHERE
          (
            ftime BETWEEN 20240829
            AND 20240829
          )
      ) AS sql2
    GROUP BY
      CASE
        WHEN (test_name LIKE '%bob%')
        OR (test_name LIKE '%amy%') THEN 1
        WHEN (test_name LIKE '%mike%')
        OR (test_name LIKE '%jay%') THEN 2
        WHEN (test_name LIKE '%jane%') THEN 3
        WHEN (test_name LIKE '%tracy%') THEN 4
      END,
      CASE
        WHEN CAST('20240829' AS INT) <= CAST(
          concat(
            left(test_time, 4),
            right(left(test_time, 7), 2),
            right(left(test_time, 10), 2)
          ) AS INT
        )
        AND CAST('20240829' AS INT) >= CAST(
          concat(
            left(test_time, 4),
            right(left(test_time, 7), 2),
            right(left(test_time, 10), 2)
          ) AS INT
        ) THEN 1
        ELSE 0
      END
  ) AS sql3
WHERE
  (field_50000 IN (1))
LIMIT
  1000

package code

// your code snippet here
db.QueryContext(ctx, sql)

Error log

{
	"Code": 49,
	"Name": "DB::Exception",
	"Message": "Bad cast from type DB::ColumnVector\u003cshort\u003e to DB::ColumnVector\u003cchar8_t\u003e",
	"StackTrace": "0. Poco::Exception::Exception(std::__1::basic_string\u003cchar, std::__1::char_traits\u003cchar\u003e, std::__1::allocator\u003cchar\u003e \u003e const\u0026, int) @ 0xeb0df8d in /usr/bin/clickhouse\n1. DB::Exception::Exception(std::__1::basic_string\u003cchar, std::__1::char_traits\u003cchar\u003e, std::__1::allocator\u003cchar\u003e \u003e const\u0026, int, bool) @ 0x44ef89a in /usr/bin/clickhouse\n2. std::__1::enable_if\u003cis_reference_v\u003cDB::ColumnVector\u003cchar8_t\u003e const\u0026\u003e, DB::ColumnVector\u003cchar8_t\u003e const\u0026\u003e::type typeid_cast\u003cDB::ColumnVector\u003cchar8_t\u003e const\u0026, DB::IColumn const\u003e(DB::IColumn const\u0026) @ 0x83180ea in /usr/bin/clickhouse\n3. DB::SerializationNumber\u003cchar8_t\u003e::serializeBinaryBulk(DB::IColumn const\u0026, DB::WriteBuffer\u0026, unsigned long, unsigned long) const @ 0xb1646df in /usr/bin/clickhouse\n4. DB::SerializationNullable::serializeBinaryBulkWithMultipleStreams(DB::IColumn const\u0026, unsigned long, unsigned long, DB::ISerialization::SerializeBinaryBulkSettings\u0026, std::__1::shared_ptr\u003cDB::ISerialization::SerializeBinaryBulkState\u003e\u0026) const @ 0xb15d495 in /usr/bin/clickhouse\n5. DB::NativeBlockOutputStream::write(DB::Block const\u0026) @ 0xbdae4ea in /usr/bin/clickhouse\n6. DB::TCPHandler::sendData(DB::Block const\u0026) @ 0xba5f7e0 in /usr/bin/clickhouse\n7. DB::TCPHandler::processOrdinaryQueryWithProcessors() @ 0xba6078d in /usr/bin/clickhouse\n8. DB::TCPHandler::runImpl() @ 0xba67c91 in /usr/bin/clickhouse\n9. DB::TCPHandler::run() @ 0xba68577 in /usr/bin/clickhouse\n10. Poco::Net::TCPServerConnection::start() @ 0xea6cf47 in /usr/bin/clickhouse\n11. Poco::Net::TCPServerDispatcher::run() @ 0xea6d55a in /usr/bin/clickhouse\n12. Poco::PooledThread::run() @ 0xeb7877e in /usr/bin/clickhouse\n13. Poco::ThreadImpl::runnableEntry(void*) @ 0xeb75cc9 in /usr/bin/clickhouse\n14. start_thread @ 0x94aa in /usr/lib64/libpthread-2.28.so\n15. __clone @ 0x1008c3 in /usr/lib64/libc-2.28.so\n"
}

Details

Environment

• clickhouse-go version: github.com/ClickHouse/clickhouse-go/v2 v2.13.0

• Interface: ClickHouse API / database/sql compatible driver

• Go version: go version go1.21.11

• Operating system: linux/amd64

• ClickHouse version: 21.8.12.29

• Is it a ClickHouse Cloud? yes

• Sample data for all these tables, use [clickhouse-obfuscator]

test_name | test_time | distinct__approval_id -- | -- | -- mike | 2023-05-06 16:12:34 | 1 | 2023-01-18 22:44:20 | 1

[jkaflik]

@chayaye could you share your table DDL? (structure)

[chayaye]

CREATE TABLE testdb.testtable
(
ftime Int64 COMMENT,
id Nullable(String) COMMENT,
approval_id Nullable(String),
test_time Nullable(String),
test_name Nullable(String),
)
ENGINE = Distributed('default_cluster', 'testdb_local', 'tesettable', rand())