tauri-apps / tauri-apps/plugins-workspace

[bug] MySQL VARCHAR incorrectly interpreted as VARBINARY

Open
#2,274 3 comments 0 reactions 0 assignees View on GitHub
good first issue plugin: sql status: upstream type: bug
Dominant language
Rust
Stars
1.8k
Forks
602
Avg merge
4d 14h
Merged PRs (30d)
9

Description

## Description

I'm currently using `tauri-plugin-sql` in my project with mysql, but in some tables, fields with the `VARCHAR` type are incorrectly interpreted as `VARBINARY` and return an error:

```
unsupported datatype: VARBINARY.
```

I found a similar issue in `sqlx` repo [here](https://github.com/launchbadge/sqlx/issues/3387) and the [pr in comments](https://github.com/theseus-rs/rsql/pull/198) show that rolling back to version v0.7.4 resolves the issue.

I locally modified the version to 0.7.4 and downgraded the `tauri-plugin-sql` to `2.0.0-beta.9`, which resolved the problem.

But I am concerned about this would lose some bug fix of this plugin, so If it's possible to rollback the version of `sqlx` to 0.7 before they resolve it?

## Tauri info output

```
[✔] Environment
- OS: Mac OS 15.2.0 arm64 (X64)
✔ Xcode Command Line Tools: installed
✔ rustc: 1.83.0 (90b35a623 2024-11-26)
✔ cargo: 1.83.0 (5ffbef321 2024-10-29)
✔ rustup: 1.27.1 (54dd3d00f 2024-04-24)
✔ Rust toolchain: stable-aarch64-apple-darwin (default)
- node: 18.20.4
- pnpm: 9.15.1
- npm: 10.7.0
- bun: 1.1.30

[-] Packages
- tauri 🦀: 2.1.1
- tauri-build 🦀: 2.0.3
- wry 🦀: 0.47.2
- tao 🦀: 0.30.8
- @tauri-apps/api : 2.1.1 (outdated, latest: 2.2.0)
- @tauri-apps/cli : 2.1.0 (outdated, latest: 2.2.2)

[-] Plugins
- tauri-plugin-sql 🦀: 2.0.0-beta.9
- @tauri-apps/plugin-sql : 2.2.0
- tauri-plugin-store 🦀: 2.2.0
- @tauri-apps/plugin-store : 2.2.0
- tauri-plugin-log 🦀: 2.2.0
- @tauri-apps/plugin-log : not installed!

[-] App
- build-type: bundle
- CSP: unset
- frontendDist: ../dist
- devUrl: http://localhost:3000/
- framework: Vue.js (Nuxt)
- bundler: Webpack
```

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.