Bug #8332

getDefinitionFromDatabase only works with lowercase db names

Details

Submitted	2006-07-31 19:20 UTC
From	hcderaad at wanadoo dot nl
Status	Bogus
Package	MDB2
PHP Version	4.4.2
OS	Linux (kernel 2.6.12)
Roadmaps	(Not assigned)

Comments

[2006-07-31 19:20 UTC] hcderaad at wanadoo dot nl

Description:
------------
getDefinitionFromDatabase quits with a "Table 'mixedCaseTableName' doesn't exist" Native error.

When tested on a database containing only lowercase table/fieldnames, the function works just fine.

This seems to be similar to this bug:
PEAR :: Bug #6835 :: getTableFieldDefinition() only works in compatibility mode lower-case
http://pear.php.net/bugs/bug.php?id=6835

Is there a possible fix that makes the function keep the table/fieldnames intact?
I'd like to use the package, but rewriting about 60 tables (containing some 500 fields) and dataobjects seems not very attractive.

Kind regards,
Hans de Raad

[2006-07-31 19:24 UTC] hcderaad at wanadoo dot nl

Forgot to mention, this happened with the MySQL driver.
Havent tested it on other RDBMS drivers, but the beforementioned bug suggests results on those will be similar.

Kind regards,
Hans de Raad

[2006-07-31 19:36 UTC] hcderaad at wanadoo dot nl

Ok, that did the trick (after setting the seqcol_name to id, i´m using DB_DataObject for the main db abstration layer).

RTFM a little better i suppose....

Thanks for the quick reply,

kind regards,
Hans de Raad