|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2020-11-13 12:34 UTC] cmb@php.net
-Status: Open
+Status: Duplicate
-Assigned To:
+Assigned To: cmb
[2020-11-13 12:34 UTC] cmb@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 04:00:02 2025 UTC |
Description: ------------ $pdo->exec($focusSql); // works correct $pdo->prepare($focusSql)->execute(); // error Test script: --------------- $focusSql = <<<'SQL' select '\', '{"x":1}'::jsonb SQL; $pdo->exec($focusSql) !== false and print("1 OK\n"); $pdo->prepare(<<<'SQL' select '\\', '{"x":1}'::jsonb SQL)->execute() and print("2 OK\n"); $pdo->prepare(<<<'SQL' select '\', '{"x":"foo"}'::jsonb SQL)->execute() and print("3 OK\n"); $pdo->prepare(<<<'SQL' select '\', '{"x":1}' SQL)->execute() and print("4 OK\n"); $pdo->prepare($focusSql)->execute() and print("5 OK\n"); Expected result: ---------------- 1 OK 2 OK 3 OK 4 OK 5 OK Actual result: -------------- 1 OK 2 OK 3 OK 4 OK PDOException: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json LINE 1: select '\', '{"x"$1}'::jsonb ^ DETAIL: Token "$" is invalid.