Hello,
Using SQLite v3.3.13, this query:
select
oid || '|' || email_addr || '|' || residual_value as RD
from
gl_claims c
where
--RD is not null and
status = 1
and not exists (select 1 from gl_claim_tickets where ticket_type = 'coupon'
and claim_id = c.oid);
I expect one row of data. But what I get is 3 rows, the one I expect, and two
others where RD is null. I've tracked it down to null values in residual_value
for the null result rows.
Since it's test data, and the rows in question are crap anyway, no big deal. I
can easily work around it by un-commenting the null test in the where clause.
Long setup for a simple question: Is null the expected result when one column
of a concatenation operation is null?
Thanks!
-Clark
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
