ROUND function not working as expected

[joc-a]

Describe the bug ROUND function is not working as expected. More details below.

To Reproduce Run this in DataGrip with driver Xerial SQLiteJDBC v0.43.0.0

DROP TABLE IF EXISTS fakeTable;
CREATE TABLE IF NOT EXISTS fakeTable (id INTEGER PRIMARY KEY AUTOINCREMENT);
INSERT INTO fakeTable  DEFAULT VALUES;
SELECT ROUND(10.555, 2) FROM fakeTable;

Expected behaviour Expected result: 10.56. Actual result: 10.55

Logs If applicable, provide logs.

Environment (please complete the following information):

• OS: macOS
• CPU architecture: ARM64
• sqlite-jdbc version: 3.43.0.0

Additional context Tested using DataGrip with driver Xerial SQLiteJDBC v0.43.0.0

[gotson]

Not sure to understand, your issue doesn't mention or show any sqlite-jdbc code, only sqlite sql.

[joc-a]

Not sure to understand, your issue doesn't mention or show any sqlite-jdbc code, only sqlite sql.

@gotson Sorry, I added more info under Additional context.

[gotson]

Still doesn't explain what it has to do with the driver itself.

Do you get same results in sqlite cli?

[joc-a]

Apologies for jumping to the conclusion that there is a problem with the driver. It appears to be a problem with SQLite and someone has already reported it. Here is the comparison between the CLI results for v3.39.5 and v3.43.1.

vs