|
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.
|
- RE: a BUG in precompiler...? Oliver Graf
- RE: a BUG in precompiler...? Diesing, Burkhard
