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)
