jim zh created KUDU-2575: ---------------------------- Summary: kudu query return wrong results Key: KUDU-2575 URL: https://issues.apache.org/jira/browse/KUDU-2575 Project: Kudu Issue Type: Bug Components: impala Affects Versions: 1.6.0 Reporter: jim zh
impala> CREATE TABLE test1( name string, description string, xtype int, PRIMARY KEY(name) ) STORED AS kudu; impala> insert into `test1` (`name`,`description`,`xtype`) values ("t1:a\"'x\\bbx", 'aaa', 1),("t2:a\"'x\\bbx", 'bbb', 1),("t3:a\"'x\\bbx", 'ccc', 1); impala> select name,description from test1 where name="t1:a\"'x\\bbx"; Fetched {color:#FF0000}0{color} row(s) in 0.16s impala> select name,description from test1 where name in ("t1:a\"'x\\bbx"); Fetched {color:#FF0000}0{color} row(s) in 0.05s impala> select name,description from test1 where name like "t1:a\"'x\\bbx"; +-------------+-------------+ | name | description | +-------------+-------------+ | t1:a"'x\bbx | aaa | +-------------+-------------+ Fetched {color:#FF0000}1{color} row(s) in 0.16s impala> select name,description from test1 where name in (select "t1:a\"'x\\bbx"); +-------------+-------------+ | name | description | +-------------+-------------+ | t1:a"'x\bbx | aaa | +-------------+-------------+ Fetched {color:#FF0000}1{color} row(s) in 0.36s -- This message was sent by Atlassian JIRA (v7.6.3#76005)