Opened 8 years ago
Last modified 8 years ago
#29304 closed Bug
QuerySet.bulk_create() fails with "ORA-01790: expression must have same datatype as corresponding expression" — at Version 3
| Reported by: | isergey | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | 2.0 |
| Severity: | Normal | Keywords: | |
| Cc: | Mariusz Felisiak | Triage Stage: | Unreviewed |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description (last modified by )
I have two models:
class Record(models.Model):
hash = models.CharField(max_length=32)
source = models.ForeignKey(Source, on_delete=models.CASCADE)
create_date = models.DateTimeField(db_index=True)
update_date = models.DateTimeField(db_index=True)
deleted = models.BooleanField(default=False, db_index=True)
class RecordContent(models.Model):
record = models.OneToOneField(Record, primary_key=True, on_delete=models.CASCADE)
content = models.TextField(max_length=100 * 1024)
In MySQL this function works fine:
def _create_records(record_containers):
records = []
record_contents = []
for record_container in record_containers:
records.append(record_container['record'])
record_contents.append(record_container['content'])
models.Record.objects.bulk_create(records)
models.RecordContent.objects.bulk_create(record_contents) # in Oracle ORA-01790: expression must have same datatype as corresponding expression
But in Oracle this code thows exception: ORA-01790: expression must have same datatype as corresponding expression
If refactor the function _create_records:
def _create_records(record_containers):
for record_container in record_containers:
models.Record.objects.bulk_create([record_container['record']])
models.RecordContent.objects.bulk_create([record_container['content']])
there is no exception is thrown.
What happens?
Change History (3)
comment:1 by , 8 years ago
| Description: | modified (diff) |
|---|
comment:2 by , 8 years ago
| Description: | modified (diff) |
|---|
comment:3 by , 8 years ago
| Component: | Uncategorized → Database layer (models, ORM) |
|---|---|
| Description: | modified (diff) |
| Summary: | Bulk Create bug in ORACLE → QuerySet.bulk_create() fails with "ORA-01790: expression must have same datatype as corresponding expression" |
| Type: | Uncategorized → Bug |
Note:
See TracTickets
for help on using tickets.
What version of Django are you using? It might be a duplicate of #22669 (fixed in Django 2.0). If not, please try to minimize the code to reproduce the issue, including the data that causes the crash.