id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux
19351 Two SQLite issues with bulk_insert akaariai akaariai "SQLite + bulk_insert has two issues:
1. If you insert objects with same values for all fields the objects will be collapsed.
2. If you insert more than 500 objects and the objects have just a single field a SQLite limit will be hit.
The first issue is technically a data-loss issue. However it isn't likely to be hit - it means you are inserting exactly similar objects in a same batch, and that isn't likely. A backpatch to 1.4 seems to be in place as the fix is trivial: use UNION ALL instead of UNION when constructing the insert query.
Patches available [https://github.com/akaariai/django/commit/c478979da80e52d458f544fa830ff8aa105d51e4 here] and [https://github.com/akaariai/django/commit/3628cc594de74800356412975b0020b1775cc708 here]." Bug closed Database layer (models, ORM) 1.4 Normal fixed sqlite bulk_insert Accepted 1 0 0 0 0 0