"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/682563.result" (6 May 2012, 3621 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 A
    2 CREATE TABLE t1 (a int);
    3 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
    4 BEGIN;
    5 INSERT INTO t1 values (1);
    6 B
    7 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
    8 BEGIN;
    9 SELECT * from t1;
   10 a
   11 A
   12 INSERT INTO t1 values (2);
   13 B
   14 SELECT * from t1;
   15 a
   16 COMMIT;
   17 BEGIN;
   18 SELECT * FROM t1;
   19 a
   20 A
   21 COMMIT;
   22 B
   23 SELECT * from t1 order by a;
   24 a
   25 1
   26 2
   27 COMMIT;
   28 BEGIN;
   29 SELECT * from t1 order by a;
   30 a
   31 1
   32 2
   33 COMMIT;
   34 DROP TABLE t1;
   35 SET AUTOCOMMIT= 0;
   36 SHOW STATUS LIKE 'Handler_commit%';
   37 Variable_name	Value
   38 Handler_commit	0
   39 BEGIN;
   40 SHOW STATUS LIKE 'Handler_commit%';
   41 Variable_name	Value
   42 Handler_commit	0
   43 COMMIT;
   44 DROP SCHEMA IF EXISTS boundaries;
   45 Warnings:
   46 Note	1008	Can't drop schema 'boundaries'; schema doesn't exist
   47 SHOW STATUS LIKE 'Handler_commit%';
   48 Variable_name	Value
   49 Handler_commit	1
   50 COMMIT;
   51 SHOW STATUS LIKE 'Handler_commit%';
   52 Variable_name	Value
   53 Handler_commit	1
   54 SET AUTOCOMMIT= 1;
   55 SHOW STATUS LIKE 'Handler_commit%';
   56 Variable_name	Value
   57 Handler_commit	1
   58 BEGIN;
   59 COMMIT;
   60 DROP SCHEMA IF EXISTS boundaries;
   61 Warnings:
   62 Note	1008	Can't drop schema 'boundaries'; schema doesn't exist
   63 SHOW STATUS LIKE 'Handler_commit%';
   64 Variable_name	Value
   65 Handler_commit	2
   66 CREATE TABLE commit_test (a int);
   67 SHOW STATUS LIKE 'Handler_commit%';
   68 Variable_name	Value
   69 Handler_commit	2
   70 INSERT into commit_test VALUES (10);
   71 SHOW STATUS LIKE 'Handler_commit%';
   72 Variable_name	Value
   73 Handler_commit	2
   74 INSERT into commit_test VALUES (10), (20);
   75 SHOW STATUS LIKE 'Handler_commit%';
   76 Variable_name	Value
   77 Handler_commit	2
   78 INSERT into commit_test VALUES (10);
   79 SHOW STATUS LIKE 'Handler_commit%';
   80 Variable_name	Value
   81 Handler_commit	2
   82 BEGIN;
   83 INSERT into commit_test VALUES (10);
   84 SHOW STATUS LIKE 'Handler_commit%';
   85 Variable_name	Value
   86 Handler_commit	2
   87 COMMIT;
   88 SHOW STATUS LIKE 'Handler_commit%';
   89 Variable_name	Value
   90 Handler_commit	3
   91 BEGIN;
   92 INSERT into commit_test VALUES (10);
   93 SHOW STATUS LIKE 'Handler_commit%';
   94 Variable_name	Value
   95 Handler_commit	3
   96 ROLLBACK;
   97 SHOW STATUS LIKE 'Handler_commit%';
   98 Variable_name	Value
   99 Handler_commit	3
  100 BEGIN;
  101 INSERT into commit_test VALUES (10);
  102 SHOW STATUS LIKE 'Handler_commit%';
  103 Variable_name	Value
  104 Handler_commit	3
  105 COMMIT;
  106 SHOW STATUS LIKE 'Handler_commit%';
  107 Variable_name	Value
  108 Handler_commit	4
  109 SET AUTOCOMMIT= 0;
  110 INSERT into commit_test VALUES (10);
  111 INSERT into commit_test VALUES (10);
  112 SHOW STATUS LIKE 'Handler_commit%';
  113 Variable_name	Value
  114 Handler_commit	4
  115 COMMIT;
  116 drop table commit_test;
  117 SHOW STATUS LIKE 'Handler_commit%';
  118 Variable_name	Value
  119 Handler_commit	5
  120 DROP TABLE IF EXISTS t1_trx, t1_non_trx;
  121 SET AUTOCOMMIT= 0;
  122 CREATE TABLE t1_trx (
  123 k VARCHAR(10) NOT NULL
  124 , v VARCHAR(10) NOT NULL
  125 , PRIMARY KEY (k)
  126 ) ENGINE=InnoDB;
  127 CREATE TEMPORARY TABLE t1_non_trx (
  128 k VARCHAR(10) NOT NULL
  129 , v VARCHAR(10) NOT NULL
  130 , PRIMARY KEY (k)
  131 ) ENGINE=MyISAM;
  132 START TRANSACTION;
  133 INSERT INTO t1_trx VALUES ('key1','value1');
  134 INSERT INTO t1_trx VALUES ('key2','value2');
  135 INSERT INTO t1_non_trx VALUES ('key1','value1');
  136 INSERT INTO t1_non_trx VALUES ('key2','value2');
  137 ROLLBACK;
  138 Warnings:
  139 Warning	1196	Some non-transactional changed tables couldn't be rolled back
  140 Expected warning about non-trx data changes not being rolled back
  141 SELECT * FROM t1_trx;
  142 k	v
  143 SELECT * FROM t1_non_trx;
  144 k	v
  145 key1	value1
  146 key2	value2
  147 START TRANSACTION;
  148 Warnings:
  149 Warning	1747	There is already a transaction in progress
  150 INSERT INTO t1_trx VALUES ('key1','value1');
  151 INSERT INTO t1_trx VALUES ('key2','value2');
  152 SELECT t1_trx.k, t1_trx.v
  153 FROM t1_trx
  154 INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
  155 k	v
  156 key1	value1
  157 key2	value2
  158 ROLLBACK;
  159 SELECT t1_trx.k, t1_trx.v
  160 FROM t1_trx
  161 INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
  162 k	v
  163 COMMIT;
  164 DROP TABLE t1_trx;
  165 DROP TABLE t1_non_trx;