18 messages in com.mysql.lists.bugsNext update problem
FromSent OnAttachments
Alexander Aulbach04 Dec 2000 15:46 
Sinisa Milivojevic05 Dec 2000 05:28 
Alexander Aulbach06 Dec 2000 04:39 
Sinisa Milivojevic06 Dec 2000 04:55 
Alexander Aulbach06 Dec 2000 06:58 
Michael Widenius06 Dec 2000 10:56 
Sasha Pachev06 Dec 2000 11:39 
Alexander Aulbach07 Dec 2000 06:42 
Michael Widenius07 Dec 2000 17:39 
Alexander Aulbach08 Dec 2000 04:22 
Michael Widenius09 Dec 2000 04:38 
Werner Maier09 Dec 2000 06:51 
Michael Widenius10 Dec 2000 07:23 
Alexander Aulbach11 Dec 2000 07:10 
Alexander Aulbach13 Dec 2000 07:02.tgz
Michael Widenius14 Dec 2000 23:04 
Alexander Aulbach15 Dec 2000 03:28 
Michael Widenius15 Dec 2000 16:51 
Subject:Next update problem
From:Alexander Aulbach (ssi@mainmedia.de)
Date:12/13/2000 07:02:35 AM
List:com.mysql.lists.bugs
Attachments:
active_sessions.tgz - 3k

Hi, Monty, today we found another bug. I think this is cause of your last patch we put into our current mysql-installation (think, you remember it).

With this mail I attached the tables.

Here is the bug:

mysql> update active_sessions set p_valenc='slashes', p_valpos='000000',
p_val='$this->in = \'\'; $this->pt = array(); $this->pt[\'auth\'] = \'1\';
$this->pt[\'qv\'] = \'1\'; $GLOBALS[\'auth\']=new
antz_Auth;$GLOBALS[\'auth\']->auth = array (); $GLOBALS[\'auth\']->auth[\'uid\']
= \'nobody\'; $this->pt[\'qv\'] = \'1\'; $GLOBALS[\'auth\']=new
antz_Auth;$GLOBALS[\'auth\']->auth = array(); $GLOBALS[\'auth\']->auth[\'uid\']
= \'nobody\'; $GLOBALS[\'auth\']->auth[\'perm\'] = \'\';
$GLOBALS[\'auth\']->auth[\'exp\'] = \'2147483647\';
$GLOBALS[\'auth\']->auth[\'uname\'] = \'ssilk\';
$GLOBALS[\'auth\']->auth[\'refresh\'] = \'2147483647\'; $GLOBALS[\'auth\']->mode
= \'log\'; $GLOBALS[\'auth\']->in = \'1\'; $GLOBALS[\'qv\'] = array();
$GLOBALS[\'qv\'][\'client\'] = array(); $GLOBALS[\'qv\'][\'client\'][\'val\'] =
\'mp\'; $GLOBALS[\'qv\'][\'category\'] = array();
$GLOBALS[\'qv\'][\'category\'][\'val\'] = \'\'; ', p_changed='20001213152641'
where p_sid='3528da0271a181c682b64ed5d4a3a883' and p_name='antz_Sess'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 ^^^^^^^^^^ nothing changed!!!

mysql> select p_sid,p_changed from active_sessions where p_sid='3528da0271a181c682b64ed5d4a3a883' and p_name='antz_Sess'; +----------------------------------+----------------+ | p_sid | p_changed | +----------------------------------+----------------+ | 3528da0271a181c682b64ed5d4a3a883 | 20001212171448 | <<<--- p_changed is not
changed +----------------------------------+----------------+ 1 row in set (0.00 sec)