News

Laravel 5.7.17 Released

Published
Laravel 5.7.17 Released image

Release updates

Never miss a Laravel release

Get an email whenever a new Laravel release lands.

Laravel 5.7.17 is available with new query builder methods, a new message for detecting lost connections in MariaDB, and improvements to adding foreign keys in Postgres.

First, we have a new method in the query builder for the INSERT INTO SELECT statement, without loading data into memory. The insertUsing() method allows you to copy all (or some) columns from one database table to another using the following syntax:

$builder->from('table1')->insertUsing(
    ['foo'],
    function (Builder $query) {
        $query->select(['bar'])->from('table2')->where('foreign_id', '=', 5);
    }
);

An example of the SQL INSERT INTO SELECT Statement might look like this:

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

Next, the query builder has a new havingBetween method for the SQL HAVING clause between two values:

$builder
    ->select('*')
    ->from('users')
    ->havingBetween('last_login_date', ['2018-11-16', '2018-12-16']);

Which produces the following query:

select * from "users" having "last_login_date" between ? and ?

The next feature is not as glamorous but under the hood of the DetectsLostConnections database trait, the new message “Packets out of order. Expected”. In MariaDB, exceptions like “Packets out of order. Expected 1 received 0. Packet size=30” can have an “Expected” value of more than one, so this message matches the various error messages for the “Packets out of order” exception.

The last new feature in Laravel 5.7.17 is another “behind the scenes” contribution which adds a “not valid” option for skipping validation when adding Postgres foreign keys.

According to Pull Request #26775 description of this feature:

Adding a foreign index to a Postgres table requires an exclusive access lock on the table as Postgres validates the existing data. This can be a lengthy check, and in our case lead to the lock queue spinning out of control.

“not valid”, tells Postgres to skip this data validation and therefore it doesn’t require an exclusive lock.

You can see the full list of fixes below, and the full diff between 5.7.16 and 5.7.17 on GitHub. The full release notes for Laravel 5.7 are available in the GitHub 5.7 changelog:

v5.7.17

Added

  • Added Database\Query\Builder::insertUsing method (#26732, 8216b46)
  • Added Database\Query\Builder::havingBetween method (#26758)
  • Added Packets out of order. Expected string to DetectsLostConnections trait (#26760)
  • Added NOT VALID option for skipping validation when adding postgres foreign keys (#26775)

Fixed

  • Fixed: Using store on an uploaded file when you push an empty file (#26809)
  • Fixed hiding for hidden commands (#26781)
Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Sponsored

laravelcloud logo
Laravel Cloud

Easily create and manage your servers and deploy your Laravel applications in seconds.

Visit Laravel Cloud

The latest

View all →
Laravel AI SDK 1.4 Lets Agents Recover From Tool Failures image

Laravel AI SDK 1.4 Lets Agents Recover From Tool Failures

Read article
Laravel Read Replicas: Check if a Replica Has Caught Up image

Laravel Read Replicas: Check if a Replica Has Caught Up

Read article
UUID Request Input and Migration Failure Events in Laravel 13.42 image

UUID Request Input and Migration Failure Events in Laravel 13.42

Read article
Replay Missed Laravel Scheduled Tasks With Schedule Catchup image

Replay Missed Laravel Scheduled Tasks With Schedule Catchup

Read article
Search Polymorphic Relations and Filament Tables With Laravel Searchable image

Search Polymorphic Relations and Filament Tables With Laravel Searchable

Read article
Laravel Rest Api 3.0: Typed Fields, Metrics, and OpenAPI Docs image

Laravel Rest Api 3.0: Typed Fields, Metrics, and OpenAPI Docs

Read article