DROP TABLE IF EXISTS `prefix_test`;
CREATE TABLE IF NOT EXISTS `prefix_test` (
`task_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`step` float(6,2) NOT NULL,
`done` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`task_id`),
KEY `order_id` (`order_id`),
KEY `step` (`step`),
KEY `orderstep` (`order_id`,`step`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `prefix_test` VALUES (1,36907,3.20,0);
INSERT INTO `prefix_test` VALUES (2,36907,3.21,0);
INSERT INTO `prefix_test` VALUES (3,37907,4.13,0);
$criteria=new CDbCriteria();
$criteria->addInCondition('order_id',array(36907));
$criteria->addInCondition('step',array(3.20));
$tests=Test::model()->findAll($criteria);
echo "Rows: ".count($tests)."<br>";
#Returns Rows: 0
在Yii日志中查询
SELECT * FROM `prefix_test` `t` WHERE (order_id=:ycp0) AND (step=:ycp1). Bound with :ycp0=36907, :ycp1=3.2
SELECT * FROM `prefix_test` `t` WHERE (order_id=36907) AND (step='3.2')
这将解决您的问题
ALTER TABLE `prefix_test` CHANGE `step` `step` decimal(10,2) NOT NULL;
之后,您的查询返回
#Returns Rows: 1