Schema Tool keeps recreating table user when inside a schema in PostgreSQL

[ThomasLandauer]

Bug Report

Q	A
Version	4.2.3

Summary

With the following mapping:

#[ORM\Table(schema: 'my')]
class User

whenever I rerun bin/console make:migration, I'm getting:

$this->addSql('CREATE TABLE my."user" (...)');
$this->addSql('DROP TABLE my."user"');

This is apparently due to user being a reserved word in SQL (or PostgreSQL), and the escaping Doctrine applies (as discussed in various issues here).

When I remove the schema, it works as expected:

[WARNING] No database changes were detected.

Workaround:
Rename the table in the database:

#[ORM\Table(name: 'users', schema: 'my')]

Current behavior

Expected behavior

How to reproduce

[morozov]

Please try to reproduce this issue using the DBAL API.

[ThomasLandauer]

What is the DBAL API?

[morozov]

It's the classes, interface, etc. provided by the Doctrine DBAL library. Schema Tool is part of the ORM.

[ThomasLandauer]

Sorry, but there are so many schema related bugs filed here, that I didn't look elsewhere ;-)
So I now opened an issue at ORM: doctrine/orm#11898