maria-discuss team mailing list archive

[Federico Razzoli <federico_raz@xxxxxxxx>]

INSERT SELECT is not standard SQL. But there is no reason to have a duplicate value error.

Regards
Federico


--------------------------------------------
Sab 13/12/14, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:

 Oggetto: [Maria-discuss] Doubt about 'atomic' insert
 A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Sabato 13 dicembre 2014, 19:13
 
 Hi guysi'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))
 ;----
 -- 
 Roberto Spadim
 SPAEmpresarialEng. Automação e
 Controle
 
 -----Segue allegato-----
 
 _______________________________________________
 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