SQLite Forum

ORDER BY not working for a specific DB/table
I don't think you can round the database, at least using sqlite command line

example: create a table with two numbers

      > sqlite3 myroundingtable.db

      SQLite version 3.29.0 2019-07-10 17:32:03
      Enter ".help" for usage hints.
      sqlite> create table mypar (one, second);

insert two rounded numbers

      sqlite> insert into mypar VALUES (round("30.1233198123987303101203",1), round("30.817232123312"));

query them, ok seems to be rounded

      sqlite> select * from mypar;
      sqlite> .q

but, then dumping

      > sqlite3 myroundingtable.db ".dump"
      PRAGMA foreign_keys=OFF;
      CREATE TABLE mypar (one, second);
      INSERT INTO mypar VALUES(30.10000000000000142,30.999999999999999999);

So, we asked sqlite to round and store two numbers, it says yes I do but it doesn't.

I am not asking for any fix, only pointing that it is an issue