Thread safety issue in connection.session_id

[jacobat]

This code:

plsql.connection.instance_variable_set(:@session_id, nil)
4.times.map do |n|
  Thread.new do
    puts "Thread: #{n}\tSessionID: #{plsql.connection.session_id}"
    sleep 1
    puts "Thread: #{n}\tSessionID: #{plsql.connection.session_id}"
  end
end.map(&:join)

Returns:

Thread: 3       SessionID: 8893156
Thread: 2       SessionID: 8893159
Thread: 1       SessionID: 8893158
Thread: 0       SessionID: 8893157
Thread: 3       SessionID: 8893157
Thread: 2       SessionID: 8893157
Thread: 1       SessionID: 8893157
Thread: 0       SessionID: 8893157

Due to memoization here: https://github.com/rsim/ruby-plsql/blob/master/lib/plsql/connection.rb#L197

[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.