Notes for u1db-qt - reproducible builds result

Version annotated: 0.1.8-1
Identified issues:
Identifier: timestamps_in_qhc
URL https://wiki.debian.org/ReproducibleBuilds/TimestampsInDatabaseGeneratedByQhelpgenerator
Description There has been done a lot of reproducible fixes in 5.5.0, so it is worth to
wait entering this version sid before retrying.
.
qhelpgenerator inserts a timestamp into documentation (qhc) files,
which are sqlite3 databases. The timestamp used now respects
SOURCE_DATE_EPOCH, but is still affected by timezone.
.
https://codesearch.debian.net/search?q=Q_UNLIKELY.*SOURCE_DATE_EPOCH&literal=0
.
sqlite3 databases appear to be reproducible in themselves, but qhelp
generator is using various file IDs which become non-deterministic due to
map access. For example
.
https://sources.debian.net/src/qt4-x11/latest/tools/assistant/lib/qhelpgenerator.cpp/?hl=742#L742
.
I suspect we just need a few sorts (and some time to build qt4-x11...)
.
Also
.
https://sources.debian.org/src/qttools-opensource-src/latest/src/assistant/help/qhelpcollectionhandler.cpp/?hl=1639#L1639
.
debian bug https://bugs.debian.org/875847
.
upstream bug https://bugreports.qt.io/browse/QTBUG-62697
 

Our notes about issues affecting packages are stored in notes.git and are targeted at packages in Debian in 'unstable/amd64' (unless they say otherwise).