From c72001644fa794b82fa88a7d2ecc20197b01b6f2 Mon Sep 17 00:00:00 2001 From: Nick Pope Date: Tue, 12 Dec 2023 16:07:31 +0000 Subject: Updated DatabaseFeatures.bare_select_suffix on Oracle 23c. https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/application-development.html#GUID-4EB70EB9-4EE3-4FE2-99C4-86F7AAC60F12 --- tests/backends/oracle/tests.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'tests') diff --git a/tests/backends/oracle/tests.py b/tests/backends/oracle/tests.py index 1ad98a88cf..a4aa26cd2e 100644 --- a/tests/backends/oracle/tests.py +++ b/tests/backends/oracle/tests.py @@ -43,8 +43,9 @@ class Tests(TestCase): An 'almost right' datetime works with configured NLS parameters (#18465). """ + suffix = connection.features.bare_select_suffix with connection.cursor() as cursor: - query = "select 1 from dual where '1936-12-29 00:00' < sysdate" + query = f"SELECT 1{suffix} WHERE '1936-12-29 00:00' < SYSDATE" # The query succeeds without errors - pre #18465 this # wasn't the case. cursor.execute(query) -- cgit v1.3