test/sql/Order/exp.test001.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 echo select * from t1;
   8 ---------------------------------------------------------
   9         t1.f1   t1.f2   t1.f3   t1.f4
  10 ---------------------------------------------------------
  11         98      1       10      AAA
  12         99      2       20      BBB
  13         100     2       10      CCC
  14         101     3       10      AAA
  15         102     2       20      BBB
  16
  17 echo select * from t1 order by f2;
  18 ---------------------------------------------------------
  19         t1.f1   t1.f2   t1.f3   t1.f4
  20 ---------------------------------------------------------
  21         98      1       10      AAA
  22         102     2       20      BBB
  23         100     2       10      CCC
  24         99      2       20      BBB
  25         101     3       10      AAA
  26
  27 echo select * from t1 order by t1.f2;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2   t1.f3   t1.f4
  30 ---------------------------------------------------------
  31         98      1       10      AAA
  32         102     2       20      BBB
  33         100     2       10      CCC
  34         99      2       20      BBB
  35         101     3       10      AAA
  36
  37 echo select f2,f3 from t1 order by f2;
  38 ---------------------------------------------------------
  39         f2      f3
  40 ---------------------------------------------------------
  41         1       10
  42         2       20
  43         2       10
  44         2       20
  45         3       10
  46
  47 echo select f4,f2 from t1 order by f4;
  48 ---------------------------------------------------------
  49         f4      f2
  50 ---------------------------------------------------------
  51         AAA     3
  52         AAA     1
  53         BBB     2
  54         BBB     2
  55         CCC     2
  56
  57 Statement Executed