@djbrout noticed that long integers were being corrupted on upload to the DESDM DB (specifically the SOURCE_ID column of kadrlica.GAIA_DR2_X_DES_DR1). I think that NUMBER(20,0) is long enough to hold these integers (though someone should check that here), and I've confirmed that the full values are being stored as i8 on disk. Somewhere between disk and database the numbers are being truncated in the last 4 digits (5049751899273284480 on disk is being changed into 5049751899273280000 in the DB).
@djbrout noticed that long integers were being corrupted on upload to the DESDM DB (specifically the
SOURCE_IDcolumn ofkadrlica.GAIA_DR2_X_DES_DR1). I think that NUMBER(20,0) is long enough to hold these integers (though someone should check that here), and I've confirmed that the full values are being stored asi8on disk. Somewhere between disk and database the numbers are being truncated in the last 4 digits (5049751899273284480on disk is being changed into5049751899273280000in the DB).