← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/type_blob.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/type_blob.result
357
357
hello   1
358
358
drop table t1;
359
359
create table t1 (a text, unique (a(2100)));
360
 
ERROR 42000: Specified key was too long; max key length is 1020 bytes
 
360
ERROR 42000: Specified key was too long; max key length is 2044 bytes
361
361
create table t1 (a text, key (a(2100)));
362
362
Warnings:
363
 
Warning 1071    Specified key was too long; max key length is 1020 bytes
 
363
Warning 1071    Specified key was too long; max key length is 2044 bytes
364
364
show create table t1;
365
365
Table   Create Table
366
366
t1      CREATE TABLE `t1` (
367
367
  `a` text,
368
 
  KEY `a` (`a`(1020))
 
368
  KEY `a` (`a`(2044))
369
369
) ENGINE=PBXT DEFAULT CHARSET=latin1
370
370
drop table t1;
371
371
CREATE TABLE t1 (
506
506
Warnings:
507
507
Warning 1101    BLOB/TEXT column 'imagem' can't have a default value
508
508
insert into t1 (id) values (1);
509
 
select 
510
 
charset(load_file('../../std_data/words.dat')),
511
 
collation(load_file('../../std_data/words.dat')),
512
 
coercibility(load_file('../../std_data/words.dat'));
513
 
charset(load_file('../../std_data/words.dat'))  collation(load_file('../../std_data/words.dat'))        coercibility(load_file('../../std_data/words.dat'))
 
509
select
 
510
charset(load_file('../std_data_ln/words.dat')),
 
511
collation(load_file('../std_data_ln/words.dat')),
 
512
coercibility(load_file('../std_data_ln/words.dat'));
 
513
charset(load_file('../std_data_ln/words.dat'))  collation(load_file('../std_data_ln/words.dat'))        coercibility(load_file('../std_data_ln/words.dat'))
514
514
binary  binary  4
515
 
explain extended select 
516
 
charset(load_file('../../std_data/words.dat')),
517
 
collation(load_file('../../std_data/words.dat')),
518
 
coercibility(load_file('../../std_data/words.dat'));
 
515
explain extended select
 
516
charset(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')),
 
517
collation(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat')),
 
518
coercibility(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'));
519
519
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
520
520
1       SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    No tables used
521
521
Warnings:
522
 
Note    1003    select charset(load_file(_latin1'../../std_data/words.dat')) AS `charset(load_file('../../std_data/words.dat'))`,collation(load_file(_latin1'../../std_data/words.dat')) AS `collation(load_file('../../std_data/words.dat'))`,coercibility(load_file(_latin1'../../std_data/words.dat')) AS `coercibility(load_file('../../std_data/words.dat'))`
523
 
update t1 set imagem=load_file('../../std_data/words.dat') where id=1;
 
522
Note    1003    select charset(load_file(_latin1'MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `charset(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`,collation(load_file(_latin1'MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `collation(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`,coercibility(load_file(_latin1'MYSQLTEST_VARDIR/std_data_ln/words.dat')) AS `coercibility(load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat'))`
 
523
update t1 set imagem=load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat') where id=1;
524
524
select if(imagem is null, "ERROR", "OK"),length(imagem) from t1 where id = 1;
525
525
if(imagem is null, "ERROR", "OK")       length(imagem)
526
526
OK      581
527
527
drop table t1;
528
 
create table t1 select load_file('../../std_data/words.dat') l;
 
528
create table t1 select load_file('MYSQLTEST_VARDIR/std_data_ln/words.dat') l;
529
529
show full fields from t1;
530
530
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
531
531
l       longblob        NULL    YES             NULL            #       
613
613
insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL);
614
614
select * from t1 where txt='Chevy' or txt is NULL;
615
615
id      txt
 
616
1       Chevy
 
617
2       Chevy 
616
618
3       NULL
617
 
1       Chevy
618
 
2       Chevy 
619
619
explain select * from t1 where txt='Chevy' or txt is NULL;
620
620
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
621
 
1       SIMPLE  t1      range   txt_index       txt_index       23      NULL    2       Using where
 
621
1       SIMPLE  t1      ref_or_null     txt_index       txt_index       23      const   2       Using where
622
622
select * from t1 where txt='Chevy ';
623
623
id      txt
624
624
1       Chevy