Overview

Request 498338 accepted

- Update to 3.19.2
* Fix a bug in the LEFT JOIN flattening optimization.
Ticket cad1ab4cb7b0fc.
* Fix more bugs in the LEFT JOIN flattening optimization.
Ticket 7fde638e94287d2c.

- Update to 3.19.0
* The SQLITE_READ authorizer callback is invoked once with a
column name that is an empty string for every table referenced
in a query from which no columns are extracted.
* When using an index on an expression, try to use expression
values already available in the index, rather than loading
the original columns and recomputing the expression.
* Enhance the flattening optimization so that it is able to
flatten views on the right-hand side of a LEFT JOIN.
* Use replace() instead of char() for escaping newline and
carriage-return characters embedded in strings in the .dump
output from the command-line shell.
* Avoid unnecessary foreign key processing in UPDATE statements
that do not touch the columns that are constrained by the
foreign keys.
* On a DISTINCT query that uses an index, try to skip ahead
to the next distinct entry using the index rather than
stepping through rows, when an appropriate index is available.
* Avoid unnecessary invalidation of sqlite3_blob handles
when making changes to unrelated tables.
* Transfer any terms of the HAVING clause that use only
columns mentioned in the GROUP BY clause over to the
WHERE clause for faster processing.
* Reuse the same materialization of a VIEW if that VIEW

Loading...
Request History
Ismail Dönmez's avatar

namtrac created request

- Update to 3.19.2
* Fix a bug in the LEFT JOIN flattening optimization.
Ticket cad1ab4cb7b0fc.
* Fix more bugs in the LEFT JOIN flattening optimization.
Ticket 7fde638e94287d2c.

- Update to 3.19.0
* The SQLITE_READ authorizer callback is invoked once with a
column name that is an empty string for every table referenced
in a query from which no columns are extracted.
* When using an index on an expression, try to use expression
values already available in the index, rather than loading
the original columns and recomputing the expression.
* Enhance the flattening optimization so that it is able to
flatten views on the right-hand side of a LEFT JOIN.
* Use replace() instead of char() for escaping newline and
carriage-return characters embedded in strings in the .dump
output from the command-line shell.
* Avoid unnecessary foreign key processing in UPDATE statements
that do not touch the columns that are constrained by the
foreign keys.
* On a DISTINCT query that uses an index, try to skip ahead
to the next distinct entry using the index rather than
stepping through rows, when an appropriate index is available.
* Avoid unnecessary invalidation of sqlite3_blob handles
when making changes to unrelated tables.
* Transfer any terms of the HAVING clause that use only
columns mentioned in the GROUP BY clause over to the
WHERE clause for faster processing.
* Reuse the same materialization of a VIEW if that VIEW


Factory Auto's avatar

factory-auto added factory-repo-checker as a reviewer

Please review build success


Factory Auto's avatar

factory-auto accepted review

Check script succeeded


Saul Goodman's avatar

licensedigger accepted review

ok


Staging Bot's avatar

staging-bot set openSUSE:Factory:Staging:H as a staging project

Being evaluated by staging project "openSUSE:Factory:Staging:H"


Staging Bot's avatar

staging-bot accepted review

Picked openSUSE:Factory:Staging:H


Factory Repo Checker's avatar

factory-repo-checker reopened review

can't install libvirt-daemon-vbox-3.3.0-649.4.x86_64:
package libvirt-daemon-vbox-3.3.0-649.4.x86_64 requires virtualbox < 5.2, but none of the providers can be installed
package virtualbox-5.1.22-1.10.x86_64 requires libQt5Core.so.5()(64bit), but none of the providers can be installed
package virtualbox-5.1.22-1.10.x86_64 requires libQt5Core.so.5(Qt_5)(64bit), but none of the providers can be installed
package virtualbox-5.1.22-1.10.x86_64 requires libQt5Core.so.5(Qt_5.7)(64bit), but none of the providers can be installed
nothing provides libicui18n.so.58.2()(64bit) needed by libQt5Core5-5.7.1-1.3.x86_64
nothing provides libicuuc.so.58.2()(64bit) needed by libQt5Core5-5.7.1-1.3.x86_64


Stephan Factory Kulow's avatar

coolo-factory changed priority to moderate => important

raising priority for openSUSE:Factory:Staging:H


Factory Repo Checker's avatar

factory-repo-checker accepted review

Builds for repo openSUSE:Factory:Staging:H/standard


Dominique Leuenberger's avatar

dimstar_suse accepted review

ready to accept


Dominique Leuenberger's avatar

dimstar_suse approved review

ready to accept


Dominique Leuenberger's avatar

dimstar_suse accepted request

Accept to openSUSE:Factory

openSUSE Build Service is sponsored by