Debian Codegraph @

src/interfaces/ecpg/test/expected/sql-prepareas.stdout

raw
1 +++++ Test for prepnormal +++++
2 insert into test values(:ivar1,:ivar2)
3 1 2
4 +++++ Test for execute immediate +++++
5 execute immediate "insert into test values(1,2)"
6 1 2
7 +++++ Test for PREPARE ident FROM CString +++++
8 prepare ident_name from "insert into test values(?,?)"
9 execute ident_name using :ivar1,:ivar2
10 1 2
11 +++++ Test for PREPARE char_variable_normal_name FROM char_variable +++++
12 prepare :v_normal_name from :v_query
13 execute :v_normal_name using :ivar1,:ivar2
14 1 2
15 +++++ Test for PREPARE char_variable_inc_dq_name FROM char_variable +++++
16 prepare :v_include_dq_name from :v_query
17 execute :v_include_dq_name using :ivar1,:ivar2
18 1 2
19 +++++ Test for PREPARE char_variable_inc_ws_name FROM char_variable +++++
20 prepare :v_include_ws_name from :v_query
21 execute :v_include_ws_name using :ivar1,:ivar2
22 1 2
23 +++++ Test for PREPARE CString_inc_ws_name FROM char_variable +++++
24 prepare "include_ _name" from :v_query
25 exec sql execute "include_ _name" using :ivar1,:ivar2
26 1 2
27 +++++ Test for PREPARE CString_normal_name FROM char_variable +++++
28 prepare "norma_name" from :v_query
29 exec sql execute "normal_name" using :ivar1,:ivar2
30 1 2
31 +++++ Test for PREPARE ident(typelist) AS +++++
32 prepare ident_name(int,int) as insert into test values($1,$2)
33 execute ident_name(:ivar1,:ivar2)
34 1 2
35 +++++ Test for PREPARE CString_normal_name(typelist) AS +++++
36 prepare "normal_name"(int,int) as insert into test values($1,$2)
37 execute "normal_name"(:ivar1,:ivar2)
38 1 2
39 +++++ Test for PREPARE CString_include_ws_name(typelist) AS +++++
40 prepare "include_ _name"(int,int) as insert into test values($1,$2)
41 execute "include_ _name"(:ivar1,:ivar2)
42 1 2
43 +++++ Test for PREPARE char_variable_normal_name(typelist) AS +++++
44 prepare :v_normal_name(int,int) as insert into test values($1,$2)
45 execute :v_normal_name(:ivar1,:ivar2)
46 1 2
47 +++++ Test for PREPARE char_variable_include_ws_name(typelist) AS +++++
48 prepare :v_include_ws_name(int,int) as insert into test values($1,$2)
49 execute :v_include_ws_name(:ivar1,:ivar2)
50 1 2
51 +++++ Test for EXECUTE :v_normal_name(const,const) +++++
52 prepare :v_normal_name from :v_query
53 execute :v_normal_name(1,2)
54 1 2
55 +++++ Test for EXECUTE :v_normal_name(expr,expr) +++++
56 prepare :v_normal_name from :v_query
57 execute :v_normal_name(0+1,1+1)
58 1 2
59 +++++ Test for combination PREPARE FROM and EXECUTE ident(typelist) +++++
60 prepare ident_name from :v_query
61 execute ident_name(:ivar1,:ivar2)
62 1 2
63 +++++ Test for combination PREPARE FROM and EXECUTE CString_include_ws_name(typelist) +++++
64 prepare "include_ _name" from :v_query
65 execute "include_ _name"(:ivar1,:ivar2)
66 1 2