|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-08-20 11:40 UTC] wez@php.net
[2003-08-20 15:06 UTC] mrobinso@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 02 09:00:01 2025 UTC |
Description: ------------ The sqlite library is appending an extra character onto the end of any specified table name. For example, if I specify a table name of 'foo' for a query, sqlite looks for a table named 'fooo'. It takes the last character of the table name supplied, and appends an extra one of those chars onto the end of the table name. If I do a select and supply a table name of 'fo', sqlite will return data from the table 'foo'. Sqlite was installed with pear. Reproduce code: --------------- # The table 'foo' exists and has data in it. # returns data. if ($db = @sqlite_open('test.db', 0666, $sqliteerror)) { $result = sqlite_query($db,'SELECT * from "fo'); var_dump(sqlite_fetch_array($result)); } else { die ($sqliteerror); } # Changing the name to 'foo' returns a # 'no such table' error