Open sidebar
public function test2() { $param1 = 1; $param2 = 2; $tableA = \DB::table('childA') ->select(['*']) ->leftJoin('inventory', function($join) use ($param1) { $join->where('inventory.tenantId', '=', $param1); }); $tableB = \DB::table('childB') ->select(['*']) ->leftJoin('inventory', function($join) use ($param2) { $join->where('inventory.tenantId', '=', $param2); }); $tableA->union($tableB) ->orderBy('code'); $sql = $tableA->toSql(); $bindings = $tableA->getBindings(); $this->assertEquals(array(1, 2), $bindings); // $bindings = array(1), should be array(1, 2) }
Close sidebar
Back
Please note that all pasted data is publicly available.
X (fomerly Twitter)
GitHub
Use setting
Back
Please note that all pasted data is publicly available.
X (fomerly Twitter)
GitHub
Use setting