← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/686197.result

  • Committer: Mark Atwood
  • Date: 2011-07-18 21:41:28 UTC
  • mfrom: (2363.1.5 drizzle-trunk)
  • Revision ID: me@mark.atwood.name-20110718214128-tj8my4mqt62dslxn
merge lp:~brianaker/drizzle/798940

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/r/686197.result
16
16
Table   Create Table
17
17
t1      CREATE TABLE `t1` (
18
18
  `A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
19
 
  UNIQUE KEY `A` (`A`)
 
19
  UNIQUE KEY `A` (`A`) USING BTREE
20
20
) ENGINE=InnoDB COLLATE = utf8_general_ci
21
21
ALTER TABLE t1 ADD COLUMN b INT DEFAULT 1 NOT NULL;
22
22
SELECT A,B from t1 ORDER BY A;
44
44
t1      CREATE TABLE `t1` (
45
45
  `A` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
46
46
  `b` INT DEFAULT NULL,
47
 
  UNIQUE KEY `A` (`A`)
 
47
  UNIQUE KEY `A` (`A`) USING BTREE
48
48
) ENGINE=InnoDB COLLATE = utf8_general_ci
49
49
ALTER TABLE t1 MODIFY COLUMN b int DEFAULT 42 NOT NULL;
50
50
SELECT A,B from t1 ORDER BY A;