[php-src] Issue #13597: Double quotes accepted unexpectedly for literal value escape in SQLite

From: Date: Tue, 05 Mar 2024 12:54:13 +0000
Subject: [php-src] Issue #13597: Double quotes accepted unexpectedly for literal value escape in SQLite
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-246510@lists.php.net to get a copy of this message
Issue: https://github.com/php/php-src/issues/13597 Author: mvorisek ### Description discovered in https://github.com/doctrine/dbal/pull/6325#issuecomment-1977604443 Currently PHP pdo_sqlite (and sqlite3) extensions accept SQL queries /w format that is natively not supported by SQLite degrading our testing quality as such SQL queries cannot be executed outside PHP. PHP repro: https://3v4l.org/lfZSq SQLite/native repro: https://dbfiddle.uk/D0hu63uV ## Current behaviour: " (double quote) accepted for literal value escape ## Expected behaviour: SQLite does not accept " (double quote) natively for literal value escape, I would expect the same from PHP by default, ie. fail with SQLite parse error if some query like select "-1" is executed. ### PHP Version any ### Operating System any

« previous php.bugs (#246510) next »