Skip to content

[Plugin-SQL] unsupported datatype: NUMERIC #3158

@isaced

Description

@isaced

Describe the bug

Unable to query data from DECIMAL-type columns in PostgreSQL.

Reproduction

CREATE TABLE products (
    id SERIAL PRIMARY KEY,
    price DECIMAL(10, 2) NOT NULL CHECK (price > 0),
);

INSERT INTO products (id, price) VALUES
('Laptop', 999.99),
('Mouse', 19.99)
db.select(SELECT * FROM products)

Expected behavior

Expected to correctly retrieve the data.

Full tauri info output

[⚠] Environment
    - OS: Mac OS 26.1.0 arm64 (X64)
    ✔ Xcode Command Line Tools: installed
    ✔ Xcode: 26.1.1
    ✔ rustc: 1.91.1 (ed61e7d7e 2025-11-07) (Homebrew)
    ✔ cargo: 1.91.1 (Homebrew)
    ⚠ rustup: not installed!
      If you have rust installed some other way, we recommend uninstalling it
      then use rustup instead. Visit https://rustup.rs/
    ⚠ Rust toolchain: couldn't be detected!
      Maybe you don't have rustup installed? if so, Visit https://rustup.rs/
    - node: 25.2.1
    - npm: 11.6.2
    - bun: 1.3.4
    - deno: deno 2.5.6

[-] Packages
    - tauri 🦀: 2.9.5
    - tauri-build 🦀: 2.5.3
    - wry 🦀: 0.53.5
    - tao 🦀: 0.34.5
    - @tauri-apps/api  ⱼₛ: 2.9.1
    - @tauri-apps/cli  ⱼₛ: 2.9.6

[-] Plugins
    - tauri-plugin-sql 🦀: 2.3.1
    - @tauri-apps/plugin-sql  ⱼₛ: 2.3.1
    - tauri-plugin-opener 🦀: 2.5.2
    - @tauri-apps/plugin-opener  ⱼₛ: 2.5.2

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

Stack trace

unsupported datatype: NUMERIC

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions