Return to 80_bug32223.phpt CVS log

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

Annotation of embedaddon/php/ext/pgsql/tests/80_bug32223.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #32223 (weird behaviour of pg_last_notice)
                      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: ?>
                     18: --FILE--
                     19: <?php
                     20: 
                     21: require_once('config.inc');
                     22: require_once('lcmess.inc');
                     23:        
                     24: $dbh = @pg_connect($conn_str);
                     25: if (!$dbh) {
                     26:        die ("Could not connect to the server");
                     27: }
                     28: 
                     29: _set_lc_messages();
                     30: 
                     31: $res = pg_query($dbh, "CREATE OR REPLACE FUNCTION test_notice() RETURNS boolean AS '
                     32: begin
                     33:         RAISE NOTICE ''11111'';
                     34:         return ''f'';
                     35: end;
                     36: ' LANGUAGE plpgsql;");
                     37: 
                     38: 
                     39: $res = pg_query($dbh, 'SELECT test_notice()');
                     40: $row = pg_fetch_row($res, 0);
                     41: var_dump($row);
                     42: pg_free_result($res);
                     43: if ($row[0] == 'f')
                     44: {
                     45:        var_dump(pg_last_notice($dbh));
                     46: }
                     47: 
                     48: pg_close($dbh);
                     49: 
                     50: ?>
                     51: ===DONE===
                     52: --EXPECTF--
                     53: array(1) {
                     54:   [0]=>
                     55:   string(1) "f"
                     56: }
                     57: string(14) "NOTICE:  11111"
                     58: ===DONE===