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	Anssi Kääriäinen	Anssi Kääriäinen	"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