ZEOS LIB SIGSEGV with a select query
lazarus / 16-Databases

----------------------------------------------------------------------
Hansvb · 2015-11-29 18:21

I found a strange error. When i select * from a table i got an error.
Now i made a test table with only 1 attribute like this:

With SQLPLUS:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i drop table
tijd_test; create table tijd_test    ( test char(1)    );    insert
into TIJD_TEST (test) values (' '); commit;

In my program i set a select * from TIJD_TEST. (ZQuery)

Result is 1 record. Good.

When i drop the table and create it again with 2 records like this in
SQLPLUS:


Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i drop table
tijd_test; create table tijd_test    ( test char(1)    );    insert
into TIJD_TEST (test) values (' ');insert into TIJD_TEST (test) values
(' '); commit;
When i execute the select in my program i get the SIGSEGV error.

So 1 record with only a " " in a char field is ok. 2 records in the
table with " " in a char field are not ok.
When i fill my table with other chars, everything is fine.

This happens in zeos 7.1.4. and in the 7.2 (trunc version 3661)
I use lazarus 1.4.2
It is a Oracle 11 database and i have a Oracle 10 client on my pc.