EVOLUTION-MANAGER

Edit File: index_multiple_column_primary_delete.result

drop table if exists listing; set names utf8; create table scores ( name char(30) not null, score int not null, primary key (name, score) ) default charset utf8; show create table scores; Table Create Table scores CREATE TABLE `scores` ( `name` char(30) NOT NULL, `score` int(11) NOT NULL, PRIMARY KEY (`name`,`score`) ) ENGINE=Mroonga DEFAULT CHARSET=utf8 insert into scores (name, score) values("Taro Yamada", 29); insert into scores (name, score) values("Taro Yamada", -12); insert into scores (name, score) values("Jiro Yamada", 27); insert into scores (name, score) values("Taro Yamada", 10); select * from scores; name score Jiro Yamada 27 Taro Yamada -12 Taro Yamada 10 Taro Yamada 29 delete from scores where name = "Taro Yamada" and score = 10; select * from scores where name = "Taro Yamada" and (score >= -12 and score < 29); name score Taro Yamada -12 drop table scores;