← 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: Brian Aker
  • Date: 2010-11-30 00:29:39 UTC
  • mto: (1965.2.2 build)
  • mto: This revision was merged to the branch mainline in revision 1966.
  • Revision ID: brian@tangent.org-20101130002939-8bzz3xpa0aapbq2w
Fix sleep() so that a kill command will kill it.

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;
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