U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSql does not handle BOOL correctly

Sun, 11 June 2023 17:12

omari
Messages: 276
Registered: March 2010

Experienced Member

Test case:

with this schema:

TABLE_(MY_TABLE)
   INT_   (ID) PRIMARY_KEY
   BOOL_  (IS_OK)
END_TABLE

this code:

SqlStatement s = Select(ID).From(MY_TABLE).WHERE(IS_OK == true);
LOG(s.Get(PGSQL));

print :

select ID from MY_TABLE where IS_OK = 1

PostgreSql does not accept this sql statement.

the correct one is:

select ID from MY_TABLE where IS_OK = '1'

regards
omari.

		PostgreSql does not handle BOOL correctly By: omari on Sun, 11 June 2023 17:12
		Re: PostgreSql does not handle BOOL correctly By: omari on Thu, 27 July 2023 16:09
		Re: PostgreSql does not handle BOOL correctly By: omari on Thu, 27 July 2023 16:15
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Wed, 04 October 2023 18:50
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Fri, 20 October 2023 09:41
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Fri, 20 October 2023 09:52
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Sat, 21 October 2023 00:33
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Sat, 21 October 2023 01:14
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Sat, 21 October 2023 17:22

Previous Topic:	SqlPerformScript bug: Not doing anything if script starts with "BEGIN;" and ends with "END;"
Next Topic:	Sqlite3 update

Goto Forum:

] [

]

Current Time: Sun Jun 01 11:40:11 CEST 2025

Total time taken to generate the page: 0.01495 seconds