#35295 closed Cleanup/optimization (wontfix)
Use INSERT with multiple rows on Oracle 23c+
Reported by: | Mariusz Felisiak | Owned by: | Mariusz Felisiak |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 5.0 |
Severity: | Normal | Keywords: | oracle |
Cc: | Triage Stage: | Accepted | |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Oracle 23c finally allows to INSERT
multiple rows into a table in a single step without a UNION
-SELECT
workaround 🎉
https://oracle-base.com/articles/23c/table-values-constructor-23c#insert
Change History (10)
comment:1 by , 8 months ago
Has patch: | set |
---|
comment:2 by , 8 months ago
Triage Stage: | Unreviewed → Accepted |
---|
comment:3 by , 8 months ago
Patch needs improvement: | set |
---|
The current patch fails on field_defaults.tests.DefaultTests.test_bulk_create_mixed_db_defaults_function
:
django.db.utils.DatabaseError: ORA-01797: this operator must be followed by ANY or ALL
comment:5 by , 8 months ago
Patch needs improvement: | unset |
---|
Note:
See TracTickets
for help on using tickets.
PR