summaryrefslogtreecommitdiffstats
path: root/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc
diff options
context:
space:
mode:
Diffstat (limited to 'debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc')
-rw-r--r--debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc18
1 files changed, 18 insertions, 0 deletions
diff --git a/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc b/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc
new file mode 100644
index 00000000..17ccfa3b
--- /dev/null
+++ b/debian/uncrustify-trinity/uncrustify-trinity-0.78.1/tests/expected/sql/02402-issue_527.sqc
@@ -0,0 +1,18 @@
+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;
+}