← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/backwards_compatibility.result

  • Committer: patrick crews
  • Date: 2011-04-22 22:41:58 UTC
  • mto: (2274.1.7 dbqp_server_setup)
  • mto: This revision was merged to the branch mainline in revision 2312.
  • Revision ID: gleebix@gmail.com-20110422224158-2o8apbd9absd7lnt
Updated the .test file with cleanup + info and removed some debuging code

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/backwards_compatibility.result
53
53
8990592231115063296     f       v       OGNJD   NULL    KPOBP   -579731456      i       u       NULL    that's  really  i       48      3       -621150208      9       -7248262125276102656    y       l       but
54
54
NULL    t       good    HEFMW   9       PNINW   7       k       d       463863808       m       a       t       49      3       1192755200      9       -2311753983724617728    KEVRQ   l       HZMCU
55
55
8       z       some    w       NULL    KUJES   -2143551488     u       EOYYW   5       FIUID   s       n       50      6       4       8       721138890332700672      q       l       OLIZZ
56
 
DESC A;
57
 
Field   Type    Null    Default Default_is_NULL On_Update
58
 
col_bigint      BIGINT  YES             YES     
59
 
col_enum        ENUM    YES             YES     
60
 
col_char_10     VARCHAR YES             YES     
61
 
col_char_1024   VARCHAR YES             YES     
62
 
col_int INTEGER YES             YES     
63
 
col_char_10_not_null    VARCHAR NO              NO      
64
 
col_int_not_null_key    INTEGER NO              NO      
65
 
col_enum_not_null       ENUM    NO              NO      
66
 
col_char_1024_not_null_key      VARCHAR NO              NO      
67
 
col_int_key     INTEGER YES             YES     
68
 
col_char_10_key VARCHAR YES             YES     
69
 
col_char_1024_not_null  VARCHAR NO              NO      
70
 
col_enum_not_null_key   ENUM    NO              NO      
71
 
pk      INTEGER NO              NO      
72
 
col_bigint_key  BIGINT  YES             YES     
73
 
col_int_not_null        INTEGER NO              NO      
74
 
col_bigint_not_null     BIGINT  NO              NO      
75
 
col_bigint_not_null_key BIGINT  NO              NO      
76
 
col_char_10_not_null_key        VARCHAR NO              NO      
77
 
col_enum_key    ENUM    YES             YES     
78
 
col_char_1024_key       VARCHAR YES             YES     
 
56
SHOW CREATE TABLE A;
 
57
Table   Create Table
 
58
A       CREATE TABLE `A` (
 
59
  `col_bigint` BIGINT DEFAULT NULL,
 
60
  `col_enum` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
 
61
  `col_char_10` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
 
62
  `col_char_1024` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,
 
63
  `col_int` INT DEFAULT NULL,
 
64
  `col_char_10_not_null` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
 
65
  `col_int_not_null_key` INT NOT NULL,
 
66
  `col_enum_not_null` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
 
67
  `col_char_1024_not_null_key` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,
 
68
  `col_int_key` INT DEFAULT NULL,
 
69
  `col_char_10_key` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
 
70
  `col_char_1024_not_null` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,
 
71
  `col_enum_not_null_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL,
 
72
  `pk` INT NOT NULL AUTO_INCREMENT,
 
73
  `col_bigint_key` BIGINT DEFAULT NULL,
 
74
  `col_int_not_null` INT NOT NULL,
 
75
  `col_bigint_not_null` BIGINT NOT NULL,
 
76
  `col_bigint_not_null_key` BIGINT NOT NULL,
 
77
  `col_char_10_not_null_key` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,
 
78
  `col_enum_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL,
 
79
  `col_char_1024_key` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,
 
80
  PRIMARY KEY (`pk`),
 
81
  KEY `col_int_not_null_key` (`col_int_not_null_key`),
 
82
  KEY `col_char_1024_not_null_key` (`col_char_1024_not_null_key`(255)),
 
83
  KEY `col_int_key` (`col_int_key`),
 
84
  KEY `col_char_10_key` (`col_char_10_key`),
 
85
  KEY `col_enum_not_null_key` (`col_enum_not_null_key`),
 
86
  KEY `col_bigint_key` (`col_bigint_key`),
 
87
  KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),
 
88
  KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),
 
89
  KEY `col_enum_key` (`col_enum_key`),
 
90
  KEY `col_char_1024_key` (`col_char_1024_key`(255))
 
91
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
92
DROP TABLE A;