1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008 Sun Microsystems
6
* This program is free software; you can redistribute it and/or modify
7
* it under the terms of the GNU General Public License as published by
8
* the Free Software Foundation; version 2 of the License.
10
* This program is distributed in the hope that it will be useful,
11
* but WITHOUT ANY WARRANTY; without even the implied warranty of
12
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13
* GNU General Public License for more details.
15
* You should have received a copy of the GNU General Public License
16
* along with this program; if not, write to the Free Software
17
* Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
20
#include <drizzled/server_includes.h>
22
#include <drizzled/function/str/replace.h>
23
#include <drizzled/error.h>
24
#include <drizzled/session.h>
27
Replace all occurences of string2 in string1 with string3.
29
Don't reallocate val_str() if not needed.
32
Fix that this works with binary strings when using USE_MB
35
String *Item_func_replace::val_str(String *str)
38
String *res,*res2,*res3;
40
uint32_t from_length,to_length;
43
const char *ptr,*end,*strend,*search,*search_end;
49
res=args[0]->val_str(str);
50
if (args[0]->null_value)
52
res2=args[1]->val_str(&tmp_value);
53
if (args[1]->null_value)
56
res->set_charset(collation.collation);
59
binary_cmp = ((res->charset()->state & MY_CS_BINSORT) || !use_mb(res->charset()));
62
if (res2->length() == 0)
65
if ((offset=res->strstr(*res2)) < 0)
69
if (binary_cmp && (offset=res->strstr(*res2)) < 0)
72
if (!(res3=args[2]->val_str(&tmp_value2)))
74
from_length= res2->length();
75
to_length= res3->length();
81
search_end=search+from_length;
83
ptr=res->ptr()+offset;
84
strend=res->ptr()+res->length();
85
end=strend-from_length+1;
91
i=(char*) ptr+1; j=(char*) search+1;
92
while (j != search_end)
93
if (*i++ != *j++) goto skip;
94
offset= (int) (ptr-res->ptr());
95
if (res->length()-from_length + to_length >
96
current_session->variables.max_allowed_packet)
98
push_warning_printf(current_session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
99
ER_WARN_ALLOWED_PACKET_OVERFLOWED,
100
ER(ER_WARN_ALLOWED_PACKET_OVERFLOWED),
102
current_session->variables.max_allowed_packet);
109
res=copy_if_not_alloced(str,res,res->length()+to_length);
111
res->replace((uint) offset,from_length,*res3);
112
offset+=(int) to_length;
116
if ((l=my_ismbchar(res->charset(), ptr,strend))) ptr+=l;
124
if (res->length()-from_length + to_length >
125
current_session->variables.max_allowed_packet)
127
push_warning_printf(current_session, DRIZZLE_ERROR::WARN_LEVEL_WARN,
128
ER_WARN_ALLOWED_PACKET_OVERFLOWED,
129
ER(ER_WARN_ALLOWED_PACKET_OVERFLOWED), func_name(),
130
current_session->variables.max_allowed_packet);
136
res=copy_if_not_alloced(str,res,res->length()+to_length);
138
res->replace((uint) offset,from_length,*res3);
139
offset+=(int) to_length;
141
while ((offset=res->strstr(*res2,(uint) offset)) >= 0);
150
void Item_func_replace::fix_length_and_dec()
152
uint64_t max_result_length= args[0]->max_length;
153
int diff=(int) (args[2]->max_length - args[1]->max_length);
154
if (diff > 0 && args[1]->max_length)
155
{ // Calculate of maxreplaces
156
uint64_t max_substrs= max_result_length/args[1]->max_length;
157
max_result_length+= max_substrs * (uint) diff;
159
if (max_result_length >= MAX_BLOB_WIDTH)
161
max_result_length= MAX_BLOB_WIDTH;
164
max_length= (ulong) max_result_length;
166
if (agg_arg_charsets(collation, args, 3, MY_COLL_CMP_CONV, 1))