-
Notifications
You must be signed in to change notification settings - Fork 15
/
Copy patheunit.update.tst
133 lines (124 loc) · 10.3 KB
/
eunit.update.tst
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
%%-*- mode: erlang -*-
%%-*- coding: utf-8 -*-
% Test control options
[{tests, []}].
%% =============================================================================
%% TESTS: UPDATE
%% -----------------------------------------------------------------------------
% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% update_statement
% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
"Update :param_1 alias_1 Set column_1 = value_1".
"Update :param_1 Set column_1 = value_1".
"update :param_1 set column_1=value_1 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4".
"update :param_1 set column_1=value_1 where column_1".
"update :param_1 set column_1=value_1 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1 where current of cursor_1".
"update :param_1 set column_1=value_1".
"update :param_1 set column_1=value_1,column_2=value_2 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2 where current of cursor_1".
"update :param_1 set column_1=value_1,column_2=value_2".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1".
"update :param_1 set column_1=value_1,column_2=value_2,column_3=value_3".
"Update :param_1\"@link_1\" alias_1 Set column_1 = value_1".
"Update :param_1\"@link_1\" Set column_1 = value_1".
"Update \"^&()\" alias_1 Set column_1 = value_1".
"Update \"^&()\" Set column_1 = value_1".
"UPDATE abc set a='a', b='b\nb', c='c' || \"c\r\nc\" where a is NULL".
"UPDATE abc set a='a', b='b\nb', c='c' || \"c\r\nc\" where a || b = 'c' || 'd'".
"UPDATE employees set salary = :sal where employee_id = :id RETURNING c,d INTO :c, :d".
"UPDATE employees set salary = :sal where employee_id = :id RETURNING lob_column INTO :out_locator".
"UPDATE employees set salary = :sal where employee_id = :id".
"UPDATE name_table SET name_column_1 = :value_1 WHERE CURRENT OF name_cursor".
"UPDATE name_table SET name_column_1 = :value_1".
"UPDATE name_table SET name_column_1 = :value_1, name_column_2 = :value_2 WHERE CURRENT OF name_cursor".
"UPDATE name_table SET name_column_1 = :value_1, name_column_2 = :value_2 WHERE employee_id = :id".
"UPDATE name_table SET name_column_1 = :value_1, name_column_2 = :value_2".
"Update schema_1.table_1 alias_1 Set column_1 = value_1".
"Update schema_1.table_1 Set column_1 = value_1".
"Update schema_1.table_1\"@link_1\" alias_1 Set column_1 = value_1".
"Update schema_1.table_1\"@link_1\" Set column_1 = value_1".
"Update table_1 alias_1 Set column_1 = value_1".
"Update table_1 Set column_1 = value_1".
"update table_1 set column_1=value_1 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 where column_1 = column_2 and column_3 = column_4".
"update table_1 set column_1=value_1 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1 where current of cursor_1".
"update table_1 set column_1=value_1".
"update table_1 set column_1=value_1,column_2=value_2 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 where column_1 = column_2 and column_3 = column_4".
"update table_1 set column_1=value_1,column_2=value_2 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2 where current of cursor_1".
"update table_1 set column_1=value_1,column_2=value_2".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where column_1 = column_2 and column_3 = column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1 return column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1 returning column_1,column_2 into column_3,column_4".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3 where current of cursor_1".
"update table_1 set column_1=value_1,column_2=value_2,column_3=value_3".
"Update table_1\"@link_1\" alias_1 Set column_1 = value_1".
"Update table_1\"@link_1\" Set column_1 = value_1".
% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% table collection expression
% %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
"update table (column_1|:b|) set column_1 = value_1".
"update table (table_1.column_1|:b|) set column_1 = value_1".
"update table (schema_1.table_1.column_1|:b|) set column_1 = value_1".
"update table (column_1) set column_1 = value_1".
"update table (table_1.column_1) set column_1 = value_1".
"update table (schema_1.table_1.column_1) set column_1 = value_1".
"update table (column_1(+)) set column_1 = value_1".
"update table (table_1.column_1(+)) set column_1 = value_1".
"update table (schema_1.table_1.column_1(+)) set column_1 = value_1".
"update table (table_1.*) set column_1 = value_1".
"update table (schema_1.table_1.*) set column_1 = value_1".
"update table (schema_1.package_1.function_1(arg_1, arg_2)) set column_1 = value_1".
"update table (package_1.function_1(arg_1, arg_2)) set column_1 = value_1".
"update table (function_1(arg_1, arg_2)) set column_1 = value_1".
"update table (max) set column_1 = value_1".
"update table (max(arg_1, arg_2)) set column_1 = value_1".
"update table (max(*)) set column_1 = value_1".
"update table (max(distinct column_1)) set column_1 = value_1".
"update table (max(all column_1)) set column_1 = value_1".
"update table (schema_1.package_1.function_1(arg_1, arg_2)|:b[f(p:q)]|) set column_1 = value_1".
"update table (package_1.function_1(arg_1, arg_2)|:b[f(p:q)]|) set column_1 = value_1".
"update table (function_1(arg_1, arg_2)|:b[f(p:q)]|) set column_1 = value_1".
"update table (max|:b[f(p:q)]|) set column_1 = value_1".
"update table (max(arg_1, arg_2)|:b[f(p:q)]|) set column_1 = value_1".
"update table (max(*)|:b[f(p:q)]|) set column_1 = value_1".
"update table (max(distinct column_1)|:b[f(p:q)]|) set column_1 = value_1".
"update table (max(all column_1)|:b[f(p:q)]|) set column_1 = value_1".
"update table (select * from table_1) set column_1 = value_1".
"update table (select column_1, column_2 from table_1) set column_1 = value_1".
%% -----------------------------------------------------------------------------
%% TESTS: UPDATE
%% =============================================================================