From 641f9cd46af4dc4364c1f4b150e808cdab3002e2 Mon Sep 17 00:00:00 2001
From: Miguel Grillo <miguel_grillo_orellana@hotmail.com>
Date: Tue, 22 Oct 2024 01:02:56 +0200
Subject: [PATCH] Add tests for Oracle tablespace specification in table
 definitions

This commit adds new tests to verify the correct handling of tablespace names in Oracle table definitions. The tests ensure that tablespace names are recognized correctly regardless of their case (uppercase, lowercase, mixed case).

Tests added:
- : Verifies that tablespace names are correctly included in the CREATE TABLE statement for different cases:
  - Uppercase tablespace name
  - Lowercase tablespace name
  - Mixed case tablespace name

These tests ensure that the  argument is handled correctly and that the generated SQL statements include the specified tablespace names as expected.
---
 test/dialect/oracle/test_compiler.py | 40 ++++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)

diff --git a/test/dialect/oracle/test_compiler.py b/test/dialect/oracle/test_compiler.py
index 972a02dad8..795fbccdfb 100644
--- a/test/dialect/oracle/test_compiler.py
+++ b/test/dialect/oracle/test_compiler.py
@@ -1659,6 +1659,46 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
             cast(column("foo"), d1), "CAST(foo AS DOUBLE PRECISION)"
         )
 
+    def test_table_tablespace(self):
+        m = MetaData()
+
+        t = Table(
+            "table1",
+            m,
+            Column("x", Integer),
+            oracle_tablespace='TEST_TABLESPACE',
+        )
+        t2 = Table(
+            "table2",
+            m,
+            Column("x", Integer),
+            oracle_tablespace='test_tablespace',
+        )
+        t3 = Table(
+            "table3",
+            m,
+            Column("x", Integer),
+            oracle_tablespace='TestTableSpace',
+        )
+        self.assert_compile(
+            schema.CreateTable(t),
+            "CREATE TABLE "
+            "table1 (x INTEGER) "
+            'TABLESPACE "TEST_TABLESPACE"',
+        )
+        self.assert_compile(
+            schema.CreateTable(t2),
+            "CREATE TABLE "
+            "table2 (x INTEGER) "
+            'TABLESPACE test_tablespace',
+        )
+        self.assert_compile(
+            schema.CreateTable(t3),
+            "CREATE TABLE "
+            "table3 (x INTEGER) "
+            'TABLESPACE "TestTableSpace"',
+        )
+
 
 class SequenceTest(fixtures.TestBase, AssertsCompiledSQL):
     def test_basic(self):
-- 
2.47.3