summaryrefslogtreecommitdiff
path: root/test/dialect/oracle/test_compiler.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2021-01-21 11:15:06 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2021-01-21 11:15:06 -0500
commit851a3a362ee5e05b8438f92e2e1df63c68f79d68 (patch)
tree2d862d02a1369d1730d78c933e09b709d2ef8bf6 /test/dialect/oracle/test_compiler.py
parent05a31f2708590161d4b3b4c7ff65196c99b4a22b (diff)
downloadsqlalchemy-851a3a362ee5e05b8438f92e2e1df63c68f79d68.tar.gz
Revert "Implement support for functions as FROM with columns clause support"
This reverts commit 05a31f2708590161d4b3b4c7ff65196c99b4a22b. Atom has this little button called "push" and just pushes to master, I wasn't even *on* master. oops
Diffstat (limited to 'test/dialect/oracle/test_compiler.py')
-rw-r--r--test/dialect/oracle/test_compiler.py31
1 files changed, 0 insertions, 31 deletions
diff --git a/test/dialect/oracle/test_compiler.py b/test/dialect/oracle/test_compiler.py
index f12207d2b..f09346eb3 100644
--- a/test/dialect/oracle/test_compiler.py
+++ b/test/dialect/oracle/test_compiler.py
@@ -1481,34 +1481,3 @@ class RegexpTest(fixtures.TestBase, testing.AssertsCompiledSQL):
"REGEXP_REPLACE(mytable.myid, :myid_1, :myid_2, mytable.name)",
checkparams={"myid_1": "pattern", "myid_2": "replacement"},
)
-
-
-class TableValuedFunctionTest(fixtures.TestBase, testing.AssertsCompiledSQL):
- __dialect__ = "oracle"
-
- def test_scalar_alias_column(self):
- fn = func.scalar_strings(5)
- stmt = select(fn.alias().column)
- self.assert_compile(
- stmt,
- "SELECT COLUMN_VALUE anon_1 "
- "FROM TABLE (scalar_strings(:scalar_strings_1)) anon_1",
- )
-
- def test_column_valued(self):
- fn = func.scalar_strings(5)
- stmt = select(fn.column_valued())
- self.assert_compile(
- stmt,
- "SELECT COLUMN_VALUE anon_1 "
- "FROM TABLE (scalar_strings(:scalar_strings_1)) anon_1",
- )
-
- def test_table_valued(self):
- fn = func.three_pairs().table_valued("string1", "string2")
- stmt = select(fn.c.string1, fn.c.string2)
- self.assert_compile(
- stmt,
- "SELECT anon_1.string1, anon_1.string2 "
- "FROM TABLE (three_pairs()) anon_1",
- )