Bug #68771 [Asn->Csd]: Incorrect array
| From: | ab@php.net | Date: | Mon, 12 Jan 2015 16:03:25 +0000 |
| Subject: | Bug #68771 [Asn->Csd]: Incorrect array | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-189906@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=68771&edit=1
ID: 68771
Updated by: ab@php.net
Reported by: bugreports at internot dot info
Summary: Incorrect array
-Status: Assigned
+Status: Closed
Type: Bug
Package: SQLite related
Operating System: Linux Ubuntu 14.04
PHP Version: master-Git-2015-01-08 (Git)
Assigned To: ab
Block user comment: N
Private report: N
New Comment:
Automatic comment on behalf of ab
Revision: http://git.php.net/?p=php-src.git;a=commit;h=ef5862253480ee9f6be0dd4dc6c7d87b0a5cc935
Log: Fixed bug #68771 SQL syntax error in sqlite lib
Previous Comments:
------------------------------------------------------------------------
[2015-01-12 15:24:25] danack@php.net
This does look like a typo. Every other mutli-line entry in the file has spaces to avoid this.
I've attempted to report it upstream.....and the bug report is awaiting moderator approval.
ab I've assigned the bug to you as appear to be the person who touched the file last. Apologies
in advance if that's not the correct thing to do.
------------------------------------------------------------------------
[2015-01-08 13:53:48] bugreports at internot dot info
Description:
------------
Hi,
In /ext/sqlite3/libsqlite/sqlite3.c:
139815/* 13 */ "SELECT idx, start_block, leaves_end_block, end_block, root "
139816 "FROM %Q.'%q_segdir' WHERE level BETWEEN ? AND ?"
139817 "ORDER BY level DESC, idx ASC",
The end of L139816 is missing a space, causing the arrya to become
"[..] BETWEEN ? AND ?ORDER BY [..]"
which is obviously incorrect and will cause an SQL error.
Thanks,
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=68771&edit=1