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.

Sign up for GitHub

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

Jump to bottom

Generated Columns added to table result in index error #8959

Open

coffeegoddd opened this issue Mar 7, 2025 · 1 comment

Labels

Contributor

coffeegoddd commented Mar 7, 2025

After adding generated columns to a table, running a count query returns an error.

Dolt version 1.50.2

Public DB: https://www.dolthub.com/repositories/dolthub/robot_blogger_v1

Repro steps:

robot_blogger_v1 % dco generated-index-bug-llama3
Switched to branch 'generated-index-bug-llama3'
robot_blogger_v1 % dolt sql -q "select count(*) from langchain_dolt_embedding;"
error on line 1 for query select count(*) from langchain_dolt_embedding: unable to find field with index 1 in row of 1 columns

Member

zachmu commented Mar 7, 2025

@max-hoffman @nicktobey it looks like there's some count(*) optimization that's incompatible with generated columns.

timsehn added bug analyzer labels

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment