Subject | Resultset where some blobs are null gives all blobs as null |
---|---|
Author | jeeggers |
Post date | 2003-03-09T00:41:19Z |
If I do
SELECT int_col, blob_col FROM my_table
then the result for blob_col is null for EVERY row even though I know
for sure that at least one row reall has a non-null blob.
When I do
SELECT int_col, blob_col FROM my_table WHERE blob_col IS NOT NULL
then the resultset is as expected. However, for obvious reasons that
is not satisfactory !
I'm using 1.5 on Windows, and I noticed this trough the JayBird
driver.
Thanks
Johannes
SELECT int_col, blob_col FROM my_table
then the result for blob_col is null for EVERY row even though I know
for sure that at least one row reall has a non-null blob.
When I do
SELECT int_col, blob_col FROM my_table WHERE blob_col IS NOT NULL
then the resultset is as expected. However, for obvious reasons that
is not satisfactory !
I'm using 1.5 on Windows, and I noticed this trough the JayBird
driver.
Thanks
Johannes