Debian Codegraph @

src/misc/upgrade/v2/ib_udf2_params.txt

raw
1 CVC:
2 This is how v2's ib_udf parameters look in system tables.
3 Comparing this file against ib_udf_params.txt we get ib_udf_upgrade.sql
4 that will take us from v1's ib_udf to v2's ib_udf.
5
6 RDB$FUNCTION_NAME RDB$ARGUMENT_POSITION RDB$MECHANISM
7 =============================== ===================== =============
8
9 ABS 0 0
10 ABS 1 1
11 ACOS 0 0
12 ACOS 1 1
13 ASCII_CHAR 0 -1
14 ASCII_CHAR 1 5
15 ASCII_VAL 0 0
16 ASCII_VAL 1 1
17 ASIN 0 0
18 ASIN 1 1
19 ATAN 0 0
20 ATAN 1 1
21 ATAN2 0 0
22 ATAN2 1 1
23 ATAN2 2 1
24 BIN_AND 0 0
25 BIN_AND 1 1
26 BIN_AND 2 1
27 BIN_OR 0 0
28 BIN_OR 1 1
29
30 RDB$FUNCTION_NAME RDB$ARGUMENT_POSITION RDB$MECHANISM
31 =============================== ===================== =============
32 BIN_OR 2 1
33 BIN_XOR 0 0
34 BIN_XOR 1 1
35 BIN_XOR 2 1
36 CEILING 0 0
37 CEILING 1 1
38 COS 0 0
39 COS 1 1
40 COSH 0 0
41 COSH 1 1
42 COT 0 0
43 COT 1 1
44 DIV 0 0
45 DIV 1 1
46 DIV 2 1
47 FLOOR 0 0
48 FLOOR 1 1
49 LN 0 0
50 LN 1 1
51 LOG 0 0
52
53 RDB$FUNCTION_NAME RDB$ARGUMENT_POSITION RDB$MECHANISM
54 =============================== ===================== =============
55 LOG 1 1
56 LOG 2 1
57 LOG10 0 0
58 LOG10 1 1
59 LOWER 0 -1
60 LOWER 1 5
61 LPAD 0 -1
62 LPAD 1 5
63 LPAD 2 1
64 LPAD 3 5
65 LTRIM 0 -1
66 LTRIM 1 5
67 MOD 0 0
68 MOD 1 1
69 MOD 2 1
70 PI 0 0
71 RAND 0 0
72 RPAD 0 -1
73 RPAD 1 5
74 RPAD 2 1
75
76 RDB$FUNCTION_NAME RDB$ARGUMENT_POSITION RDB$MECHANISM
77 =============================== ===================== =============
78 RPAD 3 5
79 RTRIM 0 -1
80 RTRIM 1 5
81 SIGN 0 0
82 SIGN 1 1
83 SIN 0 0
84 SIN 1 1
85 SINH 0 0
86 SINH 1 1
87 SQRT 0 0
88 SQRT 1 1
89 STRLEN 0 0
90 STRLEN 1 1
91 SUBSTR 0 -1
92 SUBSTR 1 5
93 SUBSTR 2 1
94 SUBSTR 3 1
95 SUBSTRLEN 0 -1
96 SUBSTRLEN 1 5
97 SUBSTRLEN 2 1
98
99 RDB$FUNCTION_NAME RDB$ARGUMENT_POSITION RDB$MECHANISM
100 =============================== ===================== =============
101 SUBSTRLEN 3 1
102 TAN 0 0
103 TAN 1 1
104 TANH 0 0
105 TANH 1 1
106