maria-developers team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

!!!! NICE IT WORKS !!!!
\o/


test results...
patched mysqld


1)
SELECT * FROM t7
WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0
AND nf_serie='3nfe' AND nf < 0;
/* Affected rows: 0  rows found: 2 */   <---- 2 rows!!!!

2)
update t7
set emitente_propriedade=1
WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0
AND nf_serie='3nfe' AND nf < 0;
/* Affected rows: 2  */   <---- 2 rows!!!!

3)  (get back last value of emitente_propriedade)
update t7 set emitente_propriedade=0;
/* Affected rows: 2  */  <- ok we changed 2 rows at (2)

4)
delete from t7
WHERE emitente_tipo='j' AND emitente_id=1 AND emitente_propriedade=0
AND nf_serie='3nfe' AND nf < 0;
/* Affected rows: 2  */   <---- 2 rows!!!!



:D i think we could apply the patch without problems... i can put it
in production server without problems if you want