[
https://issues.apache.org/jira/browse/IGNITE-12068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16906952#comment-16906952
]
JerryKwan commented on IGNITE-12068:
------------------------------------
Hi [~Pavlukhin], thank for looking into this.
If the primary key is single, it must be only exists one result row, but if the
primary key is composite, it depends
If the primary key is an interger, we can use the filtering condition WHERE id
>= 1 and id < 2 as a temporary solution, but what should we do if it is an
string?
> puzzling select result
> ----------------------
>
> Key: IGNITE-12068
> URL: https://issues.apache.org/jira/browse/IGNITE-12068
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.7.5
> Environment: System version: CentOS Linux release 7.6.1810 (Core)
> Apache Ignite version: apache-ignite-2.7.5-1.noarch
> Reporter: JerryKwan
> Priority: Critical
>
> select using the first primary key only returns one record, but it should
> return more records.
> The following is how to reproduce this problem
> 1, create a table using
> CREATE TABLE IF NOT EXISTS Person(
> id int,
> city_id int,
> name varchar,
> age int,
> company varchar,
> PRIMARY KEY (id, city_id)
> );
> 2, insert some records
> INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3);
> INSERT INTO Person (id, name, city_id) VALUES (1, 'John Dean', 4);
> INSERT INTO Person (id, name, city_id) VALUES (2, 'Alex', 4);
> 3, query using 'select * from Person' show all of the records, expected
> [http://www.passimage.in/i/03da31c8f23cf64580d5.png]
> 4, query using 'select * from Person where id=1', only get one record, NOT
> expected
> [http://www.passimage.in/i/f5491491a70c5d796823.png]
> 5, query using 'select * from Person where city_id=4' get two records,
> expected
> [http://www.passimage.in/i/ff0ee4f5e882983d779d.png]
> Why 'select * from Person where id=1', only get one record? and how to fix
> this? Is there any special operations/configurations to do?
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
