Debian Codegraph @

src/misc/upgrade/v2/ib_udf_upgrade.sql

raw
1 /*
2 * The contents of this file are subject to the Initial
3 * Developer's Public License Version 1.0 (the "License");
4 * you may not use this file except in compliance with the
5 * License. You may obtain a copy of the License at
6 * http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_idpl.
7 *
8 * Software distributed under the License is distributed AS IS,
9 * WITHOUT WARRANTY OF ANY KIND, either express or implied.
10 * See the License for the specific language governing rights
11 * and limitations under the License.
12 *
13 * The Original Code was created by Claudio Valderrama on 20-Sept-2004
14 * for the Firebird Open Source RDBMS project.
15 *
16 * Copyright (c) 2004 Claudio Valderrama
17 * and all contributors signed below.
18 *
19 * All Rights Reserved.
20 * Contributor(s): ______________________________________.
21 *
22 */
23
24 -- Warning: this script should be used only when you are using the new ib_udf
25 -- library together with Firebird v2 and want to detect NULL correctly.
26
27 update rdb$function_arguments
28 set rdb$mechanism = 5
29 where rdb$function_name = 'ASCII_CHAR'
30 and rdb$argument_position = 1;
31
32 update rdb$function_arguments
33 set rdb$mechanism = 5
34 where rdb$function_name = 'LOWER'
35 and rdb$argument_position = 1;
36
37 update rdb$function_arguments
38 set rdb$mechanism = 5
39 where rdb$function_name = 'LPAD'
40 and rdb$argument_position in (1, 3);
41
42 update rdb$function_arguments
43 set rdb$mechanism = 5
44 where rdb$function_name = 'LTRIM'
45 and rdb$argument_position = 1;
46
47 update rdb$function_arguments
48 set rdb$mechanism = 5
49 where rdb$function_name = 'RPAD'
50 and rdb$argument_position in (1, 3);
51
52 update rdb$function_arguments
53 set rdb$mechanism = 5
54 where rdb$function_name = 'RTRIM'
55 and rdb$argument_position = 1;
56
57 update rdb$function_arguments
58 set rdb$mechanism = 5
59 where rdb$function_name = 'SUBSTR'
60 and rdb$argument_position = 1;
61
62 update rdb$function_arguments
63 set rdb$mechanism = 5
64 where rdb$function_name = 'SUBSTRLEN'
65 and rdb$argument_position = 1;
66