Overview
Request 1169661 accepted
- Update to release 3.45.3:
* Fix a long-standing bug (going back to version 3.24.0) that
might (rarely) cause the "old.*" values of an UPDATE trigger
to be incorrect if that trigger fires in response to an UPSERT.
* Reduce the scope of the NOT NULL strength reduction
optimization that was added as item 8e in version 3.35.0. The
optimization was being attempted in some contexts where it did
not work, resulting in incorrect query results.
- Add SQLITE_STRICT_SUBTYPE=1 as recommended by upstream.
Request History
rmax created request
- Update to release 3.45.3:
* Fix a long-standing bug (going back to version 3.24.0) that
might (rarely) cause the "old.*" values of an UPDATE trigger
to be incorrect if that trigger fires in response to an UPSERT.
* Reduce the scope of the NOT NULL strength reduction
optimization that was added as item 8e in version 3.35.0. The
optimization was being attempted in some contexts where it did
not work, resulting in incorrect query results.
- Add SQLITE_STRICT_SUBTYPE=1 as recommended by upstream.
factory-auto added opensuse-review-team as a reviewer
Please review sources
factory-auto accepted review
Check script succeeded
licensedigger accepted review
ok
anag+factory set openSUSE:Factory:Staging:H as a staging project
Being evaluated by staging project "openSUSE:Factory:Staging:H"
anag+factory accepted review
Picked "openSUSE:Factory:Staging:H"
darix accepted review
Accepted review for by_group opensuse-review-team request 1169661 from user anag+factory
anag+factory added factory-staging as a reviewer
Being evaluated by group "factory-staging"
anag+factory accepted review
Unstaged from project "openSUSE:Factory:Staging:H"
anag+factory set openSUSE:Factory:Staging:F as a staging project
Being evaluated by staging project "openSUSE:Factory:Staging:F"
anag+factory accepted review
Picked "openSUSE:Factory:Staging:F"
anag+factory added factory-staging as a reviewer
Being evaluated by group "factory-staging"
anag+factory accepted review
Unstaged from project "openSUSE:Factory:Staging:F"
anag+factory set openSUSE:Factory:Staging:J as a staging project
Being evaluated by staging project "openSUSE:Factory:Staging:J"
anag+factory accepted review
Picked "openSUSE:Factory:Staging:J"
anag+factory accepted review
Staging Project openSUSE:Factory:Staging:J got accepted.
anag+factory approved review
Staging Project openSUSE:Factory:Staging:J got accepted.
anag+factory accepted request
Staging Project openSUSE:Factory:Staging:J got accepted.
@dimstar
Makes nautilus test to fail: https://build.opensuse.org/package/live_build_log/openSUSE:Factory:Staging:F/nautilus/standard/x86_64
Are you sure the failure in nautilus is caused by this change to SQLite and not just a hickup? It looks like nautilus does not use SQLite directly, but maybe via other packages/libraries.
Yes, I think it's indirectly used by other library. You can't never be sure of anything related to software but the failure has appeared consistently 3-4 times already :)
My guess here would be tracker - which uses SQLite quite extensively and might trip over in the nautilus test suite
https://gitlab.gnome.org/GNOME/tracker/-/commit/0c576af6df5af2f1b8df9841fbb566fa52a4e382
I'll be preparing updates of tracker 3.7.2 which was released yesterday to address this