summaryrefslogtreecommitdiffstats
path: root/debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc
diff options
context:
space:
mode:
Diffstat (limited to 'debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc')
-rw-r--r--debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc17
1 files changed, 17 insertions, 0 deletions
diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc
new file mode 100644
index 00000000..5514ff31
--- /dev/null
+++ b/debian/uncrustify-trinity/uncrustify-trinity-0.74.0/tests/input/sql/issue_527.sqc
@@ -0,0 +1,17 @@
+void myfunc1()
+{
+ EXEC SQL create or replace
+ function my_func (in_str IN varchar2)
+ return date
+ IS
+ x date;
+ BEGIN
+ IF in_str IS NULL THEN
+ x: = NULL;
+ ELSIF substr(in_str, 5, 1) = '-' THEN
+ x := to_date(in_str, 'YYYY-MM-DD HH24:MI:SS');
+ END IF;
+ return x;
+ END my_func;
+ END-EXEC;
+}