dolthub / dolthub/dolthub-issues

Query returns in 0.32 seconds locally. Times out on DoltHub

Open
#563 1 comment 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:

```sql
SELECT * FROM `writings` WHERE phelps IS NULL ORDER BY RAND() LIMIT 10;
```

This returns in 0.32 seconds locally but times out on DoltHub, even with the new 60s query timeout.

https://www.dolthub.com/repositories/holywritings/bahaiwritings/query/main?active=Tables&q=SELECT+*%0AFROM+%60writings%60%0AWHERE+phelps+IS+NULL%0AORDER+BY+RAND()%0ALIMIT+10%3B%0A

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.