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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: lay at amiga dot hu
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 07:01:28 2024 UTC