Req #79272 [NEW]: Add PDO::ATTR_EMULATE_PREPARES support for SQLite

From: 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

« previous php.bugs (#225570) next »