search

surrealdb / surrealist

Surrealist is the ultimate way to visually manage your SurrealDB database
https://surrealist.app/
MIT License
1.11k stars 86 forks source link

Record inspector doesn't seem to support Array-based Record IDs #238

Closed SigismondPhilippe closed 4 months ago

SigismondPhilippe commented 7 months ago

Describe the bug The record inspector shows a "record not found in database" message when clicking a record that has array-based record id.

To Reproduce Steps to reproduce the behavior:

  1. CREATE a record with an array-based record id, according to the example in the doc: image

  2. Display it with no problem: image

  3. Go to the explorer, click on the table, click on the record so that the inspector shows up: image

Expected behavior At step 3, it should not show an error message, but the content of the record.

Environment:

Platform: Desktop
OS: Windows_NT
Architecture: x86_64
WebView: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0
Version: 2.0.3
Flags: featureFlags: false, models_view: true, apidocs_view: true, themes: false, newsfeed: true
macjuul commented 7 months ago

This is likely related to an issue in SurrealDB regarding datetime precision

Garrett-Ulmer commented 7 months ago

I am seeing this bug as well. When I revert to Surrealist 1.11.8 and connect to the same db instance I can view the record as normal.

@macjuul Your comment appears correct. I can properly view an array-based record id without a timestamp, only the timestamped ones appear to break.

Using surreal-v1.4.2

Platform: Desktop OS: Ubuntu 22.04 Architecture: x86_64

macjuul commented 4 months ago

This was caused by an issue in the surrealdb parser, which has been fixed in the upcoming SurrealDB 2.0 release