test/sql/Limit/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 Statement Executed: Rows Affected = 1
   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 echo select * from t1;
  13 ---------------------------------------------------------
  14         t1.f1   t1.f2
  15 ---------------------------------------------------------
  16         95      1
  17         96      2
  18         97      2
  19         98      2
  20         99      2
  21         100     3
  22         101     4
  23         102     5
  24         103     5
  25         104     5
  26
  27 echo select * from t1 limit 1;
  28 ---------------------------------------------------------
  29         t1.f1   t1.f2
  30 ---------------------------------------------------------
  31         95      1
  32
  33 echo select * from t1 limit 3;
  34 ---------------------------------------------------------
  35         t1.f1   t1.f2
  36 ---------------------------------------------------------
  37         95      1
  38         96      2
  39         97      2
  40
  41 echo select * from t1 limit 20;
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2
  44 ---------------------------------------------------------
  45         95      1
  46         96      2
  47         97      2
  48         98      2
  49         99      2
  50         100     3
  51         101     4
  52         102     5
  53         103     5
  54         104     5
  55
  56 echo select * from t1 limit 1 offset 0;
  57 ---------------------------------------------------------
  58         t1.f1   t1.f2
  59 ---------------------------------------------------------
  60         95      1
  61
  62 echo select * from t1 limit 1 offset 1;
  63 ---------------------------------------------------------
  64         t1.f1   t1.f2
  65 ---------------------------------------------------------
  66         96      2
  67
  68 echo select * from t1 limit 1 offset 5;
  69 ---------------------------------------------------------
  70         t1.f1   t1.f2
  71 ---------------------------------------------------------
  72         100     3
  73
  74 echo select * from t1 limit 1 offset 15;
  75 ---------------------------------------------------------
  76         t1.f1   t1.f2
  77 ---------------------------------------------------------
  78
  79 echo select * from t1 limit 5 offset 5;
  80 ---------------------------------------------------------
  81         t1.f1   t1.f2
  82 ---------------------------------------------------------
  83         100     3
  84         101     4
  85         102     5
  86         103     5
  87         104     5
  88
  89 echo select * from t1 limit 15 offset 15;
  90 ---------------------------------------------------------
  91         t1.f1   t1.f2
  92 ---------------------------------------------------------
  93
  94 Statement Executed