U++ framework: U++ SQL » Some queries return incorrect datatypes with SqLite

Home » U++ Library support » U++ SQL » Some queries return incorrect datatypes with SqLite

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Fri, 11 December 2020 14:55

mirek
Messages: 14291
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

[Message index]

		Some queries return incorrect datatypes with SqLite By: Alboni on Thu, 03 December 2020 18:56
		Re: Some queries return incorrect datatypes with SqLite By: mirek on Fri, 11 December 2020 14:55
		Re: Some queries return incorrect datatypes with SqLite By: Alboni on Fri, 11 December 2020 15:17
		Re: Some queries return incorrect datatypes with SqLite By: mirek on Fri, 11 December 2020 15:42
		Re: Some queries return incorrect datatypes with SqLite By: Alboni on Fri, 11 December 2020 16:43

Previous Topic:	libpq-fe.h in Alpine Linux
Next Topic:	MySqlSession Close and Reconnect crashes Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Sep 06 22:25:46 GMT+2 2026

Total time taken to generate the page: 0.00850 seconds