Bug #80358 [Opn->Dup]: PostgreSQL PDOStatement broke json after '\'

From: Date: Fri, 13 Nov 2020 12:34:30 +0000
Subject: Bug #80358 [Opn->Dup]: PostgreSQL PDOStatement broke json after '\'
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-230321@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=80358&edit=1

 ID:                 80358
 Updated by:         cmb@php.net
 Reported by:        toxbyte at gmail dot com
 Summary:            PostgreSQL PDOStatement broke json after '\'
-Status:             Open
+Status:             Duplicate
 Type:               Bug
 Package:            PDO PgSQL
 PHP Version:        7.4.12
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

Duplicate of bug #79276.


Previous Comments:
------------------------------------------------------------------------
[2020-11-13 11:51:55] toxbyte at gmail dot com

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.


------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=80358&edit=1

Thread (2 messages)

« previous php.bugs (#230321) next »