dolthub / dolthub/dolthub-issues

Cell history queries timing out

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

Description

Cell history queries that return immediately using Dolt are timing out on DoltHub

Repro:
https://www.dolthub.com/repositories/dolthub/SHAQ/query/main?q=SELECT+diff_type%2C+%60from_player_id%60%2C+%60to_player_id%60%2C+%60from_nba_player_id%60%2C+%60to_nba_player_id%60%2C+%60from_date_of_birth%60%2C+%60to_date_of_birth%60%2C+%60from_first_name%60%2C+%60to_first_name%60%2C+%60from_last_name%60%2C+%60to_last_name%60%2C+%60from_height_inches%60%2C+%60to_height_inches%60%2C+%60from_weight_lb%60%2C+%60to_weight_lb%60%2C+from_commit%2C+from_commit_date%2C+to_commit%2C+to_commit_date%0AFROM+%60dolt_diff_players%60%0AWHERE+%60to_player_id%60+%3D+%224%22+OR+%60from_player_id%60+%3D+%224%22%0AORDER+BY+to_commit_date+DESC&active=

In Dolt:
```
SHAQ % dolt sql
# Welcome to the DoltSQL shell.
# Statements must be terminated with ';'.
# "exit" or "quit" (or Ctrl-D) to exit.
SHAQ> SELECT diff_type, `from_player_id`, `to_player_id`, `from_nba_player_id`, `to_nba_player_id`, `from_date_of_birth`, `to_date_of_birth`, `from_first_name`, `to_first_name`, `from_last_name`, `to_last_name`, `from_height_inches`, `to_height_inches`, `from_weight_lb`, `to_weight_lb`, from_commit, from_commit_date, to_commit, to_commit_date
-> FROM `dolt_diff_players`
-> WHERE `to_player_id` = "4" OR `from_player_id` = "4"
-> ORDER BY to_commit_date DESC;
+-----------+----------------+--------------+--------------------+------------------+--------------------+-------------------------------+-----------------+---------------+----------------+--------------+--------------------+------------------+----------------+--------------+----------------------------------+----------------------------------+----------------------------------+-----------------------------------+
| diff_type | from_player_id | to_player_id | from_nba_player_id | to_nba_player_id | from_date_of_birth | to_date_of_birth | from_first_name | to_first_name | from_last_name | to_last_name | from_height_inches | to_height_inches | from_weight_lb | to_weight_lb | from_commit | from_commit_date | to_commit | to_commit_date |
+-----------+----------------+--------------+--------------------+------------------+--------------------+-------------------------------+-----------------+---------------+----------------+--------------+--------------------+------------------+----------------+--------------+----------------------------------+----------------------------------+----------------------------------+-----------------------------------+
| modified | 4 | 4 | 51 | 51 | NULL | 1969-03-09 00:00:00 +0000 UTC | Mahmoud | Mahmoud | Abdul-Rauf | Abdul-Rauf | NULL | 73 | NULL | 162 | pppd531c6pknbt228su6fenth1h5kl00 | 2021-11-02 18:51:15.17 +0000 UTC | dvgtgm3s4opm12npkct8oi7lidf3m4j9 | 2021-11-02 19:25:10.331 +0000 UTC |
+-----------+----------------+--------------+--------------------+------------------+--------------------+-------------------------------+-----------------+---------------+----------------+--------------+--------------------+------------------+----------------+--------------+----------------------------------+----------------------------------+----------------------------------+-----------------------------------+
SHAQ>
```

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.