awesome_nested_set tries to access record with id=1 even when it doesn't exist.

[shelvacu]

When trying to use awesome_nested_set on an empty table, it tries to access the very first record and fails.

rails (4.2.6)
activerecord (4.2.6)
awesome_nested_set (3.0.3)

Code to reproduce:

require 'active_record'
require 'awesome_nested_set'
require 'sqlite3'

ActiveRecord::Base.establish_connection(
  adapter: 'sqlite3',
  database: 'testans.db'
)

ActiveRecord::Base.connection.execute("CREATE TABLE IF NOT EXISTS 'nodes' (
id PRIMARY KEY,
name, 
parent_id, 
lft, 
rgt, 
depth)")

class Node < ActiveRecord::Base
  acts_as_nested_set
end

Node.create

[leifcr]

@shelvacu did you figure out this one? I have the same issue now.

[leifcr]

Found this to be an issue when using mariadb 10.4 docker image. Does not seem to be a problem with mysql 5.6 or 5.7 docker images.

[leifcr]

Folow-up on this issue. it is only an issue if you have an existing mysql docker-image and reuse the data_dir with a mariadb docker image. Please close this issue, as latest verison works fine.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.