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

Unable to process more than 11 function columns in SELECT Query MySQL #17

Open
saklanipankaj opened this issue Jun 27, 2019 · 1 comment
Labels

Comments

@saklanipankaj
Copy link

SELECT SUM(t1.a*t2.b), AVG(t2.a-t1.b), SUM(t2.b/t1.a), COUNT(t2.a+t1.b), AVG(t2.a*t1.b), SUM(t1.b-t2.a), COUNT(t2.a*t1.b), AVG(t2.a/t1.b),SUM(t1.b+t2.a), COUNT(t1.b/t2.a), AVG(t1.b-t2.a), SUM(b*t1.t2.a)
FROM t1, t2;

ERROR 13180 (HY000): Unknown column 't1.a' in 'field list'

Ambiguous Error Statement is returned when number of function columns exceed 11 in SELECT Query in MySQL.

@cheziyi
Copy link
Member

cheziyi commented Jun 27, 2019

Should be related to #9, will investigate.

@cheziyi cheziyi added the bug label Jun 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants