`OracleSchemaManager::dropTable` does not drop AI sequence if AI trigger is not present

doctrine / dbal

Doctrine Database Abstraction Layer

https://www.doctrine-project.org/projects/dbal.html

MIT License

9.4k stars 1.33k forks source link

`OracleSchemaManager::dropTable` does not drop AI sequence if AI trigger is not present #4997

Open mvorisek opened 2 years ago

mvorisek commented 2 years ago

Bug Report

Q	A
BC Break	no
Version	3.1.4

Summary & Current behaviour

OracleSchemaManager::dropTable does not drop AI sequence if AI trigger is not present

How to reproduce

create Oracle table using standard Oracle DBAL schema/platform manager and drop created AI trigger - this state is present when table create or crop table did not complete previously

Expected behaviour

AI sequence is dropped no matter if AI trigger is present

morozov commented 2 years ago

Looks similar to https://github.com/doctrine/dbal/issues/4745. ~~Both behaviors seem intended but are in fact bugs.~~ No, this one is just a bug that the platform doesn't handle the failure of DROP TRIGGER if there's no trigger.