is there a plan for sqlite3_changes() and sqlite3_total_changes() returning 64 bit values? SQLite supports far more rows than a signed 32 bit counter can store and I would feel more comfortable if I don't need to check for an overflow.
I do have tables with more than 2^32 rows. Of course one should avoid making that large transactions, but it is possible.
From: sqlite-users [mailto:[hidden email]] On Behalf Of Donald Griggs
Sent: Thursday, December 08, 2016 7:00 PM
To: SQLite mailing list
Subject: Re: [sqlite] sqlite3_changes() using 64 bit counters?
> The maximal number of rows is 1e+13 (<http://sqlite.org/limits.html>).
> I do have tables with more than 2^32 rows. Of course one should avoid
> making that large transactions, but it is possible.
It is my first time to know sqlite is used to store 2^32 rows data.