test/sql/Aggregate/exp.test016.ksh

   1 Statement Executed
   2 Statement Executed: Rows Affected = 1
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 Statement Executed: Rows Affected = 1
   7 Statement Executed
   8 Statement Executed: Rows Affected = 1
   9 Statement Executed: Rows Affected = 1
  10 Statement Executed: Rows Affected = 1
  11 Statement Executed: Rows Affected = 1
  12 Statement Executed: Rows Affected = 1
  13 ---------------------------------------------------------
  14         t1.f1   t1.f2   t1.f3
  15 ---------------------------------------------------------
  16         98      1       10
  17         99      NULL    20
  18         100     3       30
  19         101     4       NULL
  20         102     5       50
  21
  22 ---------------------------------------------------------
  23         t2.f1   t2.f2   t2.f3
  24 ---------------------------------------------------------
  25         98      1       10
  26         99      2       20
  27         100     NULL    NULL
  28         101     4       40
  29         102     NULL    50
  30
  31 echo select * from t1,t2;
  32 ---------------------------------------------------------
  33         t1.f1   t1.f2   t1.f3   t2.f1   t2.f2   t2.f3
  34 ---------------------------------------------------------
  35         98      1       10      98      1       10
  36         98      1       10      99      2       20
  37         98      1       10      100     NULL    NULL
  38         98      1       10      101     4       40
  39         98      1       10      102     NULL    50
  40         99      NULL    20      98      1       10
  41         99      NULL    20      99      2       20
  42         99      NULL    20      100     NULL    NULL
  43         99      NULL    20      101     4       40
  44         99      NULL    20      102     NULL    50
  45         100     3       30      98      1       10
  46         100     3       30      99      2       20
  47         100     3       30      100     NULL    NULL
  48         100     3       30      101     4       40
  49         100     3       30      102     NULL    50
  50         101     4       NULL    98      1       10
  51         101     4       NULL    99      2       20
  52         101     4       NULL    100     NULL    NULL
  53         101     4       NULL    101     4       40
  54         101     4       NULL    102     NULL    50
  55         102     5       50      98      1       10
  56         102     5       50      99      2       20
  57         102     5       50      100     NULL    NULL
  58         102     5       50      101     4       40
  59         102     5       50      102     NULL    50
  60
  61 echo select f2 from t1,t2;
  62 Statement prepare failed with error -19
  63 echo select avg(f2) from t1,t2;
  64 Statement prepare failed with error -19
  65 Statement Executed
  66 Statement Executed