http://pear.php.net/bugs/search.php?cmd=display&package_name%5B0%5D=MDB2_Driver_mssql Search Results en-us pear-webmaster@lists.php.net pear-webmaster@lists.php.net hourly 1 2000-01-01T12:00+00:00 http://pear.php.net/gifs/pearsmall.gif http://pear.php.net/bugs http://pear.php.net/bugs/18491 MDB2_Driver_mssql Bug Reported by mjeffreyj 2011-04-29T17:21:55+00:00 PHP: 5.3.0 OS: windows 2008 R2 Package Version: 1.5.0b3 Description: ------------ when I´m using MDB2_Driver_mssql: ERROR - MDB2 Error: can not alter with MDB2_Driver_mysql: OK - no problem Could be problem in MS SQL CONSTRAINTs? Test script: --------------- $mdb2_manager = $mdb2->loadModule('Manager'); $definition = array( 'name' => 'TableName', 'add' => array( 'ColumnName' => array( 'type' => 'boolean', 'default' => 0 ) ) ); $mdb2_manager->alterTable('TableName', $definition, false); Expected result: ---------------- script will add a new column into table Actual result: -------------- MDB2 Error: can not alter]]> MDB2_Driver_mssql Bug Reported by mjeffreyj 2011-04-29T17:21:55+00:00 PHP: 5.3.0 OS: windows 2008 R2 Package Version: 1.5.0b3 Description: ------------ when I´m using MDB2_Driver_mssql: ERROR - MDB2 Error: can not alter with MDB2_Driver_mysql: OK - no problem Could be problem in MS SQL CONSTRAINTs? Test script: --------------- $mdb2_manager = $mdb2->loadModule('Manager'); $definition = array( 'name' => 'TableName', 'add' => array( 'ColumnName' => array( 'type' => 'boolean', 'default' => 0 ) ) ); $mdb2_manager->alterTable('TableName', $definition, false); Expected result: ---------------- script will add a new column into table Actual result: -------------- MDB2 Error: can not alter]]> 2011-04-29T17:32:14+00:00 tomas dot kalous at haug-land dot com MDB2_Driver_mssql Bug http://pear.php.net/bugs/17355 MDB2_Driver_mssql Bug Reported by mspecht 2010-04-28T19:34:53+00:00 PHP: 5.2.10 OS: Linux (Debian Lenny) Package Version: 1.2.1 Description: ------------ When using setLimit() and there SQL query starts with 'SELECT DISTINCT column FROM ...' the Limiter TOP is inserted between SELECT and DISTINCT, which results in an invalid query. There is similar closed bug (#8206) with limitQuery, but with queryCol it still seems to exist. Test script: --------------- $str_sql = 'SELECT DISTINCT event_incident.id FROM event_incident LEFT JOIN event_incidentbuilding ON (event_incidentbuilding.id_incident = event_incident.id)'; $mdb2->setLimit(200, 0); $msc_result = $db->queryCol($str_sql); if (PEAR::isError($msc_result)) { die($msc_result->getDebugInfo()); } var_dump($msc_result); Expected result: ---------------- It should return an array of ids (e.g. 1,2, ....) with a maximum length of 200 Actual result: -------------- getDebugInfo: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT TOP 200 DISTINCT event_incident.id FROM event_incident LEFT JOIN event_incidentbuilding ON (event_incidentbuilding.id_incident = event_incident.id)] [Native code: 156] [Native message: Incorrect syntax near the keyword 'DISTINCT'.]]]> MDB2_Driver_mssql Bug Reported by mspecht 2010-04-28T19:34:53+00:00 PHP: 5.2.10 OS: Linux (Debian Lenny) Package Version: 1.2.1 Description: ------------ When using setLimit() and there SQL query starts with 'SELECT DISTINCT column FROM ...' the Limiter TOP is inserted between SELECT and DISTINCT, which results in an invalid query. There is similar closed bug (#8206) with limitQuery, but with queryCol it still seems to exist. Test script: --------------- $str_sql = 'SELECT DISTINCT event_incident.id FROM event_incident LEFT JOIN event_incidentbuilding ON (event_incidentbuilding.id_incident = event_incident.id)'; $mdb2->setLimit(200, 0); $msc_result = $db->queryCol($str_sql); if (PEAR::isError($msc_result)) { die($msc_result->getDebugInfo()); } var_dump($msc_result); Expected result: ---------------- It should return an array of ids (e.g. 1,2, ....) with a maximum length of 200 Actual result: -------------- getDebugInfo: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT TOP 200 DISTINCT event_incident.id FROM event_incident LEFT JOIN event_incidentbuilding ON (event_incidentbuilding.id_incident = event_incident.id)] [Native code: 156] [Native message: Incorrect syntax near the keyword 'DISTINCT'.]]]> 2010-04-28T19:34:53+00:00 mspecht at e-grafixx dot net MDB2_Driver_mssql Bug http://pear.php.net/bugs/17299 MDB2_Driver_mssql Bug Reported by iceq 2010-04-08T14:42:48+00:00 PHP: 5.2.12 OS: no matter Package Version: 1.3.0b2 Description: ------------ Is it supposed to be so that when I query N rows I always get N-1? E.g. in pagination it always misses Nth row. I locally fixed it by adding MDB2_BufferedResult_mssql::__construct () with $this->limit = max(0, $limit); instead of parental $this->limit = max(0, $limit - 1); and it seems to work fine now. Why is $limit being decremented in the first place?]]> MDB2_Driver_mssql Bug Reported by iceq 2010-04-08T14:42:48+00:00 PHP: 5.2.12 OS: no matter Package Version: 1.3.0b2 Description: ------------ Is it supposed to be so that when I query N rows I always get N-1? E.g. in pagination it always misses Nth row. I locally fixed it by adding MDB2_BufferedResult_mssql::__construct () with $this->limit = max(0, $limit); instead of parental $this->limit = max(0, $limit - 1); and it seems to work fine now. Why is $limit being decremented in the first place?]]> 2010-04-08T14:42:48+00:00 iceq at yandex dot ru MDB2_Driver_mssql Bug http://pear.php.net/bugs/17134 MDB2_Driver_mssql Bug Reported by rprandini 2010-02-18T21:21:03+00:00 PHP: 5.3.0 OS: WINDOWS 2000 sp4 Package Version: 1.3.0b2 Description: ------------ PHP 5.3.0 MDB2 2.5.0b2 PROBLEM pear/MDB2_Driver_mssql requires PHP extension "mssql" i have php_mssql visible under phpinfo() MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version 7.0 Directive Local Value Master Value mssql.allow_persistent On On mssql.batchsize 0 0 mssql.compatability_mode Off Off mssql.connect_timeout 5 5 mssql.datetimeconvert On On mssql.max_links Unlimited Unlimited mssql.max_persistent Unlimited Unlimited mssql.max_procs Unlimited Unlimited mssql.min_error_severity 10 10 mssql.min_message_severity 10 10 mssql.secure_connection Off Off mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60 Test script: --------------- pear install MDB2_Driver_mssql-1.3.0b2 pear/MDB2_Driver_mssql requires PHP extension "mssql" Expected result: ---------------- The correct installation without problem Actual result: -------------- Workaround is pear install --nodeps MDB2_Driver_mssql-1.3.0b2]]> MDB2_Driver_mssql Bug Reported by rprandini 2010-02-18T21:21:03+00:00 PHP: 5.3.0 OS: WINDOWS 2000 sp4 Package Version: 1.3.0b2 Description: ------------ PHP 5.3.0 MDB2 2.5.0b2 PROBLEM pear/MDB2_Driver_mssql requires PHP extension "mssql" i have php_mssql visible under phpinfo() MSSQL Support enabled Active Persistent Links 0 Active Links 0 Library version 7.0 Directive Local Value Master Value mssql.allow_persistent On On mssql.batchsize 0 0 mssql.compatability_mode Off Off mssql.connect_timeout 5 5 mssql.datetimeconvert On On mssql.max_links Unlimited Unlimited mssql.max_persistent Unlimited Unlimited mssql.max_procs Unlimited Unlimited mssql.min_error_severity 10 10 mssql.min_message_severity 10 10 mssql.secure_connection Off Off mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60 Test script: --------------- pear install MDB2_Driver_mssql-1.3.0b2 pear/MDB2_Driver_mssql requires PHP extension "mssql" Expected result: ---------------- The correct installation without problem Actual result: -------------- Workaround is pear install --nodeps MDB2_Driver_mssql-1.3.0b2]]> 2010-02-18T21:21:03+00:00 riccardoprandini01 at gmail dot com MDB2_Driver_mssql Bug http://pear.php.net/bugs/12473 MDB2_Driver_mssql Bug Reported by quipo 2007-11-18T18:03:33+00:00 PHP: 5.2.4 OS: irrelevant Package Version: CVS Description: ------------ Emulated sequence values are off by one. When created, they start from 2 instead of 1.]]> MDB2_Driver_mssql Bug Reported by quipo 2007-11-18T18:03:33+00:00 PHP: 5.2.4 OS: irrelevant Package Version: CVS Description: ------------ Emulated sequence values are off by one. When created, they start from 2 instead of 1.]]> 2009-10-16T02:04:02+00:00 l dot alberton at quipo dot it MDB2_Driver_mssql Bug