2
Sybase-CT bug #26407 (Result set fetching broken around transactions)
4
<?php require('skipif.inc'); ?>
7
/* This file is part of PHP test framework for ext/sybase_ct
9
* $Id: bug26407.phpt,v 1.1 2004/01/24 02:54:33 thekid Exp $
14
$db= sybase_connect_ex();
16
// Create temporary table
17
$table= basename(__FILE__, '.php');
18
var_dump(sybase_query('create table #'.$table.' ( the_big_answer int )', $db));
21
var_dump(sybase_select_ex($db, '
23
-- anything producing a result set here will fail;
24
-- however, print or update statements will work
27
-- anything afterwards will fail, too
31
var_dump(sybase_select_ex($db, '
33
-- no result returned...
34
update #'.$table.' set the_big_answer=42
39
var_dump(sybase_select_ex($db, '
42
-- do anything, even return a result set
53
-- anything producing a result set here will fail;
54
-- however, print or update statements will work
57
-- anything afterwards will fail, too
69
-- no result returned...
70
update #bug26407 set the_big_answer=42
78
-- do anything, even return a result set
83
Notice: sybase_query(): Sybase: Unexpected results, cancelling current in %s/test.inc on line %d