You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, thank you very much for making this library!
I'm having an issue where it appears when I insert new rows into my database they are randomly sorted instead of utilizing the current time. I've got my schema set up with:
When selecting the entries from this table ordered by the id, they do not return in the correct order and start with extremely dissimilar beginnings.
Manually generated
In iex if I use TypeID.new("client") the generated ids appear more immediately sensible and are correctly sorted so something seems amiss when I allow Ecto to autogenerate them.
iex(80)> TypeID.new("client") #repeat this for each line below
#TypeID<"client_01hwyg46cye1m8bp9c0bbyqgjb">
#TypeID<"client_01hwyg47dnevbrd93ypamb9tkf">
#TypeID<"client_01hwyg48zcegctnk497zkgm2bd">
#TypeID<"client_01hwyg4awqesdbp6t5c2agzg51">
#TypeID<"client_01hwyg4cxdfhv91crqy04aemnb">
I've created a project exhibiting the issue here: https://github.com/zolrath/typeid_test
Maybe there's something I'm missing/should be doing but if I attempt to use order_by like: Repo.all(from c in Client, order_by: [asc: c.id]) the sorting becomes random and non sequential.
Hello, thank you very much for making this library!
I'm having an issue where it appears when I insert new rows into my database they are randomly sorted instead of utilizing the current time. I've got my schema set up with:
As a test run, I created 6 new clients with a few seconds between each and the resulting primary keys (in order of generation) were:
Autogenerated
When selecting the entries from this table ordered by the id, they do not return in the correct order and start with extremely dissimilar beginnings.
Manually generated
In iex if I use
TypeID.new("client")
the generated ids appear more immediately sensible and are correctly sorted so something seems amiss when I allow Ecto to autogenerate them.I'm using:
ecto 3.11.2
ecto_psql_extras 0.7.15
ecto_sql 3.11.1
typeid_elixir 0.6.0
phoenix 1.7.12
phoenix_ecto 4.5.1
postgrex 0.17.5
with Elixir 1.16.2 (compiled with Erlang/OTP 26)
Thanks again, let me know if you need any additional information!
The text was updated successfully, but these errors were encountered: