Strange issue With Qt

[Piergiorgio Valli]

Hello

I use Qt with Firebird 5.0, I would like a total with 8 decimal and 

It works if I use 4 decimal

DROP TABLE PRODUCT3;

CREATE TABLE product3 (

id INT PRIMARY KEY,

total DECIMAL(10,4) -- Example: 10 digits with 2 decimal places

);

INSERT INTO product3(id,total) values(1,40001.1234);

SELECT SUM(total) FROM product3

The sum return 40001.1234

Instead if I increase decimals, the record  is inserted,but the query with sum return no records

CREATE TABLE product3 (

id INT PRIMARY KEY,

total DECIMAL(14,8) -- Example: 10 digits with 2 decimal places

);

INSERT INTO product3(id,total) values(1,40001.1234);

SELECT SUM(total) FROM product3

Have you the same issue?

Thanks

[Ertan Küçükoglu]

Hi,

Both of your example comments are wrong.

DECIMAL(10,4) -> 123456.7890

Above is 10 digits 4 decimal places.

DECIMAL(14,8) -> 123456.78901234

Above is 14 digits and 8 decimal places.

I tested on v5.0.0.1306 and both works for me and there is the same result for both.

You may want to run just the sum statement alone depending on the tool you are using.

Thanks & Regards,

Ertan

Piergiorgio Valli <pier...@gmail.com>, 19 Nis 2024 Cum, 10:13 tarihinde şunu yazdı:

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/776481bc-014a-4785-9d31-0752bbb36295n%40googlegroups.com.

[Piergiorgio Valli]

Hi Ertan,

I am going to do an "hello sum" example so I can test only sum without additionatio features.

Thanks

For the response.

Pier

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAH2i4yckDNte_Rn2JbnHO8TbR64oiBLPrSEeUu%2BWQix68iroSw%40mail.gmail.com.

[Piergiorgio Valli]

Hi Ertan

It is a bug with driver of Qt,the query works with external tools.

Thanks for replay

Pier

[AlexPeshkoff]

Sooner of all that's something related with returned datatype - int128, which is probably not known to 3-d party driver.

Try

set bind of int128 to bigint;

before

SELECT SUM(total) FROM product3;

пятница, 19 апреля 2024 г. в 10:13:44 UTC+3, pier...@gmail.com:

[Piergiorgio Valli]

Hi AlexPeshkoff ,

thanks for comment, yes in the Qt driver for 5.15  int128 is not supported I checked the driver.

case SQL_INT128 

Pier

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/5f33036d-90f5-4ca4-a2c6-a2ffe2f61d1an%40googlegroups.com.

[Piergiorgio Valli]

Hi ,

thanks, I opened a ticket for Qt, it is fixed in a very short time.

Pier

[liviuslivius]

Or simply set compatibility settings in Firebird.conf or use SET BIND.

Regards,

Karol Bieniaszewski

-------- Oryginalna wiadomość --------

Od: Piergiorgio Valli <pier...@gmail.com>

Data: 21.04.2024 08:18 (GMT+01:00)

Do: firebird...@googlegroups.com

Temat: Re: [firebird-support] Re: Strange issue With Qt

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CALJ6nyyCKQoTNAA9Efw%2BEx9Q2O4rjJP%3Dh-BVEnh1tTpH8iTYnA%40mail.gmail.com.

[Mark Rotteveel]

On 21/04/2024 11:29, 'liviuslivius' via firebird-support wrote:
> Or simply set compatibility settings in Firebird.conf or use SET BIND.

That workaround was already suggested by Alex, but it is not a solution,
only a workaround. Getting supported added to the driver you use is the
real solution.

Mark
--
Mark Rotteveel

[Piergiorgio Valli]

Hi,

I have already manually fixed the driver and rebuilt it. it works correctly. 

Thanks

Pier