Firebird different number datatype between constant or variable usage

[the-blazing-dev]

Hello together and thank you for providing this great LinqPad driver!

I have an issue with querying the Firebird database. To verify if the data in my table is correct I did some calculation where I calculate minutes / 60.0 * hourlyRate.
Depending on whether I hardcode the value 60.0 or use a variable defined earlier I get different SQL queries and different result data.

Here is the wrong behavior using the hardcoded / const value:

Here is the right behavior using a SQL variable:

What I would expect:
If the hardcoded value is of type double/float, it should be used with the sql-related floating point datatype in the query.

Or is this somehow expected behavior?

Thanks in advance!

Used LinqPad version: v8.2.4 (X64)
Used Driver version: v5.2.2

[MaceWindu]

Thanks, I will transfer this issue to linq2db as it is provider issue

[MaceWindu]

We should always generate double literals for double/float values. E.g. for case above it should be 60e0 or CAST(60 AS DOUBLE PRECISION)

https://firebirdsql.org/file/documentation/chunk/en/refdocs/fblangref40/fblangref40-commons.html#fblangref40-commons-number-constant