← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/r/type_varbinary.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/type_varbinary.result
13
13
show create table t1;
14
14
Table   Create Table
15
15
t1      CREATE TABLE `t1` (
16
 
  `s1` varbinary(20) DEFAULT NULL,
17
 
  `s2` varbinary(20) DEFAULT NULL
18
 
) ENGINE=DEFAULT
 
16
  `s1` VARBINARY(20) DEFAULT NULL,
 
17
  `s2` VARBINARY(20) DEFAULT NULL
 
18
) ENGINE=DEFAULT COLLATE = utf8_general_ci
19
19
insert into t1 values (0x41,0x4100),(0x41,0x4120),(0x4100,0x4120);
20
20
select hex(s1), hex(s2) from t1;
21
21
hex(s1) hex(s2)
81
81
create table t1 (c char(2), vc varchar(2));
82
82
insert into t1 values(0x4120, 0x4120);
83
83
insert into t1 values(0x412020, 0x412020);
84
 
Warnings:
85
 
Note    1265    Data truncated for column 'c' at row 1
86
 
Note    1265    Data truncated for column 'vc' at row 1
 
84
ERROR 22001: Data too long for column 'c' at row 1
87
85
drop table t1;
88
86
create table t1 (b varbinary(2), vb varbinary(2));
89
87
insert into t1 values(0x4120, 0x4120);