Req #79272 [NEW]: Add PDO::ATTR_EMULATE_PREPARES support for SQLite
| From: | effulgentsia1 at gmail dot com | Date: | Thu, 13 Feb 2020 19:45:25 +0000 |
| Subject: | Req #79272 [NEW]: Add PDO::ATTR_EMULATE_PREPARES support for SQLite | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-225570@lists.php.net to get a copy of this message | ||
From: effulgentsia1 at gmail dot com
Operating system: All
PHP version: Next Minor Version
Package: PDO SQLite
Bug Type: Feature/Change Request
Bug description:Add PDO::ATTR_EMULATE_PREPARES support for SQLite
Description:
------------
MySQL and PostgreSQL have limits of 65535 placeholders for native
prepared statements. However, if more are passed, the PDO drivers
fallback to emulating prepares, in which case the only limit is whatever
the database server has configured for its SQL statement length limit
(e.g., max_allowed_packet for MySQL).
However, SQLite has a default limit of 999 placeholders
(https://bugs.php.net/bug.php?id=79269), and the PDO driver for it does
not fallback to emulating prepares, or support the
PDO::ATTR_EMULATE_PREPARES at all.
For Drupal, we use PDO and support MySQL, PostgreSQL, and SQLite. For
consistency, it would be helpful if the PDO driver for SQLite also
supported emulated prepares.
Test script:
---------------
Same as in https://bugs.php.net/bug.php?id=79269.
--
Edit bug report at https://bugs.php.net/bug.php?id=79272&edit=1
--
Fix committed: https://bugs.php.net/fix.php?id=79272&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=79272&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=79272&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=79272&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=79272&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=79272&r=support
Expected behavior: https://bugs.php.net/fix.php?id=79272&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=79272&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=79272&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=79272&r=globals
PHP version support discontinued: https://bugs.php.net/fix.php?id=79272&r=phptooold
Daylight Savings: https://bugs.php.net/fix.php?id=79272&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=79272&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=79272&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=79272&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=79272&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=79272&r=mysqlcfg