diff options
| author | Anssi Kääriäinen <akaariai@gmail.com> | 2012-11-24 00:28:20 +0200 |
|---|---|---|
| committer | Anssi Kääriäinen <akaariai@gmail.com> | 2012-11-24 01:28:25 +0200 |
| commit | c7dcb1d808597e0806fb352bb5ddc4b58c452f4c (patch) | |
| tree | 6bdee5c2692b3dcb6eefa60625a7b602e447856b /django | |
| parent | 9ee9a7265a76d435d886942ee431a216564d13f0 (diff) | |
[1.4.x] Fixed SQLite's collapsing of same-valued instances in bulk_create
SQLite used INSERT INTO tbl SELECT %s UNION SELECT %s, the problem
was that there should have been UNION ALL instead of UNION.
Refs #19351
Backpatch of a27582484cf814554907d2d1ad077852de36963f
Diffstat (limited to 'django')
| -rw-r--r-- | django/db/backends/sqlite3/base.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/django/db/backends/sqlite3/base.py b/django/db/backends/sqlite3/base.py index 2146a7fa8a..f31d2ab3eb 100644 --- a/django/db/backends/sqlite3/base.py +++ b/django/db/backends/sqlite3/base.py @@ -215,7 +215,7 @@ class DatabaseOperations(BaseDatabaseOperations): res.append("SELECT %s" % ", ".join( "%%s AS %s" % self.quote_name(f.column) for f in fields )) - res.extend(["UNION SELECT %s" % ", ".join(["%s"] * len(fields))] * (num_values - 1)) + res.extend(["UNION ALL SELECT %s" % ", ".join(["%s"] * len(fields))] * (num_values - 1)) return " ".join(res) class DatabaseWrapper(BaseDatabaseWrapper): |