Issues

ZF-11942: Zend_Db_Statement._stripQuoted(sql) preg_replace error!

Description

Mysql can run following $sql code,but return error when run zend_db->query($sql);

my test code is this:

$sql = "SELECT rule_id FROM baogg_rule WHERE rule_id = '19' and rule_name = '蓝润洁铺货率' and description = '' and original = '' and compile = '' and sql_fn = 'sum(#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#+#蓝润洁库存#)' and compile_sql = 'sum(37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2+37628X5X751_2)' and is_group_by_fn = '1' and state = '1' and ordering = '2' and qa_brand_id = '1' and qa_rule_id = '3' and qa_field_ids = '9' and qa_surveys_id = '1' "; $sql = preg_replace("/'(\\'|\\{2}|[^'])*'/", '', $sql); echo $sql;

Comments

No comments to display