MDB2 bug manager module

Hi,

I found an annoying bug in MDB2's manager module: the function
listDatabases() only returns database names in lowercase format. Which
is slightly annoying when one wants to feed the output of the
listDatabases()-function to shell functions such as mysqlmanager which
are case sensitive.

Where can I submit such a simple bug/feature request for the MDB2
manager module? Apparently, the bug database (ie.
http://pear.php.net/bugs/report.php?package=MDB2) is only available for
people who have the time to write patches, which is a bit over the top
when you just want to collect simple bugs. Not all of us are
PEAR-developers, right?

thanks,
Bram

Hi Bram,

Bram Kuijper wrote:
> I found an annoying bug in MDB2's manager module: the function
> listDatabases() only returns database names in lowercase format. Which
> is slightly annoying when one wants to feed the output of the
> listDatabases()-function to shell functions such as mysqlmanager which
> are case sensitive.

Is this maybe only caused by the portability settings?
http://pear.php.net/manual/en/packag...ortability.php

> Where can I submit such a simple bug/feature request for the MDB2
> manager module? Apparently, the bug database (ie.
> http://pear.php.net/bugs/report.php?package=MDB2) is only available for
> people who have the time to write patches, which is a bit over the top
> when you just want to collect simple bugs. Not all of us are
> PEAR-developers, right?

You don't need to upload a patch. Simply reporting a problem is fine.

Regards,
Mark

--
http://www.markwiesemann.eu

okay, some further research indeed pointed out that this is due to the
field_case option in MySQL, which is by default lowercase. The only
alternative is however to let all the database names be uppercase, at
least according to the field_case description in the documentation. Is
there just no way in MDB2 to preserve the original case, so that
mixed-case names are just preserved?

thanks in advance,

Bram Kuijper

Mark Wiesemann wrote:
> Hi Bram,
>
> Bram Kuijper wrote:
>
>> I found an annoying bug in MDB2's manager module: the function
>> listDatabases() only returns database names in lowercase format. Which
>> is slightly annoying when one wants to feed the output of the
>> listDatabases()-function to shell functions such as mysqlmanager which
>> are case sensitive.
>>
>
> Is this maybe only caused by the portability settings?
> http://pear.php.net/manual/en/packag...ortability.php
>
>
>> Where can I submit such a simple bug/feature request for the MDB2
>> manager module? Apparently, the bug database (ie.
>> http://pear.php.net/bugs/report.php?package=MDB2) is only available for
>> people who have the time to write patches, which is a bit over the top
>> when you just want to collect simple bugs. Not all of us are
>> PEAR-developers, right?
>>
>
> You don't need to upload a patch. Simply reporting a problem is fine.
>
> Regards,
> Mark
>
>


--

---------------------------------------------------------------
Bram Kuijper
Theoretical Biology Group
University of Groningen
PO Box 14
9750 AA Haren, the Netherlands
tel: +31 50 363 80 94
fax: +31 50 363 34 00
e-mail: a.l.w.kuijper@rug.nl
---------------------------------------------------------------

Bram Kuijper wrote:
> okay, some further research indeed pointed out that this is due to the
> field_case option in MySQL, which is by default lowercase. The only
> alternative is however to let all the database names be uppercase, at
> least according to the field_case description in the documentation. Is
> there just no way in MDB2 to preserve the original case, so that
> mixed-case names are just preserved?

It looks like only turning off all portability features could solve your
problem. (See Example 35-1 on the manual page.)

Regards,
Mark

--
http://www.markwiesemann.eu

Bram Kuijper wrote:

> I found an annoying bug in MDB2's manager module: the function
> listDatabases() only returns database names in lowercase format. Which
> is slightly annoying when one wants to feed the output of the
> listDatabases()-function to shell functions such as mysqlmanager which
> are case sensitive.

just disable the MDB2_PORTABILITY_FIX_CASE portability option:

$db->setOption('portability', MDB2_PORTABILITY_ALL ^
MDB2_PORTABILITY_FIX_CASE);

Best regards,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
__________________________________________________ _________________
Quipo Free Internet - 2 email, 150 Mb di spazio web e molto di più.
ADSL, Hardware & Software Online Store