List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:June 19 2007 9:13am
Subject:Re: Result of UDF in subquery is truncated
View as plain text  
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
Thread
Result of UDF in subquery is truncatedArnold Daniels13 Jun
  • Re: Result of UDF in subquery is truncatedSergei Golubchik19 Jun