bug: error when use '1' with int column

[coffeecms]

Search before asking

• I had searched in the issues and found no similar issues.

Version

When use '1' with int column, databend will return error not match data type of column.

It's mean databend not allow use ' char with int column like: where id='1'
And only allow: where id=1

But it's working with others data warehouse like : StarRocks, Doris, Mysql, Mariadb

If databend allow use ' char with int column, it's mean databend can integrate with many working systems like: Wordpress and other PHP scripts...

What's Wrong?

databend not allow use ' char with int column like: where id='1'
And only allow: where id=1

But it's working with others data warehouse like : StarRocks, Doris, Mysql, Mariadb

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!