tauri-apps / tauri-apps/plugins-workspace

[sql] Postgres UUID columns returning null

Open
#2,039 2 comments 1 reaction 0 assignees View on GitHub
plugin: sql type: bug
Dominant language
Rust
Stars
1.8k
Forks
602
Avg merge
4d 14h
Merged PRs (30d)
9

Description

Per my comment on #1375
- PostgreSQL 16
- Fresh database with test table containing a uuid column with default `gen_random_uuid()`, added a single test row
- Frontend calls `await db.select("SELECT * FROM test")`
- Record returns fine, but uuid column value is `null`

### Tauri Info
[✔] Environment
- OS: Windows 10.0.22631 x86_64 (X64)
✔ WebView2: 130.0.2849.80
✔ MSVC: Visual Studio Community 2022
✔ rustc: 1.80.0 (051478957 2024-07-21)
✔ cargo: 1.80.0 (376290515 2024-07-16)
✔ rustup: 1.27.1 (54dd3d00f 2024-04-24)
✔ Rust toolchain: stable-x86_64-pc-windows-msvc (default)
- node: 22.8.0
- npm: 10.8.2

[-] Packages
- tauri 🦀: 2.0.6
- tauri-build 🦀: 2.0.2
- wry 🦀: 0.46.3
- tao 🦀: 0.30.5
- @tauri-apps/api : 2.1.1
- @tauri-apps/cli : 2.1.0

[-] Plugins
- tauri-plugin-fs 🦀: 2.0.3
- @tauri-apps/plugin-fs : 2.0.0 (outdated, latest: 2.0.2)
- tauri-plugin-sql 🦀: 2.0.2
- @tauri-apps/plugin-sql : 2.0.1
- tauri-plugin-dialog 🦀: 2.0.3
- @tauri-apps/plugin-dialog : 2.0.1
- tauri-plugin-shell 🦀: 2.0.2
- @tauri-apps/plugin-shell : 2.0.1

[-] App
- build-type: bundle
- CSP: unset
- frontendDist: ../dist
- devUrl: http://localhost:1420/
- framework: React
- bundler: Vite

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.