Add "Sent SQL" to debug dump for emulated prepares

1 files changed, 50 insertions, 0 deletions

diff --git a/ext/pdo_pgsql/tests/debug_emulated_prepares.phpt b/ext/pdo_pgsql/tests/debug_emulated_prepares.phpt
new file mode 100644
index 0000000000..ddbe4fea59
--- /dev/null
+++ b/ext/pdo_pgsql/tests/debug_emulated_prepares.phpt
@@ -0,0 +1,50 @@
+--TEST--
+PDO PgSQL PDOStatement::debugDumpParams() with emulated prepares
+--SKIPIF--
+<?php
+if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
+require dirname(__FILE__) . '/config.inc';
+require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
+PDOTest::skip();
+?>
+--FILE--
+<?php
+require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
+$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
+$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
+
+$stmt = $db->prepare('SELECT :bool, :int, :string, :null');
+$stmt->bindValue(':bool', true, PDO::PARAM_BOOL);
+$stmt->bindValue(':int', 123, PDO::PARAM_INT);
+$stmt->bindValue(':string', 'foo', PDO::PARAM_STR);
+$stmt->bindValue(':null', null, PDO::PARAM_NULL);
+$stmt->execute();
+
+var_dump($stmt->debugDumpParams());
+
+?>
+--EXPECT--
+SQL: [34] SELECT :bool, :int, :string, :null
+Sent SQL: [28] SELECT 't', 123, 'foo', NULL
+Params:  4
+Key: Name: [5] :bool
+paramno=-1
+name=[5] ":bool"
+is_param=1
+param_type=2
+Key: Name: [4] :int
+paramno=-1
+name=[4] ":int"
+is_param=1
+param_type=1
+Key: Name: [7] :string
+paramno=-1
+name=[7] ":string"
+is_param=1
+param_type=2
+Key: Name: [5] :null
+paramno=-1
+name=[5] ":null"
+is_param=1
+param_type=0
+NULL