[jira] [Commented] (IGNITE-12068) puzzling select result

2019-08-15 Thread JerryKwan (JIRA)


[ 
https://issues.apache.org/jira/browse/IGNITE-12068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908579#comment-16908579
 ] 

JerryKwan commented on IGNITE-12068:


[~dmagda], What's the ETA of version of 2.7.6?

> 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
>Assignee: Ivan Pavlukhin
>Priority: Blocker
> Fix For: 2.7.6
>
>  Time Spent: 10m
>  Remaining Estimate: 0h
>
> 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)


[jira] [Commented] (IGNITE-12068) puzzling select result

2019-08-14 Thread JerryKwan (JIRA)


[ 
https://issues.apache.org/jira/browse/IGNITE-12068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)


[jira] [Created] (IGNITE-12068) puzzling select result

2019-08-13 Thread JerryKwan (JIRA)
JerryKwan created IGNITE-12068:
--

 Summary: 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


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)