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.
