Open timgraham opened 2 years ago
A queryset like:
Experiment.objects.annotate(shifted=ExpressionWrapper( F('completed') - Value(None, output_field=DurationField()), output_field=DateField(), ))
generates
SELECT ("experiment"."completed" - INTERVAL 'NULL MICROSECONDS') AS "shifted" FROM "experiment"
which fails with syntax error line 1 at position 0 unexpected 'NULL'.
syntax error line 1 at position 0 unexpected 'NULL'.
On other databases, interval math with a null interval results in NULL. Perhaps this could be fixed in Snowflake.
A queryset like:
generates
which fails with
syntax error line 1 at position 0 unexpected 'NULL'.On other databases, interval math with a null interval results in NULL. Perhaps this could be fixed in Snowflake.