← Back to branch summary

~posulliv/drizzle/memcached_applier

« back to all changes in this revision

Viewing changes to tests/r/type_blob.result

Merged trunk and resolved conflicts.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/type_blob.result
72
72
insert into t1 values (1,1,1,1);
73
73
insert into t1 values (NULL,NULL,NULL,NULL);
74
74
update t1 set c="",b=null where c="1";
75
 
lock tables t1 READ;
76
 
show full fields from t1;
77
 
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
78
 
t       text    utf8_general_ci YES             NULL            #       
79
 
c       varchar(10)     utf8_general_ci YES             NULL            #       
80
 
b       blob    NULL    YES             NULL            #       
81
 
d       blob    NULL    YES             NULL            #       
82
 
lock tables t1 WRITE;
83
 
show full fields from t1;
84
 
Field   Type    Collation       Null    Key     Default Extra   Privileges      Comment
85
 
t       text    utf8_general_ci YES             NULL            #       
86
 
c       varchar(10)     utf8_general_ci YES             NULL            #       
87
 
b       blob    NULL    YES             NULL            #       
88
 
d       blob    NULL    YES             NULL            #       
89
 
unlock tables;
90
75
select t from t1 where t like "hello";
91
76
t
92
77
hello