[Koha-devel] Serious problem

[Chris Cormack]

* Chris Cormack (chrisc at catalyst.net.nz) wrote:
> * Chris Cormack (chrisc at catalyst.net.nz) wrote:
> > * Mark Tompsett (mtompset at hotmail.com) wrote:
> > > Greetings,
> > > 
> > > And what if you wish to undo a checkout?
> > > There are advantages to having it.
> > > -- Perhaps we should ponder why we are uniquely keying on the id in 
> > > old_issues?
> > 
> > What? Undo an old check out? You mean like unreturn something?
> > There is no code to do that. If you want to unreturn something, you just reissue it.
> > 
> > It is just a history file, if it just auto_incremented the same way as issues does
> > then the whole problem goes away.
> > 
> > I see no more advantage to having no issues_id, than to have one that auto increments.
> > You'd still have to have a custom query either way if someone did decide to write
> > a bizarre piece of code that unreturned items. (Please no one do this, it's a horrible idea)
> > 
> > Chris
> 
> 
> Of course, there is no reason that those tables (deleted* and old_*) need to be innodb.
> We do not foreign key to them.
> If they were MyISAM, then this problem would go away.
> 
Answering myself again, this won't work, because the original table will still keep handing out
the wrong IDs.

What does MariaDB do? With their XtraDB tables (which are used by default still called InnoDB for
compatibility)

Chris


> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/


-- 
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 801 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160906/d56979ea/attachment.pgp>