dbal icon indicating copy to clipboard operation
dbal copied to clipboard

MySQL: Schema Manager listTables() contains views

Open dmolineus opened this issue 2 years ago • 0 comments

Bug Report

Q A
Version 3.4.0

Summary

Since https://github.com/doctrine/dbal/commit/194c6eb7b78173fb8ae0ece8bc85be80d0364d89#diff-c2edb678105c04df1dd166e5a3553488b8084b7eca0cf34e8c0f96a512383fdd doctrine/dbal also list views as part of existing tables. I'm not sure how other platforms are affected by this change.

Current behaviour

The table information contains not only tables but also views.

How to reproduce

  1. Create an database containing a view
  2. Use MySQLSchemaManager::listTables()

Expected behaviour

The table list contains all tables but no views.

dmolineus avatar Aug 09 '22 12:08 dmolineus