search

elixir-ecto / myxql

MySQL 5.5+ driver for Elixir
Apache License 2.0
273 stars 67 forks source link

Fix: adding value 243(0xF3) as string for new versions of mysql 8.0 #165

Closed Washingtons2 closed 8 months ago

Washingtons2 commented 1 year ago

image (12)

Adding error 243 (0xF3) to library types. This PR aims to fix that issue.

wojtekmach commented 1 year ago

Could you show how to reproduce the error, i.e. what is your server version and SQL command?

Washingtons2 commented 1 year ago

Você poderia mostrar como reproduzir o erro, ou seja, qual é a versão do seu servidor e o comando SQL?

elixir 1.10.3-otp-22 erlang 22.3.4

{:myxql, "0.3.2"}, {:ecto_sql, "3.3.3"},

query = from u in User.get!(id), select: fragment("functiondata(?, ?)", u.code, ^data)

Repo.one(query)

wojtekmach commented 1 year ago

Sorry this is not enough information for me to reproduce the issue. Could you come up with a set of commands I could run on my machine to do so?

Here's a template I like to use, one starts a server with a known version, and one runs a query against it. Could you modify it accordingly?

docker run --name=mysql-9998 --detach --publish=9998:3306 --env=MYSQL_ALLOW_EMPTY_PASSWORD=1 mysql:8.0.32

elixir -e 'Mix.install([:myxql]); {:ok, pid} = MyXQL.start_link(username: "root", port: 9998) ; IO.inspect MyXQL.query!(pid, "SELECT NOW()")'
wojtekmach commented 8 months ago

Please re-open with more information. Thanks!