PEAR Bug Search Results
http://pear.php.net/bugs/search.php?cmd=display&package_name%5B0%5D=MDB2_Driver_ibase&PHPSESSID=6sh8hov6085gl1gd4s43b0k8h0
Search Results
en-us
pear-webmaster@lists.php.net
pear-webmaster@lists.php.net
hourly
1
2000-01-01T12:00+00:00
PEAR Bugs
http://pear.php.net/gifs/pearsmall.gif
http://pear.php.net/bugs
-
MDB2_Driver_ibase: Bug 16741 [Open] Manager::listTableIndexes and listTableContraints should check NULL or 0
http://pear.php.net/bugs/16741
MDB2_Driver_ibase Bug
Reported by nilya
2009-10-26T12:16:17+00:00
PHP: 5.2.5 OS: Any Package Version: CVS
Description:
------------
As stated here: http://www.alberton.info/firebird_sql_meta_info.html (see comment "Lorenzo Alberton, 03 October 2009 19:17"), there are need to check RDB$UNIQUE_FLAG for NULL or 0.
Test script:
---------------
/*
SQL:
CREATE TABLE TABLE2 (
ID INTEGER NOT NULL,
DATEDATE TIMESTAMP
);
ALTER TABLE TABLE2 ADD CONSTRAINT PK_TABLE2 PRIMARY KEY (ID);
CREATE INDEX IDX_TABLE2_DATE ON TABLE2 (DATEDATE);
*/
require_once "MDB2.php";
$db =& MDB2::connect('ibase(firebird)://SYSDBA:masterkey@db/test');
$db->loadModule('Manager');
var_dump($db->listTableIndexes('table2'));
var_dump($db->listTableConstraints('table2'));
Expected result:
----------------
array(1) {
[0]=>
string(15) "idx_table2_date"
}
array(1) {
[0]=>
string(9) "pk_table2"
}
Actual result:
--------------
array(0) {
}
array(2) {
[0]=>
string(9) "pk_table2"
[1]=>
string(15) "idx_table2_date"
}
(depends on Firebird version)]]>
MDB2_Driver_ibase Bug
Reported by nilya
2009-10-26T12:16:17+00:00
PHP: 5.2.5 OS: Any Package Version: CVS
Description:
------------
As stated here: http://www.alberton.info/firebird_sql_meta_info.html (see comment "Lorenzo Alberton, 03 October 2009 19:17"), there are need to check RDB$UNIQUE_FLAG for NULL or 0.
Test script:
---------------
/*
SQL:
CREATE TABLE TABLE2 (
ID INTEGER NOT NULL,
DATEDATE TIMESTAMP
);
ALTER TABLE TABLE2 ADD CONSTRAINT PK_TABLE2 PRIMARY KEY (ID);
CREATE INDEX IDX_TABLE2_DATE ON TABLE2 (DATEDATE);
*/
require_once "MDB2.php";
$db =& MDB2::connect('ibase(firebird)://SYSDBA:masterkey@db/test');
$db->loadModule('Manager');
var_dump($db->listTableIndexes('table2'));
var_dump($db->listTableConstraints('table2'));
Expected result:
----------------
array(1) {
[0]=>
string(15) "idx_table2_date"
}
array(1) {
[0]=>
string(9) "pk_table2"
}
Actual result:
--------------
array(0) {
}
array(2) {
[0]=>
string(9) "pk_table2"
[1]=>
string(15) "idx_table2_date"
}
(depends on Firebird version)]]>
2009-10-26T12:16:17+00:00
ilpochta at gmail dot com
MDB2_Driver_ibase Bug