tauri-apps / tauri-apps/plugins-workspace
[bug] MySQL VARCHAR incorrectly interpreted as VARBINARY
- 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
Assessment
This issue has not been assessed yet.