Carel-Jan Engel wrote: > I just created the following test: > dgs@(protected):/opt/oracle/product/9.2.0>sqlplus '/ as sysdba' > > SQL*Plus: Release 9.2.0.5.0 - Production on Wed Feb 16 22:31:45 2005 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > > Connected to: > Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production > With the Partitioning and Oracle Data Mining options > JServer Release 9.2.0.5.0 - Production > > dbalert199.DGS.SYS SQL> create table test(c1 number); > dbalert199.DGS.SYS SQL> insert into test values (1); > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> insert into test values (null); > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> / > dbalert199.DGS.SYS SQL> select count(c1), count(*), count(1) from test; > > COUNT(C1) COUNT(*) COUNT(1) > ========= ======== ======== > 4 8 8 > > To see whether this has changed through history I did the very same > test, with the very same results, on the oldest version I have > available. : > > IOR: Two Process ORACLE V4.1.1 - Production > IOR: System global area (SGA) is 15856 (16K) bytes composed of > 1100 bytes of fixed data > 11684 bytes of variable data, > 1024 bytes of before image buffers, and > 2048 bytes of buffers. > IOR: ORACLE warm started. > > > [...]
Thanks for the update, I was wrongly confusing count(col) with count(*) in regard to null values.
