Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug: explain tpch q12 failed. #218

Closed
Tracked by #217
liurenjie1024 opened this issue Jan 24, 2022 · 0 comments · Fixed by #219
Closed
Tracked by #217

bug: explain tpch q12 failed. #218

liurenjie1024 opened this issue Jan 24, 2022 · 0 comments · Fixed by #219
Assignees
Labels
type/bug Something isn't working

Comments

@liurenjie1024
Copy link
Contributor

Run following statement failed after preparing for tpch queries:

select
	l_shipmode,
	sum(case
		when o_orderpriority = '1-URGENT'
			or o_orderpriority = '2-HIGH'
			then 1
		else 0
	end) as high_line_count,
	sum(case
		when o_orderpriority <> '1-URGENT'
			and o_orderpriority <> '2-HIGH'
			then 1
		else 0
	end) as low_line_count
from
	orders,
	lineitem
where
	o_orderkey = l_orderkey
	and l_shipmode in ('FOB', 'SHIP')
	and l_commitdate < l_receiptdate
	and l_shipdate < l_commitdate
	and l_receiptdate >= date '1994-01-01'
	and l_receiptdate < date '1994-01-01' + interval '1' year
group by
	l_shipmode
order by
	l_shipmode;
@liurenjie1024 liurenjie1024 added the type/bug Something isn't working label Jan 24, 2022
@liurenjie1024 liurenjie1024 self-assigned this Jan 24, 2022
@liurenjie1024 liurenjie1024 mentioned this issue Feb 10, 2022
2 tasks
@liurenjie1024 liurenjie1024 transferred this issue from another repository Feb 10, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant