Re: [HACKERS] Group By, NULL values and inconsistent behaviour.

The following is Informix behavior:

informix@zeus:/usr/informix72> dbaccess - -
> create database nulltest in datadbs;
Database created.

> create table t1 (a int4, b char(2), c char(2));
  201: A syntax error has occurred.
Error in line 1
Near character position 20

> create table t1 (a int, b char(2), c char(2));
Table created.

> insert into t1 (a,c) values (1,'x');
1 row(s) inserted.
> insert into t1 (a,c) values (2,'x');
1 row(s) inserted.
> insert into t1 (a,c) values (3,'z');
1 row(s) inserted.
> insert into t1 (a,c) values (2,'x');
1 row(s) inserted.
> select * from t1;
          a b  c
          1    x
          2    x
          3    z
          2    x

4 row(s) retrieved.
> select b,c,sum(a) from t1 group by b,c;
b  c             (sum)

   x                 5
   z                 3

2 row(s) retrieved.
> select b,c,sum(a) from t1 group by b,c order by c;
b  c             (sum)

   x                 5
   z                 3

2 row(s) retrieved.
>


Andreas