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

query error: unable to find field with index 26 in row of 1 columns #73

Open
EminUZUN opened this issue Sep 4, 2023 · 1 comment
Open

Comments

@EminUZUN
Copy link

EminUZUN commented Sep 4, 2023

this code returns this error:
query error: unable to find field with index 26 in row of 1 columns
select sd.code, d.code from table1 sd left join table2 ts on ts.table1_id = sd.id left join table3 d on ts.table3_id = d.id group by d.code, sd.code

I have tried to debug the issue but it is something about "code" column. If I remove "d.code" from select it works.

This query runs on local dolt but not in doltlab.

@coffeegoddd
Copy link
Contributor

@EminUZUN can you please share the following:

SHOW CREATE TABLE table1;
SHOW CREATE TABLE table2;
SHOW CREATE TABLE table3;

I have not been able to reproduce this error on DoltLab.
Screenshot 2023-09-05 at 12 43 44 PM

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants