Re: insert ... select .. order by problem

Hi!

On Sep 01, Alejandro Paz wrote:
> Hallo everyone !
> 
> I already sent this, but I think some people think is
> not clear enough ;-)
 
> And the statement I am using is :
> 
> INSERT INTO PTemp SELECT d,e,32,'E' FROM Stock WHERE
> h<i ORDER BY a,b,c;
> 
> I am doing an insert/select with order by, in both
> cases I am using the same statemant.
> 
> When I use the same statement in my application (built
> with C, and statically linked
> to libmysqlclient.a) I get the reversed order.
> 
> When I test the statement in the mysql cli and I get
> the results well sorted.

What "results" do you mean here ?
INSERT command does not return any results.

Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]