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
 [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 11:01:30 2024 UTC