← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/innodb.result

  • Committer: Monty Taylor
  • Date: 2010-10-12 20:20:44 UTC
  • mto: (1842.1.3 build) (1843.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1843.
  • Revision ID: mordred@inaugust.com-20101012202044-yfrmnmkznvkqfxe4
Added support for valgrind suppressions.
Run strip-valgrind as part of make valgrind.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/tests/r/innodb.result
422
422
3       4
423
423
4       7
424
424
5       2
425
 
ALTER TABLE t1 ADD co3 INT DEFAULT 42 NOT NULL;
 
425
alter table t1 add co3 int not null;
426
426
select * from t1;
427
427
col1    col2    co3
428
 
1       1       42
429
 
2       3       42
430
 
3       4       42
431
 
4       7       42
432
 
5       2       42
 
428
1       1       0
 
429
2       3       0
 
430
3       4       0
 
431
4       7       0
 
432
5       2       0
433
433
update t1 set col2='9' where col1='2';
434
434
select * from t1;
435
435
col1    col2    co3
436
 
1       1       42
437
 
2       9       42
438
 
3       4       42
439
 
4       7       42
440
 
5       2       42
 
436
1       1       0
 
437
2       9       0
 
438
3       4       0
 
439
4       7       0
 
440
5       2       0
441
441
drop table t1;
442
442
create table t1 (a int not null , b int, primary key (a)) engine = innodb;
443
443
create TEMPORARY table t2 (a int not null , b int, primary key (a)) engine = myisam;
825
825
commit;
826
826
drop database mysqltest;
827
827
show tables from mysqltest;
828
 
ERROR 42000: Unknown schema 'mysqltest'
 
828
ERROR 42000: Unknown database 'mysqltest'
829
829
set autocommit=0;
830
830
create table t1 (a int not null) engine= innodb;
831
831
insert into t1 values(1),(2);
1394
1394
0
1395
1395
explain select count(*) from t1 where x > -16;
1396
1396
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1397
 
1       SIMPLE  t1      index   PRIMARY PRIMARY 8       NULL    2       Using where; Using index
 
1397
1       SIMPLE  t1      range   PRIMARY PRIMARY 8       NULL    1       Using where; Using index
1398
1398
select count(*) from t1 where x > -16;
1399
1399
count(*)
1400
1400
2
1446
1446
innodb_thread_concurrency       0
1447
1447
set global innodb_thread_concurrency=1001;
1448
1448
Warnings:
1449
 
Error   1524    Error setting innodb_thread_concurrency. Given value 1001 (> 1000)
 
1449
Error   1292    Truncated incorrect thread_concurrency value: '1001'
1450
1450
show variables like "innodb_thread_concurrency";
1451
1451
Variable_name   Value
1452
 
innodb_thread_concurrency       0
 
1452
innodb_thread_concurrency       1000
1453
1453
set global innodb_thread_concurrency=0;
1454
1454
show variables like "innodb_thread_concurrency";
1455
1455
Variable_name   Value
1467
1467
innodb_concurrency_tickets      1000
1468
1468
set global innodb_concurrency_tickets=0;
1469
1469
Warnings:
1470
 
Error   1524    Error setting innodb_concurrency_tickets. Given value 0 (< 1)
 
1470
Error   1292    Truncated incorrect concurrency_tickets value: '0'
1471
1471
show variables like "innodb_concurrency_tickets";
1472
1472
Variable_name   Value
1473
 
innodb_concurrency_tickets      1000
 
1473
innodb_concurrency_tickets      1
1474
1474
set global innodb_concurrency_tickets=500;
1475
1475
show variables like "innodb_concurrency_tickets";
1476
1476
Variable_name   Value
2601
2601
commit;
2602
2602
drop table t1, t2, t3, t5, t6, t8, t9;
2603
2603
CREATE TABLE t1 (DB_ROW_ID int) engine=innodb;
2604
 
Got one of the listed errors
 
2604
ERROR HY000: Can't create table 'test.t1' (errno: -1)
2605
2605
CREATE TABLE t1 (
2606
2606
a BIGINT NOT NULL,
2607
2607
PRIMARY KEY  (a)