You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The TPC-H query #7 is returning a different type on Vitess than it does on MySQL.
Error from the vitess-tester run:
for column l_year field types do not match
Not equal:
MySQL: INT32
Vitess: INT64
The query is:
select supp_nation,
cust_nation,
l_year,
sum(volume) as revenue
from (selectn1.n_nameas supp_nation,
n2.n_nameas cust_nation,
extract(year from l_shipdate) as l_year,
l_extendedprice * (1- l_discount) as volume
from supplier,
lineitem,
orders,
customer,
nation n1,
nation n2
where s_suppkey = l_suppkey
and o_orderkey = l_orderkey
and c_custkey = o_custkey
and s_nationkey =n1.n_nationkeyand c_nationkey =n2.n_nationkeyand (
(n1.n_name='JAPAN'andn2.n_name='INDIA')
or (n1.n_name='INDIA'andn2.n_name='JAPAN')
)
and l_shipdate between '1995-01-01'and'1996-12-31') as shipping
group by supp_nation,
cust_nation,
l_year
order by supp_nation,
cust_nation,
l_year;
The text was updated successfully, but these errors were encountered:
The TPC-H query #7 is returning a different type on Vitess than it does on MySQL.
Error from the
vitess-tester
run:The query is:
The text was updated successfully, but these errors were encountered: