I have a table with a PRIMARY KEY of type "BIG_INT unsigned auto_increment". This key column is called 'id'.
When I perform the following statements:
my $QUERY = "SELECT *\nFROM table\nWHERE `id` = 1;";
my $sth = $db->prepare($QUERY);
$sth->execute();
the execution hangs on the execute call. As soon as I drop the WHERE-clause, the query executes normally.
What am I doing wrong?
Using MySql server 5.0.89-community and DBD::mysqlPP version 0.04
I wish I could use DBD::mysql, but I do not have shell access to the web server which I need to install this module.
EDIT (8/23/2010):
I found out this is a known bug in mysqlPP (see
https://rt.cpan.org/Public/Bug/Display.html?id=36645). Unfortunately mysqlPP seems no longer to be developed/supported as the latest release was done in 2002 and there are multiple bugs open on the latest version (even bugs posted 7 years ago).
Seems I have to find a way to install the DBD::mysql on the webserver and use that one instead of the DBD::mysqlPP
Edited 1 time(s). Last edit at 08/23/2010 04:56AM by Marcel Versteeg.