test/sqlapi/Select/exp.test005.ksh

   1 Case 1: create table t1 ,test for SET AUTOCOMMIT OFF and some records
   2 [Parser: syntax error] SET
   3 [Parser: syntax error] commiter
   4 [Parser: syntax error] rollbacked
   5 [Parser: syntax error] show
   6 [Parser: syntax error] SET
   7 echo create table t1 (f1 int,f2 int);
   8 Statement Executed
   9 echo check for SET AUTOCOMMIT OFF;
  10 Statement prepare failed with error -19
  11 echo insert some record;
  12 Statement Executed: Rows Affected = 1
  13 Statement Executed: Rows Affected = 1
  14 Statement Executed: Rows Affected = 1
  15 Statement Executed: Rows Affected = 1
  16 Statement Executed: Rows Affected = 1
  17 echo rollback;
  18 echo select * from t1;
  19 ---------------------------------------------------------
  20         t1.f1   t1.f2
  21 ---------------------------------------------------------
  22         10      20
  23         20      30
  24         30      40
  25         40      50
  26         50      60
  27
  28 AUTOCOMMIT Mode is set to OFF
  29 Statement Executed: Rows Affected = 1
  30 Statement Executed: Rows Affected = 1
  31 Statement Executed: Rows Affected = 1
  32 Statement Executed: Rows Affected = 1
  33 Statement Executed: Rows Affected = 1
  34 Statement Executed: Rows Affected = 1
  35 Statement Executed: Rows Affected = 1
  36 Statement Executed: Rows Affected = 1
  37 Statement Executed: Rows Affected = 1
  38 Statement Executed: Rows Affected = 1
  39 echo test for commit;
  40 Statement prepare failed with error -19
  41 ---------------------------------------------------------
  42         t1.f1   t1.f2
  43 ---------------------------------------------------------
  44         10      20
  45         20      30
  46         30      40
  47         40      50
  48         50      60
  49
  50 echo test for rollback;
  51 echo insert 5 records;
  52 Statement Executed: Rows Affected = 1
  53 Statement Executed: Rows Affected = 1
  54 Statement Executed: Rows Affected = 1
  55 Statement Executed: Rows Affected = 1
  56 Statement Executed: Rows Affected = 1
  57 Statement prepare failed with error -19
  58 ---------------------------------------------------------
  59         t1.f1   t1.f2
  60 ---------------------------------------------------------
  61         10      20
  62         20      30
  63         30      40
  64         40      50
  65         50      60
  66         20      40
  67         20      40
  68         20      40
  69         20      40
  70         20      40
  71
  72 echo check for show tables;
  73 Statement prepare failed with error -19
  74 echo check for SET AUTOCOMMIT ON;
  75 Statement prepare failed with error -19
  76 echo insert some records;
  77 Statement Executed: Rows Affected = 1
  78 Statement Executed: Rows Affected = 1
  79 Statement Executed: Rows Affected = 1
  80 Statement Executed: Rows Affected = 1
  81 Statement Executed: Rows Affected = 1
  82 ---------------------------------------------------------
  83         t1.f1   t1.f2
  84 ---------------------------------------------------------
  85         10      20
  86         20      30
  87         30      40
  88         40      50
  89         50      60
  90         20      40
  91         20      40
  92         20      40
  93         20      40
  94         20      40
  95
  96 echo drop teble;
  97 Statement Executed