-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
Oracle 23c is planned to end beta and go into GA sometime around February 2023, so it would be a cool new feature to add to Debezium 2.2 in Q1 2023.
Some highlights for Oracle 23c include:
- SELECT without FROM, i.e. SELECT 2*3; (
DBZ-7505) Using column aliases in GROUP BY and HAVING clauses(checked against current grammar and aliases get treated as expressions, which is sufficient for our purposes).- Existence testing in DDL, i.e. CREATE TABLE tab IF NOT EXIST ... (
DBZ-7498) - Table Value Constructors
- New RETURNING keyword to get old/new values
- New error messages to explain SQL failures better
- Database object annotations - CREATE/ALTER TABLE (
DBZ-7506) - New developer role
- Javascript-based store procedure support
- New SQL domain types support
- Ability to issue updates against a table with a join condition
- Schema-level permissions
- JSON schema validation support
- Define 4096 columns per table, like woah???
- New BOOLEAN data type
- Oracle RAC support on K8s
https://www.oracle.com/database/23c/#interval-data-type-aggregations
There are no Sub-Tasks for this issue.