BOOLEAN type not working with prepared statement.

Question

sumitsum opened this issue 3 years ago · 3 comments

A prepared statement of the following kind

select * from test_boolean_type where c_boolean=?

where ? is bound to string True. It returns incorrect result. It however works if integers 0 or 1 is supplied.

Tested with version 0.8.2

Answer 1 · 2021-09-16T07:11:16.000Z

Some mistake on my side. closing it.

Answer 2 · 2021-09-16T07:29:23.000Z

Re-opening post updating the description.

Answer 3 · 2021-10-09T12:53:50.000Z

Hi there, apologies for the late reply.

A string value cannot be a bool type, this should be a user error.

Use boolean true/false instead of a string value.