Again: Bug with longs in Pythondriver
Andre Reitz <[email protected]> Tue, 26 Aug 2003 11:56:54 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
Hy all, I discovered a bug in the Pythondriver with longs under special conditions the pythondriver ends in a segmentation fault. I am using: Database linux 7.3.0.29-1 (rpm installation) Client: sapdb-python-linux-i386-7.4.03.12a.tgz (same problem when using 7.3.0.29 python driver) My test scenario ---------------------------------------------------------------------------------- My table is this: CREATE TABLE Artikel( ARID INTEGER PRIMARY KEY, BCID INTEGER NOT NULL, KTID INTEGER NOT NULL, CONSTRAINT FK_A_K FOREIGN KEY(KTID) REFERENCES Kategorie(KTID), ERSTELLDATUM TIMESTAMP NOT NULL, TITEL VARCHAR(1000), NEWSLETTERTEXT LONG, VERFASSER VARCHAR(500) ); - I have 40 Rows in the table. - any LONG-Fields are set (Have Text behind them) If I execute from python: 1. OK: "SELECT ARID,BCID,KTID,ERSTELLDATUM,TITEL,VERFASSER FROM Artikel" 2. OK: "SELECT NEWSLETTERTEXT FROM Artikel" 3. OK: "SELECT ARID,NEWSLETTERTEXT FROM Artikel" 4. OK: "SELECT ARID,BCID,KTID,ERSTELLDATUM,NEWSLETTERTEXT FROM Artikel" 5. OK: "SELECT ARID,BCID,KTID,ERSTELLDATUM,NEWSLETTERTEXT,VERFASSER FROM Artikel" 6. OK: "SELECT * FROM Artikel WHERE ARID<=80" 7. SEGFAULT: "SELECT * FROM Artikel" -> Segmentation fault!!! 8. SEGFAULT: "SELECT * FROM Artikel WHERE ARID>80" -> Segmentation fault!!! 9. OK : "SELECT * FROM Artikel WHERE ARID>80 AND ARID<90" -> Works 10. OK : "SELECT * FROM Artikel WHERE ARID>=90" -> Works Please look at 7. and 8. These querys result in a Segmentation fault, please note that 9. and 10. do not result in a segfault, but 8. does. (9 and 10 select the same rows a 8. does, but only 8. crashes) Please help, Greetings and thank you very much in advance, Andre' -- _____________________________________________ inworks GmbH Andre Reitz Hörvelsinger Weg 39 Tel. 0731/93 80 7-21 89081 Ulm http://www.inworks.de