QuerySet.bulk_create() crashes with Now() on Oracle.

[Mariusz Felisiak]

Now() cannot be used with QuerySet.bulk_create() as it uses CURRENT_TIMESTAMP which returns TIMESTAMP WITH TIME ZONE and crashes when wrapped with TO_TIMESTAMP, e.g.

tests/bulk_create/tests.py

@@ -10 +10 @@
     connection,
 )
 from django.db.models import FileField, Value
-from django.db.models.functions import Lower
+from django.db.models.functions import Lower, Now
 from django.test import (
     TestCase,
     override_settings,
@@ -300 +300 @@
         bbb = Restaurant.objects.filter(name="betty's beetroot bar")
         self.assertEqual(bbb.count(), 1)
 
+    @skipUnlessDBFeature("has_bulk_insert")
+    def test_bulk_insert_now(self):
+        NullableFields.objects.bulk_create(
+            [
+                NullableFields(datetime_field=Now()),
+                NullableFields(datetime_field=Now()),
+            ]
+        )
+        self.assertEqual(
+            NullableFields.objects.filter(datetime_field__isnull=False).count(),
+            2,
+        )
+
     @skipUnlessDBFeature("has_bulk_insert")
     def test_bulk_insert_nullable_fields(self):
         fk_to_auto_fields = {

crashes with:

django.db.utils.DatabaseError: ORA-01830: date format picture ends before converting entire input string

As far as I'm aware we can use LOCALTIMESTAMP instead (which return TIMESTAMP) because time zones are ignored on Oracle.

Noticed while checking ​https://github.com/django/django/pull/16092#issuecomment-1264633158

[GitHub <noreply@…>]

In 72a86ceb:

Fixed #34558 -- Fixed QuerySet.bulk_create() crash with Now() on Oracle.