summaryrefslogtreecommitdiff
path: root/src/pl/plpython/plpython_test.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/pl/plpython/plpython_test.sql')
-rw-r--r--src/pl/plpython/plpython_test.sql63
1 files changed, 0 insertions, 63 deletions
diff --git a/src/pl/plpython/plpython_test.sql b/src/pl/plpython/plpython_test.sql
deleted file mode 100644
index c78b4aa0c7f..00000000000
--- a/src/pl/plpython/plpython_test.sql
+++ /dev/null
@@ -1,63 +0,0 @@
--- first some tests of basic functionality
---
--- better succeed
---
-select stupid();
-
--- check static and global data
---
-SELECT static_test();
-SELECT static_test();
-SELECT global_test_one();
-SELECT global_test_two();
-
--- import python modules
---
-SELECT import_fail();
-SELECT import_succeed();
-
--- test import and simple argument handling
---
-SELECT import_test_one('sha hash of this string');
-
--- test import and tuple argument handling
---
-select import_test_two(users) from users where fname = 'willem';
-
--- test multiple arguments
---
-select argument_test_one(users, fname, lname) from users where lname = 'doe' order by 1;
-
-
--- spi and nested calls
---
-select nested_call_one('pass this along');
-select spi_prepared_plan_test_one('doe');
-select spi_prepared_plan_test_one('smith');
-select spi_prepared_plan_test_nested('smith');
-
--- quick peek at the table
---
-SELECT * FROM users;
-
--- should fail
---
-UPDATE users SET fname = 'william' WHERE fname = 'willem';
-
--- should modify william to willem and create username
---
-INSERT INTO users (fname, lname) VALUES ('william', 'smith');
-INSERT INTO users (fname, lname, username) VALUES ('charles', 'darwin', 'beagle');
-
-SELECT * FROM users;
-
-
-SELECT join_sequences(sequences) FROM sequences;
-SELECT join_sequences(sequences) FROM sequences
- WHERE join_sequences(sequences) ~* '^A';
-SELECT join_sequences(sequences) FROM sequences
- WHERE join_sequences(sequences) ~* '^B';
-
--- error in trigger
---
-