Bug #73430 [NEW]: PostgreSQL 9.4, PostGIS 2.1

From: roman dot salnikov dot s at gmail dot com Operating system: Debian 8 PHP version: 7.0.12 Package: PDO PgSQL Bug Type: Bug Bug description:PostgreSQL 9.4, PostGIS 2.1 Description: ------------ I try to bind param for string. But it doesn't work. Test script: --------------- $conn = new PDO('pgsql:host=localhost;dbname=base', 'login', 'pass'); $stmt = $conn->prepare("select ST_Contains(ST_GeometryFromText('POLYGON((:downLeftPoint, :topLeftPoint, :topRightPoint, :downRightPoint, :downLeftPoint))'), POINT(100500,100500)::geometry)"); $stmt->bindParam(':downLeftPoint', $coord['downLeftPoint']); $stmt->bindParam(':topLeftPoint', $coord['topLeftPoint']); $stmt->bindParam(':topRightPoint', $coord['topRightPoint']); $stmt->bindParam(':downRightPoint', $coord['downRightPoint']); $stmt->bindParam(':downLeftPoint', $coord['downLeftPoint']); $stmt->execute(); Expected result: ---------------- SQL query: select ST_Contains(ST_GeometryFromText('POLYGON((100500 100500, 200500 200500, 300500 300500, 400500 400500, 100500 100500))'), POINT(100500,100500)::geometry) Actual result: -------------- Error: PDOStatement::bindParam(): SQLSTATE[HY093]: Invalid parameter number: :downLeftPoint -- Edit bug report at https://bugs.php.net/bug.php?id=73430&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=73430&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=73430&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=73430&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=73430&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=73430&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=73430&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=73430&r=needscript Try newer version: https://bugs.php.net/fix.php?id=73430&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=73430&r=support Expected behavior: https://bugs.php.net/fix.php?id=73430&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=73430&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=73430&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=73430&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=73430&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=73430&r=dst IIS Stability: https://bugs.php.net/fix.php?id=73430&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=73430&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=73430&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=73430&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=73430&r=mysqlcfg