Return to 80_bug32223b.phpt CVS log

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

Annotation of embedaddon/php/ext/pgsql/tests/80_bug32223b.phpt, revision 1.1.1.2

1.1       misho       1: --TEST--
                      2: Bug #32223 (weird behaviour of pg_last_notice using define)
                      3: --SKIPIF--
                      4: <?php 
                      5: require_once('skipif.inc');
                      6: 
                      7: _skip_lc_messages();
                      8:        
                      9: @pg_query($conn, "CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'");
                     10: $res = @pg_query($conn, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
                     11: begin
                     12:         RAISE NOTICE ''11111'';
                     13:         return ''f'';
                     14: end;
                     15: ' LANGUAGE plpgsql;");
                     16: if (!$res) die('skip PLPGSQL not available');
                     17: ?>
1.1.1.2 ! misho      18: --INI--
        !            19: pgsql.ignore_notice=0
1.1       misho      20: --FILE--
                     21: <?php
                     22: 
                     23: require_once('config.inc');
                     24: require_once('lcmess.inc');
                     25: 
                     26: define('dbh', pg_connect($conn_str));
                     27: if (!dbh) {
                     28:         die ("Could not connect to the server");
                     29: }
                     30: 
                     31: _set_lc_messages();
                     32: 
                     33: $res = pg_query(dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
                     34: begin
                     35:         RAISE NOTICE ''11111'';
                     36:         return ''f'';
                     37: end;
                     38: ' LANGUAGE plpgsql;");
                     39: 
                     40: function tester() {
                     41:         $res = pg_query(dbh, 'SELECT test_notice()');
                     42:         $row = pg_fetch_row($res, 0);
                     43:                var_dump($row);
                     44:         pg_free_result($res);
                     45:         if ($row[0] == 'f')
                     46:         {
                     47:                 var_dump(pg_last_notice(dbh));
                     48:         }
                     49: }
                     50: tester();
                     51: 
                     52: pg_close(dbh);
                     53: 
                     54: ?>
                     55: ===DONE===
                     56: --EXPECTF--
                     57: array(1) {
                     58:   [0]=>
                     59:   string(1) "f"
                     60: }
                     61: string(14) "NOTICE:  11111"
                     62: ===DONE===