Bug #69591 [NEW]: PDO_DBLIB MSSQL more statements error

From: Date: Thu, 07 May 2015 08:39:39 +0000
Subject: Bug #69591 [NEW]: PDO_DBLIB MSSQL more statements error
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-192546@lists.php.net to get a copy of this message
From:             martinpop83 at gmail dot com
Operating system: Linux
PHP version:      Irrelevant
Package:          PDO DBlib
Bug Type:         Bug
Bug description:PDO_DBLIB MSSQL more statements error

Description:
------------
I can't create two and more select statements with pdo_dblib. If I try
it, pdo_dblib create weird combination of statements into first
statement and others returns false.

With pdo_sqlsrv (Windows server) and mssql (Linux server, FreeTDS) is
everything ok.


Test script:
---------------
$pdo = new PDO("dblib:host=<host>;dbname=<dbname>", "username",
"password");

$stmtA = $pdo->query("SELECT 1 AS number, 'aaa' AS text");
$stmtB = $pdo->query("SELECT 'val' AS value");

print_r($stmtA->fetch(PDO::FETCH_ASSOC));
print_r($stmtB->fetch(PDO::FETCH_ASSOC));


Expected result:
----------------
Array
(
    [number] => 1
    [text] => aaa
)

Array
(
    [value] => val
)


Actual result:
--------------
Array
(
    [value] => val
    [text] => 
)

bool(false)


-- 
Edit bug report at https://bugs.php.net/bug.php?id=69591&edit=1
-- 
Try a snapshot (PHP 5.4):   https://bugs.php.net/fix.php?id=69591&r=trysnapshot54
Try a snapshot (PHP 5.5):   https://bugs.php.net/fix.php?id=69591&r=trysnapshot55
Try a snapshot (trunk):     https://bugs.php.net/fix.php?id=69591&r=trysnapshottrunk
Fixed in SVN:               https://bugs.php.net/fix.php?id=69591&r=fixed
Fixed in release:           https://bugs.php.net/fix.php?id=69591&r=alreadyfixed
Need backtrace:             https://bugs.php.net/fix.php?id=69591&r=needtrace
Need Reproduce Script:      https://bugs.php.net/fix.php?id=69591&r=needscript
Try newer version:          https://bugs.php.net/fix.php?id=69591&r=oldversion
Not developer issue:        https://bugs.php.net/fix.php?id=69591&r=support
Expected behavior:          https://bugs.php.net/fix.php?id=69591&r=notwrong
Not enough info:            https://bugs.php.net/fix.php?id=69591&r=notenoughinfo
Submitted twice:            https://bugs.php.net/fix.php?id=69591&r=submittedtwice
register_globals:           https://bugs.php.net/fix.php?id=69591&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=69591&r=php4
Daylight Savings:           https://bugs.php.net/fix.php?id=69591&r=dst
IIS Stability:              https://bugs.php.net/fix.php?id=69591&r=isapi
Install GNU Sed:            https://bugs.php.net/fix.php?id=69591&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=69591&r=float
No Zend Extensions:         https://bugs.php.net/fix.php?id=69591&r=nozend
MySQL Configuration Error:  https://bugs.php.net/fix.php?id=69591&r=mysqlcfg



Thread (6 messages)

« previous php.bugs (#192546) next »