clockworklabs / clockworklabs/SpacetimeDB
Bug: `Vec<u64>` column is displayed ambiguously in `spacetime sql`
@clockwork-labs-bot is already working on this.
Since Jun 17, 2026.
- Dominant language
- Rust
- Stars
- 25.2k
- Forks
- 1.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 46
Description
When querying a table with a Vec<u64> column type using the spacetime sql command, the vector values are displayed without any delimiters, making them ambiguous and potentially misleading.
Steps to Reproduce
- Create a table with a
Vec<u64>column (e.g.,entities) - Insert data with multiple values in the vector (e.g.,
[1, 2]) - Run query:
spacetime sql --server local my-db "SELECT * FROM grid_sector"
Current Behavior
WARNING: This command is UNSTABLE and subject to breaking changes.
id | map_id | x | y | entities
-----+--------+---+---+----------
405 | 1 | 0 | 0 | 21
The entities column shows 21, which appears to be a concatenation of the vector values [1, 2].
Expected Behavior
The output should clearly indicate that this is a vector with multiple values, for example:
id | map_id | x | y | entities
-----+--------+---+---+----------
405 | 1 | 0 | 0 | [1, 2]
or with comma separation:
id | map_id | x | y | entities
-----+--------+---+---+----------
405 | 1 | 0 | 0 | 1, 2
Impact
This creates significant confusion for users, as 21 looks like a single entity ID rather than two separate IDs (1 and 2). This could lead to incorrect data interpretation and bugs.
Proposed Solution
Add delimiters (commas, brackets, or other separators) when displaying vector column values to clearly distinguish between:
- A single value:
21 - Multiple values:
[1, 2]or1, 2
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the issue through the spacetime sql command using a table with a Vec<u64> column and multiple values. Trace the SQL CLI's value-display formatting, then verify that vector elements are visibly separated while single values remain unambiguous. An open pull request is already linked to this issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust, sql
- Domain
- cli, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 25/100