14 Dec
2014
14 Dec
'14
12:02 a.m.
Hi Roberto, On 13.12.2014 21:13, Roberto Spadim wrote:
Hi guys i'm with a doubt about the "standard" (sql standand?) error reporting , about INSERT SELECT...
should this insert select return duplicate key? INSERT INTO errorsX (id) SELECT MAX(id)+1 FROM errorsX;
considering: ---- CREATE TABLE errorsX( id INT NOT NULL DEFAULT 0, PRIMARY KEY (id) ) ; ----
I suppose you forgot to mention that you are doing it on an Aria table, concurrently, simultaneously from several threads? Regards, /E
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp