-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Blocker
-
Affects Version/s: COmanage Registry 4.4.2 (Sparkling Summit MR2)
-
Component/s: Registry
The partition column name is a reserved key for the following databases:
Database Engine | Keyword "partition" Status | Notes |
---|---|---|
PostgreSQL | ✅ Reserved since version 10 | Native partitioning introduced in PostgreSQL 10 |
MySQL | ✅ Reserved since version 5.1 | Partitioning support introduced in MySQL 5.1 |
Oracle | ✅ Reserved since version 8.0 | Native partitioning introduced in Oracle 8 |
SQL Server | ✅ Reserved since SQL Server 2005 | Table partitioning introduced in SQL Server 2005 |
SQLite | ❌ *Not Reserved* | SQLite does not support native table partitioning |
IBM DB2 | ✅ Reserved | Native partitioning supported traditionally |
- Summary:
- Reserved or special: PostgreSQL, MySQL, Oracle Database, SQL Server, IBM DB2.
- Not reserved: SQLite.