-
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.