我希望在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
暂无答案！
目前还没有任何答案，快来回答吧！