Issue 360: Pluf_BooleanToDb() bug or bad usage?

Reported by Jakub Vitak, Dec 9, 2009

true/false is escaped twice!

$active = true/false;
$db = Pluf::db();
$db_tf = Pluf_DB_BooleanToDb( $active, $db );
$sql = new Pluf_SQL( "owner=%s AND active=%s",
 array( $request->user, $db_tf ));

die(var_dump( $sql->gen() ));

generates:

string(28) "owner='1' AND active='\'1\''"

Comment 1 by Jakub Vitak, Dec 10, 2009

need to say I am using MySQL backend currently

Comment 2 by Loïc d'Anterroches, Dec 11, 2009

$active = true/false;
$db = Pluf::db();
$db_tf = Pluf_DB_BooleanToDb( $active, $db );
$sql = new Pluf_SQL( "owner=%s AND active={$db_tf}",
 array( $request->user ));
die(var_dump( $sql->gen() ));

$db_tf is already clean.

Status: WontFix

Pluf Framework