Hello.
MySQL team verified this issue, but they've said that this is rather a feature request, not really a bug. See: http://bugs.mysql.com/bug.php?id=13032 Jason Pyeron <[EMAIL PROTECTED]> wrote: > Thanks Michael, > > but it now seems that on prepared selects, the values are still place > holders, whilst on prepared inserts they are substituted in. > > Does anyone know how to address this issue? > > +-----+-----------+--------------------+-----------+---------+------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | Id | User | Host | db | Command | Time | State > | Info > | > +-----+-----------+--------------------+-----------+---------+------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query | 0 | NULL > | show full processlist > | > | 117 | crisfield | testserver:40291 | crisfield | Execute | 0 | Sending > data | SELECT id, pathref, version, mdate, ddate,size, md5 FROM files WHERE > (version, pathref)=(SELECT MAX(version),pathref FROM files WHERE pathref=? > group by pathref) | > +-----+-----------+--------------------+-----------+---------+------+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > 2 rows in set (0.01 sec) > > mysql> show full processlist; > +-----+-----------+--------------------+-----------+---------+------+--------+--------------------------------------------------------------------------------------------------------------+ > | Id | User | Host | db | Command | Time | State > | Info | > +-----+-----------+--------------------+-----------+---------+------+--------+--------------------------------------------------------------------------------------------------------------+ > | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query | 0 | NULL > | show full processlist > | > | 117 | crisfield | testserver:40291 | crisfield | Execute | 0 | update > | INSERT INTO files (pathref, version, mdate, ddate, size, md5) VALUES > (51943,0,1060907651000,NULL,64685,NULL) | > +-----+-----------+--------------------+-----------+---------+------+--------+--------------------------------------------------------------------------------------------------------------+ > 2 rows in set (0.06 sec) > > mysql> > > > On Tue, 6 Sep 2005, Michael Barnett wrote: > >> You can log on to your mysql server and run: >> >> show full processlist; >> >> That should give you what you are looking for. >> >> -m >> >> On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote: >> >>> >>> mysqladmin is truncating the output, how can i disable this? >>> or is there a better way to examine what the serer is executing at that >>> moment in time? >>> >>> [EMAIL PROTECTED] root]# mysqladmin process >>> +-----+-----------+--------------------+-----------+---------+---- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
