postgresql - Illuminate\Database\Schema\Builder::hasTable not honor to schema name

[boogiebug]

When I check for table existence on postgreSQL database, the builder query with the following statement:

select * from information_schema.tables where table_name = ?

Therefore, return as the table is existing if it is existed even in other schema. The better statement might be

select * from information_schema.tables where table_name = ? AND table_schema = ?

and pass the schema name as the second parameter.

[boogiebug]

Here's the 'Quick-fixes' I put into the code:

File: Illuminate\Database\Schema\Builder.php

public function hasTable($table)
{
  $sql = $this->grammar->compileTableExists();

  $table = $this->connection->getTablePrefix().$table;
  $schema = $this->connection->getConfig('schema'); // <-- add this line

  return count($this->connection->select($sql, [$table, $schema])) > 0; // <-- add $schema in to the array parameter
}

File: Illuminate\Database\Schema\Grammars\PostgresGrammar.php

public function compileTableExists()
{
    return 'select * from information_schema.tables where table_name = ? and table_schema = ?'; // <-- add 'and table_schema = ?'
}

[themsaid]

@GrahamCampbell this one was fixed here #13008

[GrahamCampbell]

Thanks. ;)