Hi list,
 
I�ve prepared a select statement in a c-file like this one:
 
    SELECT <some columns> FROM faecher WHERE real_bestand=104
 
In the where-part is only one value compared with an equal sign.
I open a cursor and i�m exectuing a EXEC SQL FETCH ...
 
In SQL-Studio, this statement returns 5 rows, all fine.
But the c-program just exits with a "segmentation fault".
Then I tried:
 
        SELECT <some columns> FROM faecher WHERE real_bestand IN (104)
 
In SQL-Studio, this statement returns as expected the 5 rows.
But the C-Programm exits again with a segmentation fault.
The last possibility
 
        SELECT <some columns> FROM faecher WHERE real_bestand >103 AND real_bestand <105
 
returns the correct rows in SQLStudio, but the c-file exits again with a segmentation fault.
 
The magic is, that the following statement-samples are passing through and are delivering the correct rows in the c-file:
    SELECT <some columns> FROM faecher WHERE real_bestand <104
    SELECT <some columns> FROM faecher WHERE real_bestand >106
 
But when in the where-part is comparing just one value using '=', the IN-operator or '<' and '>' like described above, i always get a segmentation fault.
Is this a bug, or do I have an error in my theory.
 
I�d be glad when someone can confirm this.

Reply via email to