U++ forum: Welcome to the forum

Re: Some queries return incorrect datatypes with SqLite [message #55767 is a reply to message #55728]

Fri, 11 December 2020 14:55

mirek
Messages: 13980
Registered: November 2005

Ultimate Member

Alboni wrote on Thu, 03 December 2020 18:56

Hello, I see some issue with SqLite3 lately that didn't exist before.

They have to do with the datatype of the results of a query.

issue 1 : SqlMax(some time column) returns WSTRING_V result instead of TIME_V
issue 2 : Selecting a BOOL column also returns WSTRING_V result instead of BOOL_V

again, it only applies to SqLite, on MySql it works correctly

I enclosed an example

BOOL behaviour is as expected (BOOL in .sch is always emulated by text column to be consistent across all DBs).

With SqlMax it seems we are simply out of luck:

https://www.sqlite.org/c3ref/column_decltype.html

Impossible to do better there I am afraid Sad

Mirek

Report message to a moderator