Description: ------------ The sequence emulation for the mdb2 mssql driver is not working with MSSQL Server 2005 or above. The problem is described here: http://www.sql-server-performance.com/faq/error339_p1.aspx In revision 1.153 of the mdb2 mssql driver sequence emulation is working correctly: http://cvs.php.net/viewvc.cgi/pear/MDB2/MDB2/Driver/mssql.php?r1=1.152&r2=1.153 In revision 1.154 the code was changed resulting in this bug: http://cvs.php.net/viewvc.cgi/pear/MDB2/MDB2/Driver/mssql.php?r1=1.152&r2=1.153 Test script: --------------- require_once('MDB2.php'); require_once('Log.php'); $dsn = 'mssql://xxx:xxx@localhost/db_name; $mdb2 = MDB2::singleton($dsn); if (PEAR::isError($mdb2)) { echo $mdb2->getUserInfo(); } $conf = array('db' => $mdb2, 'sequence' => 'log_id'); $log = Log::singleton('mdb2', 'log_table', 'ident', $conf); $log->notice('Test notice'); $log->notice('Test notice'); $log->notice('Test notice'); Expected result: ---------------- The value of the sequence field in the sequence table is incremented by each call of $log->notice(). Actual result: -------------- The value of the sequence field in the sequence table is never incremented.

The link for the broken revision 1.154 was incorrect. The correct one must be: http://cvs.php.net/viewvc.cgi/pear/MDB2/MDB2/Driver/mssql.php?r1=1.153&r2=1.154