Query error in 5.0.2

[Pepe Pérez]

Hi,

I have a query that works fine in firebird 5.0.1 and earlier, but when i try to execute it in 5.0.2 i get the following error:

Conversion error from string "2025-04-10 19:#x10#x00#x08#x00#x00#x00#x00#x00#x98#xa6".

is it a bug of 5.0.2?

This is the query:

SELECT CAST(MAXVALUE(COALESCE((SELECT FIRST 1 FECHA FROM TABLE1

                     ORDER BY FECHA DESC), '1899/12/30'),
                     COALESCE((SELECT FIRST 1 FECHA FROM TABLE2
                     ORDER BY FECHA DESC), '1899/12/30'))
              AS TIMESTAMP) AS FECHA FROM rdb$database

Any solution?

-Pepe

[GSMAN GS]

año ???   ->   '1899/12/30'  --> 1899   or 1999???

Libre de virus.www.avast.com

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
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, visit https://groups.google.com/d/msgid/firebird-support/df08e8f6-f17d-4e9d-be20-e3a25772c7f8n%40googlegroups.com.

[Dimitry Sibiryakov]

Pepe Pérez wrote 09.05.2025 10:12:
> Any solution?

Update to a fresh snapshot. Most likely you hit
https://github.com/FirebirdSQL/firebird/issues/8440. If not - prepare a
reproducible test case.

--
WBR, SD.

[Pepe Pérez]

1899

With 1999 I get the same error

[Mark Rotteveel]

On 09/05/2025 10:12, Pepe Pérez wrote:
> Hi,
> I have a query that works fine in firebird 5.0.1 and earlier, but when i
> try to execute it in 5.0.2 i get the following error:

> /Conversion error from string "2025-04-10
> 19:#x10#x00#x08#x00#x00#x00#x00#x00#x98#xa6"./
> /
> /
> *is it a bug of 5.0.2?*

>
> This is the query:
> SELECT CAST(MAXVALUE(COALESCE((SELECT FIRST 1 FECHA FROM TABLE1
>                      ORDER BY FECHA DESC), '1899/12/30'),
>                      COALESCE((SELECT FIRST 1 FECHA FROM TABLE2
>                      ORDER BY FECHA DESC), '1899/12/30'))
>               AS TIMESTAMP) AS FECHA FROM rdb$database
>

> *Any solution?*

What is the datatype of fecha? Have you tried using `timestamp
'1899/12/30'` instead of just `'1899/12/30'`?

But as Dimitry says, please provide a reproducible example

Mark
--
Mark Rotteveel

[Pepe Pérez]

Confirmed. It is a bug of 5.0.2

I updated to a fresh snapshot 5.0.3.1653 and works fine

Thank you to  WBR, SD.