#33859 [Opn->Bgs]: Failed SQLite assertion when using SQL 'AS'

ID: 33859 Updated by: helly@php.net Reported By: leon at lost dot co dot nz -Status: Open +Status: Bogus Bug Type: PDO related Operating System: Linux (Debian Sarge) PHP Version: 5CVS-2005-07-26 (dev) New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. Ask for SQLite support here: http://sqlite.org Previous Comments: ------------------------------------------------------------------------ [2005-07-26 05:36:59] leon at lost dot co dot nz Description: ------------ Attached snippet triggers an assertion everytime: $ php -v PHP 5.1.0-dev (cli) (built: Jul 26 2005 15:26:09) (DEBUG) Copyright (c) 1997-2005 The PHP Group Zend Engine v2.1.0-dev, Copyright (c) 1998-2004 Zend Technologies $ php bug3.php php: /tmp/php5-200507260230/ext/pdo_sqlite/sqlite/src/auth.c:117: sqlite3AuthRead: Assertion `pExpr->op==7' failed. Aborted Reproduce code: --------------- <?php // Setup sample database $conn = new PDO('sqlite::memory:'); $conn->exec('CREATE TABLE barrel (docid INTEGER, wordid INTEGER, position INTEGER)'); $conn->exec('CREATE TABLE documents (id INTEGER PRIMARY KEY, key TEXT UNIQUE)'); // Run problem query $sql = "SELECT count(*) AS count, key FROM ". "barrel, documents WHERE id == docid AND " . "wordid == 1 GROUP BY docid ORDER BY count DESC;"; $stmt = $conn->query($sql); $result = $stmt->fetch(); print_r($result); ?> Expected result: ---------------- Array ( [count] => 0 [0] => 0 [key] => [1] => ) Actual result: -------------- php: /tmp/php5-200507260230/ext/pdo_sqlite/sqlite/src/auth.c:117: sqlite3AuthRead: Assertion `pExpr->op==7' failed. Aborted ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=33859&edit=1