search

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.
http://www.kunlunbase.com
Apache License 2.0
143 stars 20 forks source link

TPC-DS: MySQL:error: 1064, You have an error in your SQL syntax #648

Open jd-zhang opened 2 years ago

jd-zhang commented 2 years ago

Issue migrated from trac ticket # 429

component: computing nodes | priority: major

2022-01-25 16:21:10: charles@zettadb.com created the issue

sql:

select  c_last_name
       ,c_first_name
       ,ca_city
       ,bought_city
       ,ss_ticket_number
       ,amt,profit
 from
   (select ss_ticket_number
          ,ss_customer_sk
          ,ca_city bought_city
          ,sum(ss_coupon_amt) amt
          ,sum(ss_net_profit) profit
    from store_sales,date_dim,store,household_demographics,customer_address
    where store_sales.ss_sold_date_sk = date_dim.d_date_sk
    and store_sales.ss_store_sk = store.s_store_sk
    and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
    and store_sales.ss_addr_sk = customer_address.ca_address_sk
    and (household_demographics.hd_dep_count = 6 or
         household_demographics.hd_vehicle_count= 3)
    and date_dim.d_dow in (6,0)
    and date_dim.d_year in (1999,1999+1,1999+2)
    and store.s_city in ('Oakland','Riverside','Union','Salem','Greenwood')
    group by ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city) dn,customer,customer_address current_addr
    where ss_customer_sk = c_customer_sk
      and customer.c_current_addr_sk = current_addr.ca_address_sk
      and current_addr.ca_city <> bought_city
  order by c_last_name
          ,c_first_name
          ,ca_city
          ,bought_city
          ,ss_ticket_number
  limit 100;

log：

psql:q46.sql:36: ERROR: Kunlun-db: MySQL storage node (2, 2) returned error: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Union,Salem,Greenwood)' at line 1.
  • 所有TPC-DS语句都在128的 /home/kunlun/TPC/TPC-Tools/TPC-DS/query 下
jd-zhang commented 2 years ago

2022-01-25 16:22:11: charles@zettadb.com commented

  • 除开这两个sql还有 q48.sql、q85.sql 这两个sql也有同样的错误
jd-zhang commented 2 years ago

2022-01-25 16:22:58: charles@zettadb.com changed component from DBA GUI to computing nodes

jd-zhang commented 2 years ago

2022-01-25 16:22:58: charles@zettadb.com

jd-zhang commented 2 years ago

2022-01-25 16:22:58: charles@zettadb.com set owner to david

jd-zhang commented 2 years ago

2022-01-25 16:22:58: charles@zettadb.com changed severity from trivial to major

jd-zhang commented 2 years ago

2022-01-25 16:22:58: charles@zettadb.com changed status from new to assigned

jd-zhang commented 2 years ago

2022-06-06 11:01:47: zhaowei@zettadb.com changed owner from david to smith

jd-zhang commented 2 years ago

2022-06-08 16:36:37: smith changed status from assigned to accepted