← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/varbinary.test

  • Committer: Jay Pipes
  • Date: 2009-02-21 16:00:06 UTC
  • mto: (907.1.1 trunk-with-temporal)
  • mto: This revision was merged to the branch mainline in revision 908.
  • Revision ID: jpipes@serialcoder-20090221160006-vnk3wt4qbcz62eru
Removes the TIME column type and related time functions.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/varbinary.test
 
1
# This test uses chmod, can't be run with root permissions
 
2
-- source include/not_as_root.inc
 
3
 
 
4
 
1
5
# Initialise
2
6
--disable_warnings
3
7
drop table if exists t1;
37
41
 
38
42
# End of 4.1 tests
39
43
 
 
44
#
 
45
# Bug #19371 VARBINARY() have trailing zeros after upgrade from 4.1
 
46
#
 
47
 
 
48
# MySQL file formats are not compatible with Drizzle
 
49
# Test with a saved table from 4.1
 
50
copy_file std_data/bug19371.frm $MYSQLTEST_VARDIR/master-data/test/t1.frm;
 
51
chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.frm;
 
52
copy_file std_data/bug19371.MYD $MYSQLTEST_VARDIR/master-data/test/t1.MYD;
 
53
chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.MYD;
 
54
copy_file std_data/bug19371.MYI $MYSQLTEST_VARDIR/master-data/test/t1.MYI;
 
55
chmod 0777 $MYSQLTEST_VARDIR/master-data/test/t1.MYI;
 
56
--error ER_NO_SUCH_TABLE
 
57
show create table t1;
 
58
drop table t1;
40
59
 
41
60
# Check that the fix does not affect table created with current version
42
61
create table t1(a varbinary(255));
57
76
--enable_warnings
58
77
 
59
78
create table table_28127_a(0b02 int);
60
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
61
79
show create table table_28127_a;
62
80
 
63
81
create table table_28127_b(0b2 int);
64
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
65
82
show create table table_28127_b;
66
83
 
67
84
drop table table_28127_a;