[IGNITE-12372] Thin Jdbc driver with collocated=true return per node results

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.7.6
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Sergey Kozlov
• Created: 14/Nov/19 10:52
• Updated: 14/Nov/19 10:52

Description

1. Start two nodes (in-memory)
2. Run sqlline {
   Unknown macro: {>binsqlline.bat -d org.apache.ignite.IgniteJdbcThinDriver -u jdbc}

   }

3. Create a table and select aggregation functions:

: jdbc:ignite:thin://127.0.0.1/> create table t1 (a int not null primary key, b varchar) with "template=partitioned";
No rows affected (0,15 seconds)
0: jdbc:ignite:thin://127.0.0.1/> insert into t1 values (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd');
4 rows affected (0,091 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select * from t1;
+--------------------------------+--------------------------------+
| A | B |
+--------------------------------+--------------------------------+
| 1 | a |
| 2 | b |
| 4 | d |
| 3 | c |
+--------------------------------+--------------------------------+
4 rows selected (0,074 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select count(*) from t1;
+--------------------------------+
| COUNT(*) |
+--------------------------------+
| 3 |
| 1 |
+--------------------------------+
2 rows selected (0,011 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select min(a), max(b) from t1;
+--------------------------------+--------------------------------+
| MIN(A) | MAX(B) |
+--------------------------------+--------------------------------+
| 1 | d |
| 3 | c |
+--------------------------------+--------------------------------+
2 rows selected (0,012 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select min(a), max(a) from t1;
+--------------------------------+--------------------------------+
| MIN(A) | MAX(A) |
+--------------------------------+--------------------------------+
| 1 | 4 |
| 3 | 3 |
+--------------------------------+--------------------------------+
2 rows selected (0,01 seconds)
0: jdbc:ignite:thin://127.0.0.1/>