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
_______________________________________________
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
