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