Refs #33355 -- Made trunc functions raise ValueError on invalid lookups on SQLite.

Co-Authored-By: Nick Pope <nick@nickpope.me.uk>

1 files changed, 21 insertions, 0 deletions

diff --git a/tests/backends/sqlite/test_functions.py b/tests/backends/sqlite/test_functions.py
new file mode 100644
index 0000000000..0659717799
--- /dev/null
+++ b/tests/backends/sqlite/test_functions.py
@@ -0,0 +1,21 @@
+from django.db.backends.sqlite3._functions import (
+    _sqlite_date_trunc, _sqlite_datetime_trunc, _sqlite_time_trunc,
+)
+from django.test import SimpleTestCase
+
+
+class FunctionTests(SimpleTestCase):
+    def test_sqlite_date_trunc(self):
+        msg = "Unsupported lookup type: 'unknown-lookup'"
+        with self.assertRaisesMessage(ValueError, msg):
+            _sqlite_date_trunc('unknown-lookup', '2005-08-11', None, None)
+
+    def test_sqlite_datetime_trunc(self):
+        msg = "Unsupported lookup type: 'unknown-lookup'"
+        with self.assertRaisesMessage(ValueError, msg):
+            _sqlite_datetime_trunc('unknown-lookup', '2005-08-11 1:00:00', None, None)
+
+    def test_sqlite_time_trunc(self):
+        msg = "Unsupported lookup type: 'unknown-lookup'"
+        with self.assertRaisesMessage(ValueError, msg):
+            _sqlite_time_trunc('unknown-lookup', '2005-08-11 1:00:00', None, None)