Bug tracking.

[Claudius Sailer]

Hi Ivan,

Am 25. Mrz 2005 um 20:26 Uhr schrieb Ivan Smahin:

> CS> _______________________________________________
> CS> Valentina-beta mailing list
> CS> Valentina-beta at lists.macserve.net
> CS> http://lists.macserve.net/mailman/listinfo/valentina-beta
>
> As far as I get it - the described problem was in Diagnose, which gets 
> the wrong result
> diagnosing service tables and crash afterward.
> It should be gone away in current release of 2.0.
>
> Friday, March 25, 2005, 12:22:27 PM, it seems you wrote about another 
> bug. It's no crash
> but exceptions after some set of operations. I will check this point 
> now.

following I tested with ViSQL and could reproduce. Diagnose is an other 
problem which I found. Ruslan should have my database for testing.

bye


Claudius



DELETE FROM Anzeige

INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Ausgabe, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KZ.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KZ WHERE B.Kategorie_ID=K.RecID AND 
B.Ziel_Konto=KZ.RecID AND B.Deleted='0' AND B.Herk_Konto='13'

INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Einnahme, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KO.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KO WHERE B.Kategorie_ID=K.RecID AND 
B.Herk_Konto=KO.RecID AND B.Deleted='0' AND B.Ziel_Konto='13'

SELECT RecID, * FROM Anzeige ORDER BY BDatum, Gegenkonto, Kategorie

--> works fine


DELETE FROM Anzeige

INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Ausgabe, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KZ.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KZ WHERE B.Kategorie_ID=K.RecID AND 
B.Ziel_Konto=KZ.RecID AND B.Deleted='0' AND B.Herk_Konto='16'

INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Einnahme, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KO.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KO WHERE B.Kategorie_ID=K.RecID AND 
B.Herk_Konto=KO.RecID AND B.Deleted='0' AND B.Ziel_Konto='16'

SELECT RecID, * FROM Anzeige ORDER BY BDatum, Gegenkonto, Kategorie

--> works fine


DELETE FROM Anzeige

INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Ausgabe, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KZ.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KZ WHERE B.Kategorie_ID=K.RecID AND 
B.Ziel_Konto=KZ.RecID AND B.Deleted='0' AND B.Herk_Konto='13'

--> VException Error


INSERT INTO Anzeige (Buchungs_ID, BDatum, Gegenkonto, Kategorie, 
Einnahme, Kommentar, Blocked) SELECT B.RecID, B.BDatum, KO.Konto_Name, 
K.Kategorie_Name, B.Betrag, B.Kommentar, B.Blocked FROM Buchungen B, 
Kategorien K, Konten KO WHERE B.Kategorie_ID=K.RecID AND 
B.Herk_Konto=KO.RecID AND B.Deleted='0' AND B.Ziel_Konto='13'

SELECT RecID, * FROM Anzeige ORDER BY BDatum, Gegenkonto, Kategorie