php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31979 msql_fetch_field() not reporting unique keys
Submitted: 2005-02-15 05:26 UTC Modified: 2008-10-24 16:07 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: danielc at analysisandsolutions dot com Assigned: zeev (profile)
Status: Wont fix Package: mSQL related
PHP Version: 5CVS-2005-02-15 OS: NetBSD 2.0
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: danielc at analysisandsolutions dot com
New email:
PHP Version: OS:

 

 [2005-02-15 05:26 UTC] danielc at analysisandsolutions dot com
Description:
------------
One of the properties returned by msql_fetch_field() is "unique".  It is supposed to contain 1 if the column in question is part of a unique key and 0 if it's not.  But it always returns 0.

Reproduce code:
---------------
$con = msql_connect();
$db  = msql_select_db('ptdb', $con);
msql_query('CREATE TABLE blah (i INT)', $con);
msql_query('CREATE UNIQUE INDEX bi ON blah (i)', $con);
$result = msql_query('SELECT * FROM blah', $con);
$info = msql_fetch_field($result);
print_r($info);
msql_query('DROP TABLE blah', $con);

Expected result:
----------------
stdClass Object
(
    [name] => i
    [table] => blah
    [not_null] => 0
    [unique] => 1
    [type] => int
)

Actual result:
--------------
stdClass Object
(
    [name] => i
    [table] => blah
    [not_null] => 0
    [unique] => 0
    [type] => int
)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-09-12 19:27 UTC] sniper@php.net
Assigned to the maintainer of ext/msql. (although I doubt Zeev uses msql anymore..or really is the maintainer, but his name is in CREDITS :)

 [2008-10-24 16:07 UTC] jani@php.net
msql support has ended.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 16:01:28 2024 UTC