Hi!
On Jun 13, Arnold Daniels wrote:
> Hi,
>
> I have a problem with using the result of an UDF from a subquery. The
> data is truncated on 255 chars. The data is probably seen as normal
> string (varchar), while is should be seen as blob.
>
> Also (might be unrelated), using the output of an UDF as input for
> string of cast functions makes the input appear as NULL. Using a
> function like char_size works fine though.
>
> I didn't notice this problem in earlier versions of MySQL, but it might
> simply have to do with my test setup.
>
> Can anyone explain what is happening and how this can be solved. I
> really need to have this solved to make the lib work. Please do no send
> comments like "you don't need subqueries", because it might not be
> important in this example but it is needed in order to create an XML tree.
Reported as http://bugs.mysql.com/bug.php?id=29202
In the future, please use bugdb for problems like this.
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Developer
/_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Radlkoferstr. 2, D-81373 München
<___/ Geschäftsführer: Kaj Arnö - HRB
München 162140