Hi Matthew,
On 16/07/2013 21:21, Matthew Ward wrote:
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The first time I run
Thank you Dan. Great find !! That was the answer. group_concat was
truncating my results and it caused my prepared sql to error out. I change
the server variable dynamically whenever the 1260 warning is issued to
accommodate larger and larger strings for the group by operation and it
works well.
Th
In the last episode (Oct 16), Kailash R said:
> Nice input Dan. Let me run some checks. My query is as follows:
>
> select group_concat(Field1), field2, field3 from table1 group by field2,
> field3 into str;
> @sql = concat("select blah ... where field1 in ' ,str);
> prepare stmt from @sql;
> exe
Nice input Dan. Let me run some checks. My query is as follows:
select group_concat(Field1), field2, field3 from table1 group by field2,
field3 into str;
@sql = concat("select blah ... where field1 in ' ,str);
prepare stmt from @sql;
execute stmt;
deallocate prepare stmt;
So when the count(*) for
In the last episode (Oct 15), Kailash R said:
> I was wondering if there is a way to increase the size of user defined
> variables ? I am not able to attribute a type to them and when I assign
> @sql = 'a_text _field' , 'a_text_field' gets truncated if it exceeds the
> size of @sql. This is not w
