#17788: bulk_create() "too many SQL variables" error -------------------------------------+------------------------------------- Reporter: alpar | Owner: nobody Type: Bug | Status: new Component: Database layer | Version: (models, ORM) | 1.4-beta-1 Severity: Normal | Resolution: Keywords: | Triage Stage: Accepted Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+-------------------------------------
Comment (by alpar): Replying to [comment:4 akaariai]: > The above is a bit theoretical. I don't think that change will get accepted for 1.4, and after that it will be backwards incompatible change. It would be very sad. I think `bulk_create()` is pretty much unusable (for being unsafe to use) right now. I don't see any reasonable way of handling this issue at user level. If nothing changes until the release, at least the following warning should be added the the doc of bulk_create(). '''WARNING'''. This function crashes if you try to create more than a certain number of objects. This number depends on the database backend, and also on the number of fields in the object. In short: '''don't use this function.''' > I don't think there is any possibility to get the above into 1.4. There is just too little time to fine-tune all the details (transaction handling etc). In addition the above is a new feature. The solution you propose may be considered a new feature, but the problem itself is a bug. As far as the `bulk_create()` functionality is concerned, this is pretty much a critical one. -- Ticket URL: <https://code.djangoproject.com/ticket/17788#comment:5> 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 post to this group, send email to django-updates@googlegroups.com. To unsubscribe from this group, send email to django-updates+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-updates?hl=en.