Recent

Author Topic: ZEOS LIB SIGSEGV with a select query  (Read 1732 times)

Hansvb

  • Hero Member
  • *****
  • Posts: 618
ZEOS LIB SIGSEGV with a select query
« on: November 29, 2015, 07:21:32 pm »
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][+][-]
  1. drop table tijd_test;
  2.  
  3. create table tijd_test
  4.     ( test char(1)
  5.     );
  6.    
  7. insert into TIJD_TEST (test) values (' ');
  8.  
  9. 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][+][-]
  1. drop table tijd_test;
  2.  
  3. create table tijd_test
  4.     ( test char(1)
  5.     );
  6.    
  7. insert into TIJD_TEST (test) values (' ');
  8. insert into TIJD_TEST (test) values (' ');
  9.  
  10. 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.

 

TinyPortal © 2005-2018