DB::transaction does not work when using DB::connection()

[hfmikep]

• Laravel Version: 5.4.#
• PHP Version: 7.1.5
• Database Driver & Version: MySQL 5.6.36

Description:

DB::transactions do not work when using DB::connection()

Steps To Reproduce:

Create a non-default config for a mysql database.

Attempt to run the following code:

 DB::beginTransaction();

    try {

        DB::connection('newdb')->table('users')->where('id', 2)->update(['status' => 'VALIDATED']);
        throw new \Exception('Some new exception');
        DB::commit();

    } catch ( Exception $ex ){

        DB::rollBack();
    
}

The DB transaction is immediately committed at the update statement and can not be rolled back.

[themsaid]

Start the transaction on the same connection your query will run on.

[hfmikep]

Duh... Thank you!

[happytodev]

@themsaid thank you very much. I think this specific point with multi database connections could be added in documentation.
Can I help for that @taylorotwell ?