Queries Being Built Incorrectly

RugerSR9's profile image RugerSR9 posted 5 years ago in General Permalink

HeidiSQL is building queries incorrectly resulting in / SQL Error (102): Incorrect syntax near '0'. /.

Example: "EmailConfirmed"=b'0' AND "LockoutEnabled"=b'1'

Not sure why there are "b"'s after the equal sign, but it puts them there anytime the field is of type BIT.

I started having issues yesterday, updated to 10.1.0.5559 but that didn't solve the issue.

ansgar's profile image ansgar posted 5 years ago Permalink

Which server version and type is it?

RugerSR9's profile image RugerSR9 posted 5 years ago Permalink

SQL Server and 2012 (I believe), will confirm on Monday.

ansgar's profile image ansgar posted 5 years ago Permalink

That b'' notation is working for MySQL and MariaDB, but I suppose not for MSSQL and neither PostgreSQL. You should search the bug tracker for a relevant issue report, and star this issue then.

web3dprint's profile image web3dprint posted 3 years ago Permalink

Which would be issue #264 on github HeidiSQL/HeidiSQL

Please login to leave a reply, or register at first.