maria-discuss team mailing list archive

[Elena Stepanova <elenst@xxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp