Hello, i have fallowing code in my tests: source = %MyModule{} |> Repo.insert!() new = Repo.get!(MyModule, source.id) assert new.id == source.id but oddly enough it throws an error, as you can see ids are slightly different. Assertion with == failed code: assert new.id() == source.id() left:…

Can you please provide the actual schema definition and migration file?

Just an aside; possibly relevant: 1 : MySQL does not support UUID types. Ecto emulates them by using binary(16). 2 : Because MySQL does not support RETURNING clauses in INSERT and UPDATE, it does not support the :read_after_writes option of Ecto.Schema.field/3. 3: TIL: Ecto reading after writ…

Migration: defmodule Stats.Repo.Migrations.CreateSourcesTable do use Ecto.Migration def change do create table(:sources) do add :nth, :integer, null: false add :url, :string, null: false add :contents, :text end create index("sources", [:nth], unique: true) c…

[image] revati: defmodule Stats.Repo.Migrations.CreateSourcesTable do use Ecto.Migration def change do create table(:sources) do add :nth, :integer, null: false add :url, :string, null: false add :contents, :text end create index("sources", [:nth], unique: tru…

i completely forget to add mysql schema. sorry. CREATE TABLE `sources` ( `id` binary(16) NOT NULL, `nth` int(11) NOT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `contents` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `sources_nth_index` (`nth`), UN…

Have your tried: source = %MyModule{} |> Repo.insert!() new = Repo.get!(MyModule, source.id) new2 = Repo.get!(MyModule, new.id) assert new2.id == new.id What is not clear is whether new actually originates from the same record that was created by the previous Repo.insert!. If there are ot…

What is not clear is whether new actually originates from the same record that was created by the previous Repo.insert!. If there are other records in the table, new could be an entirely different record. Didn’t quite catch. Its internal Ecto function Repo.get! which retrieves a new record by id.…

I updated MySQL to 8.0.11 version, but there still is a problem :sweat:

https://github.com/elixir-ecto/ecto/issues/2602

please let us know the result of Repo.all I’d go even further. Once you insert a record in iEX, use the MySQL shell to show you what value in the id column actually is. Something like: SELECT HEX(id), nth, url, contents FROM sources; That really is the only way to know what was actually written…

Elixir Programming Language Forum

Odd binary id mismatch

Questions & Help Questions

eljorge July 25, 2018, 6:07pm 14

we have also seen success with using the utf8 character set