Bug #10215

listtableconstraints dont list check constraints

Details

Request #10215	listtableconstraints dont list check constraints
Submitted	2007-02-28 10:34 UTC
From	albatista at gmail dot com
Assigned	quipo
Status	Closed
Package	MDB2_Driver_oci8
PHP Version	5.1.4
OS	Debian
Roadmaps	(Not assigned)

Comments

[2007-02-28 10:34 UTC] albatista at gmail dot com

Description:
------------
The function listTableConstraints gets a list of the constraints of a table getting the entries in USER_CONSTRAINT oracle table with the SQL
'SELECT index_name name FROM user_constraints
WHERE table_name='foo' OR table_name='FOO'
buts some constraints (check constraint) have the index_name field empty so the function don't get them.
I wonder if its better to get the field constraint_name instead of index_name in the query, resulting the query
'SELECT constraint_name name FROM user_constraints
WHERE table_name='foo' OR table_name='FOO'.
I'm programming with php Oracle 10 XE and Oracle Zend Core 2.1.0 (php 5.1.4)