Bad output for table join results

zettadb / kunlun

KunlunBase is a distributed relational database management system(RDBMS) with complete NewSQL capabilities and robust transaction ACID guarantees and is compatible with standard SQL. Applications which used PostgreSQL or MySQL can work with KunlunBase as-is without any code change or rebuild because KunlunBase supports both PostgreSQL and MySQL connection protocols and DML SQL grammars. MySQL DBAs can quickly work on a KunlunBase cluster because we use MySQL as storage nodes of KunlunBase. KunlunBase can elastically scale out as needed, and guarantees transaction ACID under error conditions, and KunlunBase fully passes TPC-C, TPC-H and TPC-DS test suites, so it not only support OLTP workloads but also OLAP workloads. Application developers can use KunlunBase to build IT systems that handles terabytes of data, without any effort on their part to implement data sharding, distributed transaction processing, distributed query processing, crash safety, high availability, strong consistency, horizontal scalability. All these powerful features are provided by KunlunBase. KunlunBase supports powerful and user friendly cluster management, monitor and provision features, can be readily used as DBaaS.

Apache License 2.0

143 stars 20 forks source link

Issue migrated from trac ticket # 32

component: computing nodes | priority: major | resolution: fixed

2021-04-15 15:16:31: @jd-zhang created the issue

tdb1=# CREATE TABLE test_missing_target (a int, b int, c char(8), d char); CREATE TABLE tdb1=# INSERT INTO test_missing_target VALUES (0, 1, 'XXXX', 'A'), (1, 2, 'ABAB', 'b'), (2, 2, 'ABAB', 'c'), (3, 3, 'BBBB', 'D'), (4, 3, 'BBBB', 'e'), (5, 3, 'bbbb', 'F'), (6, 4, 'cccc', 'g'), (7, 4, 'cccc', 'h'), (8, 4, 'CCCC', 'I'), (9, 4, 'CCCC', 'j'); INSERT 0 10 tdb1=# SELECT x.b, count(*) FROM test_missing_target x, test_missing_target y WHERE x.a = y.a GROUP BY x.b ORDER BY x.b; b | count ---+------- 1 | 1 (1 row)

-- The results should be --- b | count ---+------- 1 | 1 2 | 2 3 | 3 4 | 4 (4 rows)

similar commands: SELECT count(*) FROM test_missing_target x, test_missing_target y WHERE x.a = y.a GROUP BY x.b ORDER BY x.b;

SELECT x.b/2, count(x.b) FROM test_missing_target x, test_missing_target y WHERE x.a = y.a GROUP BY x.b/2 ORDER BY x.b/2;

zettadb / kunlun

Bad output for table join results #417

2021-04-15 15:16:31: @jd-zhang created the issue

2021-05-24 12:13:01: @david-zhao

2021-05-24 12:13:01: @david-zhao changed owner from kunlun to david

2021-05-24 12:13:01: @david-zhao changed severity from minor to normal

2021-05-24 12:13:01: @david-zhao changed status from assigned to accepted

2021-05-25 10:21:55: @david-zhao commented

2021-05-25 10:21:55: @david-zhao

2021-07-19 15:19:48: @charleszettadb commented

2021-07-19 15:19:48: @charleszettadb set resolution to fixed

2021-07-19 15:19:48: @charleszettadb changed status from accepted to closed