← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_crash.result

  • Committer: Brian Aker
  • Date: 2009-08-17 06:21:44 UTC
  • mto: This revision was merged to the branch mainline in revision 1118.
  • Revision ID: brian@gaz-20090817062144-8lxn1sg93pd8nhev
Remove PACK_KEYS

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/join_crash.result
10
10
comments mediumtext,
11
11
PRIMARY KEY  (project_id),
12
12
UNIQUE KEY project (client_ptr,project_name)
13
 
) PACK_KEYS=1;
 
13
);
14
14
INSERT INTO t1 VALUES (1,0,'Rejected Time',1,NULL,NULL,NULL,NULL);
15
15
INSERT INTO t1 VALUES (209,0,'MDGRAD Proposal/Investigation',97,NULL,NULL,NULL,'');
16
16
INSERT INTO t1 VALUES (208,0,'Font 9 Design',84,NULL,NULL,NULL,'');
31
31
PRIMARY KEY  (period_id),
32
32
KEY period_index (period_type,period_key),
33
33
KEY date_index (start_date,end_date)
34
 
) PACK_KEYS=1;
 
34
);
35
35
INSERT INTO t2 VALUES (1,'user_table',98,'2000-01-01 00:00:00',NULL,NULL);
36
36
INSERT INTO t2 VALUES (2,'user_table',99,'2000-01-01 00:00:00',NULL,NULL);
37
37
INSERT INTO t2 VALUES (3,'user_table',100,'2000-01-01 00:00:00',NULL,NULL);
57
57
adjustment float(10,2) default NULL,
58
58
PRIMARY KEY  (budget_id),
59
59
UNIQUE KEY po (project_ptr,po_number)
60
 
) PACK_KEYS=1;
 
60
);
61
61
CREATE TABLE t4 (
62
62
client_id int NOT NULL auto_increment,
63
63
client_row_lock int NOT NULL default '0',
66
66
comments mediumtext,
67
67
PRIMARY KEY  (client_id),
68
68
UNIQUE KEY client_name (client_name)
69
 
) PACK_KEYS=1;
 
69
);
70
70
INSERT INTO t4 VALUES (1,0,'CPS',NULL,NULL);
71
71
select distinct
72
72
t1.project_id as project_id,