SQLITE3: TSQLQuery fails when using Params for float data (aarch64)

[apeoperaio]

I have an issue when using TSQLQuery to insert float data in a table using Params (on aarch64).

I attached a sample project, where TSQLQuery simply execute an insert statement (works) and perform insert using Params (does not work).
In order to test it just replace
  dbfile:= 'yourfilename';
with your filename.

Is it a known issue?

Lazarus 2.2.7 (rev lazarus_2_2_6-1-gada7a90f86) FPC 3.2.2 aarch64-darwin-cocoa

[rvk]

I attached a sample project, where TSQLQuery simply execute an insert statement (works) and perform insert using Params (does not work).

What does "does not work" mean?
Do you get an error?
Or does it do nothing (no error, no messages) and add nothing?

BTW shouldn't you use a sqlq.Prepare; after assigning sqlq.SQL.Text and before sqlq.ExecSQL, to let the program know what parameters there are?

[apeoperaio]

It does not work in the sense that the float value is not inserted in the table.
When I use the SQL statement:

Code: Pascal  [Select][+][-]

1. sqlq.SQL.Text:= 'INSERT INTO DATA (int_value, float_value, str_value) values ("10", "1.3", "str1")';

I get 3 values in the table

10

1.3

str1

while when I use:

Code: Pascal  [Select][+][-]

1.     sqlq.SQL.Text:= 'INSERT INTO DATA (int_value, float_value, str_value) values (:int_value, :float_value, :str_value)';
2.     sqlq.Params.Items[0].AsInteger:= 9;
3.     sqlq.Params.Items[1].AsFloat:= 0.998;
4.     sqlq.Params.Items[2].AsString:= 'str2';
5.  

I get a table like:

9

0

str2

The float value (0.998) is not inserted, the value in the table is 0.

[apeoperaio]

I forgot to mention that, except from darwin aarch64, the code works for all other platforms (win x86_64, linux x86_64, darwin x86_64)

[rvk]

What happens if you do:

Code: Pascal  [Select][+][-]

1. sqlq.SQL.Text:= 'INSERT INTO DATA (int_value, float_value, str_value) values (10, 1.3, "str1")';
2. sqlq.Prepare;

Note that 10 and 1.3 aren't enclosed by quotes because they are not strings.

(I think sqlite does convert automatically but perhaps something goes wrong there)

Don't forget the prepare. It should be done automatically, but it can't hurt.

It the 10 and 1.3 are really added then too, then there must be something wrong with passing parameters.

[rvk]

It's a known problem...

Float Params don't work for SQLite. Probably only effect ARM
See https://gitlab.com/freepascal.org/fpc/source/-/issues/28140

Apparently you need to (re)compile FPC with  -Caeabihf options.

[apeoperaio]

Ok, it is a seven years old issue. Now closed, but the bug is still there. Will FPC change it in the future?

[rvk]

Ok, it is a seven years old issue. Now closed, but the bug is still there. Will FPC change it in the future?

It was not a bug (as I see it).
It was a compilation issue.

When FPC was recompiled with a certain switch, the problem went away.

I got it fpc compiled properly once I got all the make parameters right. It seems it boils down to that I thought OPT parameters for make where cumulative.
Thanks for your help. The bug can be closed.

I'm not sure why it was not done originally.

Maybe if you mention the OS, someone can take a look.
(I don't have aarch64, either Mac or Linux)

[apeoperaio]

I get this error only on darwin aarch, I edited my comment in gitlab.

Thank you.

[upsidasi]

Is there any chance for the property .AsFloat to work for AARCH64? I noticed the new comment on the bug report https://gitlab.com/freepascal.org/fpc/source/-/issues/28140, but its status is still "closed".

[Чебурашка]

It was not a bug (as I see it).
It was a compilation issue.

When FPC was recompiled with a certain switch, the problem went away.

From the perpective of any user of FPC this is a bug as the things don't work properly and do not allow a user program to work as expected and as works on a different platform, like OP says.