Opened 7 years ago
Last modified 7 years ago
#29304 closed Bug
Bulk Create bug in ORACLE — at Initial Version
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
I have to models
class Record(models.Model): id = models.CharField(primary_key=True, max_length=32) original_id = models.TextField(max_length=2048, blank=True) hash = models.CharField(max_length=32) source = models.ForeignKey(Source, on_delete=models.CASCADE) schema = models.CharField(max_length=32) session_id = models.BigIntegerField(default=0) 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)
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?
Note:
See TracTickets
for help on using tickets.