soci: `row::get()` overflows 32bit integer in internal representation (SQLite)
This is a continuation of #1185. The MWE remains the same:
#include <soci/soci.h>
#include <soci/sqlite3/soci-sqlite3.h>
#include <iostream>
int main() {
try {
// Create an in-memory SQLite database session
soci::session sql(soci::sqlite3, ":memory:");
sql << "CREATE TABLE test_table (id INTEGER PRIMARY KEY, myInt INTEGER);";
sql << "INSERT INTO test_table (myInt) VALUES (9223372036854775807);";
// This works
int64_t retrievedValue1;
sql << "SELECT myInt FROM test_table WHERE id = 1", soci::into(retrievedValue1);
std::cout << "Implicit retrieval: " << retrievedValue1 << std::endl;
// This throws std::bad_cast (windows) or overflows int32 for a -1 (linux)
soci::row r;
sql << "SELECT myInt FROM test_table WHERE id = 1", soci::into(r);
int64_t retrievedValue2 = r.get<int64_t>("myInt");
std::cout << "Explict 64-bit retrieval: " << retrievedValue2 << std::endl;
} catch (const std::exception& e) {
std::cerr << "Error: " << e.what() << std::endl;
}
return 0;
}
On current master this compiles fine, but the get function of the row object will return -1 (on Linux), which seems to suggest that internally SOCI is using a 32bit integer representation. However, this seems wrong as clearly SQLite can support 64bit integer values for INTEGER columns.
This is likely related to SQLite not really supporting data types. The docs describe the INTEGER type as
INTEGER. The value is a signed integer, stored in 0, 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 17 (17 by maintainers)
Commits related to this issue
- Make SQLite overwrite exchange type for integers Since SQLite doesn't have a type system, we have to always be prepared to select huge numbers, even if the "type" is e.g. int8. To do that, we overwri... — committed to Krzmbrzl/soci by Krzmbrzl 2 years ago
- Make SQLite overwrite exchange type for integers Since SQLite doesn't have a type system, we have to always be prepared to select huge numbers, even if the "type" is e.g. int8. To do that, we overwri... — committed to pthis/soci by Krzmbrzl 2 years ago
Took me longer to get to this, but here we go: #1217