#22669: bulk_create with empty model fields fails on oracle
-------------------------------------+-------------------------------------
Reporter: sns1081@… | Owner: mnach
Type: Bug | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
QuerySet.bulk_create |
Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by mnach):
Hi all!
I need a review! It's first time I did a pull request to django, sorry if
I missed something..
Tested in Oracle 12c Enterprise Edition Release 12.1.0.2.0. Thanks to
[wiki:OracleTestSetup]!
----
I replace ''single_table_insert'' clause to ''multi_table_insert'' in
terms used in
[http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9014.htm#i2121671|
oracle documentation] because it is more efficient acording to execution
plan
''single_table_insert''
[[Image(ticket:22669:"Screenshot from 2016-04-15 18:15:04.png")]]
''multi_table_insert''
[[Image(ticket:22669:"Screenshot from 2016-04-15 18:13:22.png")]]
but solution suggested by @sns1081 also works, and I am ready to do
another PR if this will be better for future purposes
--
Ticket URL: <https://code.djangoproject.com/ticket/22669#comment:7>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/075.34c90c1123be8599cde3df0e43ef3f22%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
