我希望在clickhouse中构建一个sql,如下所示
SELECT *
FROM Student
WHERE (:fname IS NULL OR FirstName = :fname)
AND (:laname IS NULL OR LastName = :lname)
但经历了一个例外 DB::Exception: Cannot compare std::string with DB::Null
我希望在clickhouse中构建一个sql,如下所示
SELECT *
FROM Student
WHERE (:fname IS NULL OR FirstName = :fname)
AND (:laname IS NULL OR LastName = :lname)
但经历了一个例外 DB::Exception: Cannot compare std::string with DB::Null
暂无答案!
目前还没有任何答案,快来回答吧!