item_create.h 5.68 KB
Newer Older
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1
/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19 20
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/* Functions to create an item. Used by lex.h */

Item *create_func_abs(Item* a);
Item *create_func_acos(Item* a);
21 22
Item *create_func_aes_encrypt(Item* a, Item* b);
Item *create_func_aes_decrypt(Item* a, Item* b);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
23 24 25 26
Item *create_func_ascii(Item* a);
Item *create_func_asin(Item* a);
Item *create_func_bin(Item* a);
Item *create_func_bit_count(Item* a);
27
Item *create_func_bit_length(Item* a);
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
28
Item *create_func_coercibility(Item* a);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
29 30
Item *create_func_ceiling(Item* a);
Item *create_func_char_length(Item* a);
31
Item *create_func_cast(Item *a, Cast_target cast_type, int len, CHARSET_INFO *cs);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
32 33 34 35
Item *create_func_connection_id(void);
Item *create_func_conv(Item* a, Item *b, Item *c);
Item *create_func_cos(Item* a);
Item *create_func_cot(Item* a);
36
Item *create_func_crc32(Item* a);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
37 38 39 40 41 42 43 44 45
Item *create_func_date_format(Item* a,Item *b);
Item *create_func_dayname(Item* a);
Item *create_func_dayofmonth(Item* a);
Item *create_func_dayofweek(Item* a);
Item *create_func_dayofyear(Item* a);
Item *create_func_degrees(Item *);
Item *create_func_exp(Item* a);
Item *create_func_find_in_set(Item* a, Item *b);
Item *create_func_floor(Item* a);
46
Item *create_func_found_rows(void);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
47 48 49 50 51 52 53 54 55 56 57
Item *create_func_from_days(Item* a);
Item *create_func_get_lock(Item* a, Item *b);
Item *create_func_hex(Item *a);
Item *create_func_inet_aton(Item* a);
Item *create_func_inet_ntoa(Item* a);

Item *create_func_ifnull(Item* a, Item *b);
Item *create_func_instr(Item* a, Item *b);
Item *create_func_isnull(Item* a);
Item *create_func_lcase(Item* a);
Item *create_func_length(Item* a);
58
Item *create_func_ln(Item* a);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
59
Item *create_func_locate(Item* a, Item *b);
60
Item *create_func_log2(Item* a);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
61 62 63 64 65 66 67 68 69 70 71 72 73
Item *create_func_log10(Item* a);
Item *create_func_lpad(Item* a, Item *b, Item *c);
Item *create_func_ltrim(Item* a);
Item *create_func_md5(Item* a);
Item *create_func_mod(Item* a, Item *b);
Item *create_func_monthname(Item* a);
Item *create_func_nullif(Item* a, Item *b);
Item *create_func_oct(Item *);
Item *create_func_ord(Item* a);
Item *create_func_period_add(Item* a, Item *b);
Item *create_func_period_diff(Item* a, Item *b);
Item *create_func_pi(void);
Item *create_func_pow(Item* a, Item *b);
74
Item *create_func_current_user(void);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
75 76 77 78 79 80 81 82 83 84
Item *create_func_quarter(Item* a);
Item *create_func_radians(Item *a);
Item *create_func_release_lock(Item* a);
Item *create_func_repeat(Item* a, Item *b);
Item *create_func_reverse(Item* a);
Item *create_func_rpad(Item* a, Item *b, Item *c);
Item *create_func_rtrim(Item* a);
Item *create_func_sec_to_time(Item* a);
Item *create_func_sign(Item* a);
Item *create_func_sin(Item* a);
85
Item *create_func_sha(Item* a);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
86 87 88 89 90 91 92 93 94 95 96 97
Item *create_func_soundex(Item* a);
Item *create_func_space(Item *);
Item *create_func_sqrt(Item* a);
Item *create_func_strcmp(Item* a, Item *b);
Item *create_func_tan(Item* a);;
Item *create_func_time_format(Item *a, Item *b);
Item *create_func_time_to_sec(Item* a);
Item *create_func_to_days(Item* a);
Item *create_func_ucase(Item* a);
Item *create_func_version(void);
Item *create_func_weekday(Item* a);
Item *create_load_file(Item* a);
98
Item *create_func_is_free_lock(Item* a);
hf@genie.(none)'s avatar
SCRUM  
hf@genie.(none) committed
99
Item *create_func_is_used_lock(Item* a);
100
Item *create_func_quote(Item* a);
101

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
102
Item *create_func_geometry_from_text(Item *a);
103
Item *create_func_as_wkt(Item *a);
104
Item *create_func_as_wkb(Item *a);
ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
105 106 107 108 109 110 111 112 113
Item *create_func_srid(Item *a);
Item *create_func_startpoint(Item *a);
Item *create_func_endpoint(Item *a);
Item *create_func_exteriorring(Item *a);
Item *create_func_centroid(Item *a);
Item *create_func_envelope(Item *a);
Item *create_func_pointn(Item *a, Item *b);
Item *create_func_interiorringn(Item *a, Item *b);
Item *create_func_geometryn(Item *a, Item *b);
114

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
115 116 117 118 119 120 121 122
Item *create_func_equals(Item *a, Item *b);
Item *create_func_disjoint(Item *a, Item *b);
Item *create_func_intersects(Item *a, Item *b);
Item *create_func_touches(Item *a, Item *b);
Item *create_func_crosses(Item *a, Item *b);
Item *create_func_within(Item *a, Item *b);
Item *create_func_contains(Item *a, Item *b);
Item *create_func_overlaps(Item *a, Item *b);
123

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
124 125 126
Item *create_func_isempty(Item *a);
Item *create_func_issimple(Item *a);
Item *create_func_isclosed(Item *a);
127

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
128 129 130 131 132 133
Item *create_func_geometry_type(Item *a);
Item *create_func_dimension(Item *a);
Item *create_func_x(Item *a);
Item *create_func_y(Item *a);
Item *create_func_area(Item *a);
Item *create_func_glength(Item *a);
134

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
135 136 137
Item *create_func_numpoints(Item *a);
Item *create_func_numinteriorring(Item *a);
Item *create_func_numgeometries(Item *a);
138

ram@mysql.r18.ru's avatar
ram@mysql.r18.ru committed
139
Item *create_func_point(Item *a, Item *b);
140 141 142 143 144

Item *create_func_compress(Item *a);
Item *create_func_uncompress(Item *a);
Item *create_func_uncompressed_length(Item *a);

gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
145 146 147 148 149 150 151
Item *create_func_datediff(Item *a, Item *b);
Item *create_func_weekofyear(Item *a);
Item *create_func_makedate(Item* a,Item* b);
Item *create_func_addtime(Item* a,Item* b);
Item *create_func_subtime(Item* a,Item* b);
Item *create_func_timediff(Item* a,Item* b);
Item *create_func_maketime(Item* a,Item* b,Item* c);
152
Item *create_func_str_to_date(Item* a,Item* b);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
153
Item *create_func_last_day(Item *a);