[php-src] Issue #13597: Double quotes accepted unexpectedly for literal value escape in SQLite
| From: | mvorisek | 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