Return to bug27843.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sybase_ct / tests

Annotation of embedaddon/php/ext/sybase_ct/tests/bug27843.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Sybase-CT bug #27843 (notices when query is a stored procedure)
        !             3: --SKIPIF--
        !             4: <?php require('skipif.inc'); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: /* This file is part of PHP test framework for ext/sybase_ct
        !             8:  *
        !             9:  * $Id: bug27843.phpt 236101 2007-05-22 11:35:47Z thekid $ 
        !            10:  */
        !            11: 
        !            12:   require('test.inc');
        !            13: 
        !            14:   $db= sybase_connect_ex();
        !            15: 
        !            16:   // Check if stored procedure already exists
        !            17:   $sp_name= 'phpt_bug27843';
        !            18:   var_dump(sybase_select_db(TEMPDB, $db));
        !            19:   if (!sybase_select_single($db, 'select object_id("'.$sp_name.'")')) {
        !            20:     echo "Stored procedure {$sp_name} not found, creating\n";
        !            21:     var_dump(sybase_query('
        !            22:       create proc '.$sp_name.'
        !            23:       as
        !            24:       begin
        !            25:         select 1
        !            26:       end
        !            27:     '));
        !            28:   } else {
        !            29:     echo "Stored procedure {$sp_name} found, using\n";
        !            30:     var_dump(TRUE);
        !            31:   }
        !            32:   
        !            33:   // Execute stored procedure
        !            34:   var_dump(sybase_select_ex($db, 'exec '.$sp_name));
        !            35: 
        !            36:   // Clean up after ourselves
        !            37:   var_dump(sybase_query('drop proc '.$sp_name, $db));
        !            38: 
        !            39:   sybase_close($db);
        !            40: ?>
        !            41: --EXPECTF--
        !            42: bool(true)
        !            43: Stored procedure %s
        !            44: bool(true)
        !            45: >>> Query: exec phpt_bug27843
        !            46: <<< Return: resource
        !            47: array(1) {
        !            48:   [0]=>
        !            49:   array(1) {
        !            50:     ["computed"]=>
        !            51:     int(1)
        !            52:   }
        !            53: }
        !            54: bool(true)