← Back to branch summary

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

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

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;