Status: Awaiting Feedback
Affects Version/s: 2.2.2
Fix Version/s: None
Security Level: All
Environment:Oracle Express 11g and doctrine-dbal 2.2.2
I want to update my schema but I am getting the following error message:
ORA-01442: column to be modified to NOT NULL is already NOT NULL
The current table structure looks like that:
|Column Name||Data Type||Nullable||Default||Primary Key|
I think there is a problem with the comparison between Oracles 'Date' type and the Metadata 'Date' type. I am used to use MySQL as DBMS but our customer uses Oracle. MySQL's 'datetime' and Oracle's 'date' type are store the same data.
I am not sure what should be done here. Because this could lead to confusion for all Oracle user.
Maybe there could be a request to the platform in the Schema Comparator here: