dolthub / dolthub/dolthub-issues

Optimized cell button queries for queries with more than one table

Open
#412 4 comments 0 reactions 1 assignee Claimed by @liuliu-dev View on GitHub
bug
Dominant language
No language data
Stars
5
Forks
0
PR merge metrics
No merged PRs in 30d

Description

this query for example:
on prod:
https://www.dolthub.com/repositories/liuliu/us-jails-1/query/main?active=Tables&q=SELECT+*+FROM+%60incidents%60+%2C+%60jails%60++where+%60incidents%60.%60id%60+%3D+%60jails%60.%60id%60+ORDER+BY+%60start_date%60+ASC%2C+%60end_date%60+ASC+LIMIT+200

on dev:
https://dolthub.awsdev.ld-corp.com/repositories/liuliu/us-jails/query/main?active=Tables&q=SELECT+*+FROM+%60incidents%60+%2C+%60jails%60++where+%60incidents%60.%60id%60+%3D+%60jails%60.%60id%60+ORDER+BY+%60start_date%60+ASC%2C+%60end_date%60+ASC+LIMIT+200

clicking hide a column button, will see query error

the reason is the query is not parsed correctly to get the right table name list.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.