search

elixir-ecto / myxql

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

Error when use UPDATE or INSERT on `query_many` #193

Closed igorsegallafa closed 2 months ago

igorsegallafa commented 2 months ago

I can't run UPDATE or INSERT using query_many function.

Code:

MultiQueries.Repo.query_many("insert into test_table values (1000, 'string')")

Error:

22:39:14.445 [error] :gen_statem #PID<0.201.0> terminating
** (stop) an exception was raised:
    ** (DBConnection.ConnectionError) client #PID<0.234.0> stopped: ** (MatchError) no match of right hand side value: {:ok_packet, 1, 1000, 3, 0, ""}
    (myxql 0.7.1) lib/myxql/connection.ex:333: anonymous fn/3 in MyXQL.Connection.result/3
    (elixir 1.17.2) lib/enum.ex:2531: Enum."-reduce/3-lists^foldl/2-0-"/3
    (myxql 0.7.1) lib/myxql/connection.ex:326: MyXQL.Connection.result/3
    (ecto_sql 3.12.0) lib/ecto/adapters/sql/sandbox.ex:413: Ecto.Adapters.SQL.Sandbox.Connection.proxy/3
    (db_connection 2.7.0) lib/db_connection/holder.ex:354: DBConnection.Holder.holder_apply/4
    (db_connection 2.7.0) lib/db_connection.ex:1558: DBConnection.run_execute/5
    (db_connection 2.7.0) lib/db_connection.ex:1653: DBConnection.run/6
    (db_connection 2.7.0) lib/db_connection.ex:829: DBConnection.execute/4
    (myxql 0.7.1) lib/myxql.ex:363: MyXQL.do_query/4
    test/multi_queries_test.exs:44: MultiQueriesTest."test anotherk"/1
    (ex_unit 1.17.2) lib/ex_unit/runner.ex:485: ExUnit.Runner.exec_test/2
    (stdlib 6.0.1) timer.erl:590: :timer.tc/2
    (ex_unit 1.17.2) lib/ex_unit/runner.ex:407: anonymous fn/6 in ExUnit.Runner.spawn_test_monitor/4