php.net |  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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
33 + 22 = ?
Subscribe to this entry?

 
 [2004-03-12 07:34 UTC] lay at amiga dot hu
Description:
------------
"pragma short_column_names=on" don't works
URL (with source) that reproduces the bug:
http://crimson.jihad.hu/sqlitetest.php


Reproduce code:
---------------
<?
function Test($query) {
	echo "<b><code>".$query."</code></b>";
	$handle=sqlite_query(CONN,$query);
	$tomb=sqlite_fetch_array($handle);
	echo "<pre>";print_r($tomb);echo "</pre>";
}
dl("sqlite.so");
echo "<h3>PHP: ".PHP_VERSION.", ".PHP_OS."</h3><h3>Libversion: ".sqlite_libversion()."</h3><h3>Libencoding: ".sqlite_libencoding()."</h3>";
define("CONN",sqlite_open(":memory:"));
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");
sqlite_close(CONN);
?>


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

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

Bundled version of sqlite is 2.8.11, which does not 
implement this option. 
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Fri Dec 06 13:01:23 2019 UTC