I am using the flathub version, though I do not know how to identify the actual version number from within the app. I did run flatpak update to ensure I am running the latest flatpak version.
I am using a sqlite3 database.
Create a table and populate it using the following statements:
create table test (my_int INTEGER, my_real REAL, my_text TEXT);
insert into test (my_int, my_real, my_text) values (NULL, NULL, NULL);
When looking at the contents of this table, the integer and real columns both display a value (0 and 0.0000 respectively). These are not actually the same as NULL. Running sqlite3 from the command line shows this same table as having nothing in these columns.
I am using the flathub version, though I do not know how to identify the actual version number from within the app. I did run flatpak update to ensure I am running the latest flatpak version.
I am using a sqlite3 database.
Create a table and populate it using the following statements:
When looking at the contents of this table, the integer and real columns both display a value (0 and 0.0000 respectively). These are not actually the same as NULL. Running sqlite3 from the command line shows this same table as having nothing in these columns.