timeplus-io / proton

A stream processing engine and database, and a fast and lightweight alternative to ksqlDB and Apache Flink, 🚀 powered by ClickHouse
https://timeplus.com
Apache License 2.0
1.58k stars 69 forks source link

Fix multiIf in information_schema.tables #815

Closed jovezhong closed 3 months ago

jovezhong commented 3 months ago

I am working a seatunnel sink and it will check information_schema.tables

SELECT TABLE_NAME FROM information_schema.tables 
WHERE TABLE_CATALOG = 'internal' AND TABLE_SCHEMA = ? AND TABLE_NAME = ? 
ORDER BY TABLE_NAME

I hit error "Caused by: java.sql.BatchUpdateException: Code: 46. DB::Exception: Unknown function multiIf. Maybe you meant: ['multi_if','multiply']. (UNKNOWN_FUNCTION) (version 1.5.15)"

I guess there is an issue for the view definition.

image

PR checklist:

Please write user-readable short description of the changes: