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
29304	"QuerySet.bulk_create() fails with ""ORA-01790: expression must have same datatype as corresponding expression"""	isergey	nobody	"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?

"	Bug	closed	Database layer (models, ORM)	2.0	Normal	duplicate		Mariusz Felisiak	Unreviewed	0	0	0	0	0	0