[Koha-bugs] [Bug 10478] Do we need a sequential number generator?

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10478

--- Comment #3 from M. Tompsett <mtompset at hotmail.com> ---
M. de Rooy, you use MySQL's LAST_INSERT_ID, which is not forward compatible
with people who may be attempting to use a different back end, or working
towards that.

The next problem is code that calls something to get the next number without
actually having put it into a table anywhere and then calling it again when
someone refreshed. Do we really want such gaping holes in the sequences we
store?

Is the session id number, as stored in the CGISESSID cookie, unique enough,
such that one could look for the session id to grab the sequence value to see
if it is in the destination table, and if it is generate a new sequence number,
otherwise reuse the one that is already pre-calculated?

This is the situation I am pondering on the card number specific bug 10454.

-- 
You are receiving this mail because:
You are watching all bug changes.