[sqlite] field=null vs. field isnull

[Ara.T.Howard]

i've read the 'null handling' section and still not found the answer to this
question:

  why should

    'select * from tbl where field=null'

  be any different from

    'select * from tbl where field isnull'

using 2.8.15 it seems to be:

  jib:~ > sqlite db 'create table tbl(field); insert into tbl values(null)'

  jib:~ > sqlite db 'select count(*) from tbl where field=null'
  0

  jib:~ > sqlite db 'select count(*) from tbl where field isnull'
  1

is this doccumented somewhere and i simply have missed (sorry if so).  if not,
why the difference?

regards.

-a
--
===============================================================================
| EMAIL   :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE   :: 303.497.6469
| When you do something, you should burn yourself completely, like a good
| bonfire, leaving no trace of yourself.  --Shunryu Suzuki
===============================================================================