git.ipfire.org Git - thirdparty/sqlite.git/commit

]> git.ipfire.org Git - thirdparty/sqlite.git/commit

projects / thirdparty / sqlite.git / commit

author	drh <drh@noemail.net>
	Fri, 31 May 2002 15:51:25 +0000 (15:51 +0000)
committer	drh <drh@noemail.net>
	Fri, 31 May 2002 15:51:25 +0000 (15:51 +0000)
commit	f570f011ebb27fece3bc44eec067dbab8b0a337a
tree	de6f07ce1a7ba15d993a24c0a88ad7ab72a5535a	tree \| snapshot
parent	0f89253e219ffe31f33ea946adbe3cfa06c6e781	commit \| diff

Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.
Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison
is considered false, not NULL. With these changes, NULLs in SQLite now work
the same as in PostgreSQL and in Oracle. (CVS 600)

FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f

manifest		diff \| blob \| blame \| history
manifest.uuid		diff \| blob \| blame \| history
src/expr.c		diff \| blob \| blame \| history
src/func.c		diff \| blob \| blame \| history
src/select.c		diff \| blob \| blame \| history
src/util.c		diff \| blob \| blame \| history
src/vdbe.c		diff \| blob \| blame \| history
test/expr.test		diff \| blob \| blame \| history
test/minmax.test		diff \| blob \| blame \| history
test/null.test	[new file with mode: 0644]	blob
test/select4.test		diff \| blob \| blame \| history

Mirror of https://github.com/sqlite/sqlite.git

RSS Atom