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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
