Return to bug62593.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_pgsql/tests/bug62593.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO PgSQL Bug #62593 (Emulate prepares behave strangely with PARAM_BOOL)
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                      8: PDOTest::skip();
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                     13: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     14: $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
                     15: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
                     16: $errors = array();
                     17: 
                     18: $value = true;
                     19: $query = $db->prepare('SELECT :foo IS FALSE as val_is_false');
                     20: $query->bindValue(':foo', $value, PDO::PARAM_BOOL);
                     21: $query->execute();
                     22: $errors[] = $query->errorInfo();
                     23: var_dump($value);
                     24: 
                     25: $query->bindValue(':foo', 0, PDO::PARAM_BOOL);
                     26: $query->execute();
                     27: $errors[] = $query->errorInfo();
                     28: 
                     29: // Verify bindParam maintains reference and only passes when execute is called
                     30: $value = true;
                     31: $query->bindParam(':foo', $value, PDO::PARAM_BOOL);
                     32: $value = false;
                     33: $query->execute();
                     34: $errors[] = $query->errorInfo();
                     35: var_dump($value);
                     36: 
                     37: $expect = 'No errors found';
                     38: 
                     39: foreach ($errors as $error)
                     40: {
                     41:   if (strpos('Invalid text representation', $error[2]) !== false)
                     42:   {
                     43:     $expect = 'Invalid boolean found';
                     44:   }
                     45: }
                     46: echo $expect;
                     47: ?>
                     48: --EXPECTF--
                     49: bool(true)
                     50: bool(false)
                     51: No errors found