test/sql/Aggregate/exp.testnw016.ksh

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