Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

Unsupported syntax: &sqlparser.AndExpr{Left:(*sqlparser.AndExpr)(0xc42899c480), Right:(*sqlparser.ComparisonExpr)(0xc4289c4340)} #40

Closed
ajnavarro opened this issue Feb 26, 2018 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@ajnavarro
Copy link
Contributor

That unsupported syntax should be supported. Failing query:

select 
	sum(l_extendedprice) / 7.0 as avg_yearly 
from 
	LINEITEM, 
	PART 
where 
	p_partkey = l_partkey and 
	p_brand = 'Brand#44' and 
	p_container = 'WRAP PKG' and 
	l_quantity < (
					select 
						0.2 * avg(l_quantity) 
					from 
						LINEITEM 
					where 
						l_partkey = p_partkey
				);
@ajnavarro ajnavarro added the bug Something isn't working label Feb 26, 2018
@ajnavarro ajnavarro mentioned this issue Feb 26, 2018
14 tasks
@erizocosmico erizocosmico self-assigned this Feb 26, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants