|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56001 "pragma short_column_names=on" don't works
Submitted: 2004-03-12 07:34 UTC Modified: 2004-03-12 08:32 UTC
From: lay at amiga dot hu Assigned:
Status: Not a bug Package: SQLite (PECL)
PHP Version: 4.3.3 OS: Linux
Private report: No CVE-ID: None
 [2004-03-12 07:34 UTC] lay at amiga dot hu
"pragma short_column_names=on" don't works
URL (with source) that reproduces the bug:

Reproduce code:
function Test($query) {
	echo "<b><code>".$query."</code></b>";
	echo "<pre>";print_r($tomb);echo "</pre>";
echo "<h3>PHP: ".PHP_VERSION.", ".PHP_OS."</h3><h3>Libversion: ".sqlite_libversion()."</h3><h3>Libencoding: ".sqlite_libencoding()."</h3>";
sqlite_query(CONN,"pragma short_column_names=on");
sqlite_query(CONN,"create table nevek1(id1 int,nev1 varchar(10),login1 varchar(10))");
sqlite_query(CONN,"insert into nevek1(id1,nev1,login1)values(1,'J?zsi','joco')");
sqlite_query(CONN,"create table nevek2(id2 int,nev2 varchar(10),login2 varchar(10))");
sqlite_query(CONN,"insert into nevek2(id2,nev2,login2)values(1,'Zoli','zozo')");
Test("select n1.* from nevek1 n1");
Test("select n1.*,n2.* from nevek1 n1,nevek2 n2 where n1.id1=n2.id2");
Test("select n1.id1,n1.nev1,n1.login1,n2.id2,n2.nev2,n2.login2 from nevek1 n1,nevek2 n2 where n1.id1=n2.id2");


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2004-03-12 08:32 UTC]
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at and the instructions on how to report
a bug at

Bundled version of sqlite is 2.8.11, which does not 
implement this option. 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Thu May 13 20:01:24 2021 UTC