← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap.test

  • Committer: Brian Aker
  • Date: 2008-08-05 06:19:05 UTC
  • mfrom: (244.1.1 drizzle-mem-ebay)
  • mto: This revision was merged to the branch mainline in revision 264.
  • Revision ID: brian@tangent.org-20080805061905-1r8krslxae65qh76
Merge from Harrison Fisk of the Ebay + Google Hash engine.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/heap.test
155
155
# Bug#4411 Server hangs when trying to SELECT MAX(id) from an empty HEAP table
156
156
#
157
157
CREATE TABLE `job_titles` (
158
 
  `job_title_id` int(6) unsigned NOT NULL default '0',
 
158
  `job_title_id` int unsigned NOT NULL default '0',
159
159
  `job_title` char(18) NOT NULL default '',
160
160
  PRIMARY KEY  (`job_title_id`),
161
161
  UNIQUE KEY `job_title_id` (`job_title_id`,`job_title`)
179
179
# Bug #6748
180
180
# heap_rfirst() doesn't work (and never did!)
181
181
#
182
 
CREATE TABLE t1 (pseudo char(35) PRIMARY KEY, date int(10) unsigned NOT NULL) ENGINE=HEAP;
 
182
CREATE TABLE t1 (pseudo char(35) PRIMARY KEY, date int unsigned NOT NULL) ENGINE=HEAP;
183
183
INSERT INTO t1 VALUES ('massecot',1101106491),('altec',1101106492),('stitch+',1101106304),('Seb Corgan',1101106305),('beerfilou',1101106263),('flaker',1101106529),('joce8',5),('M4vrick',1101106418),('gabay008',1101106525),('Vamp irX',1101106291),('ZoomZip',1101106546),('rip666',1101106502),('CBP ',1101106397),('guezpard',1101106496);
184
184
DELETE FROM t1 WHERE date<1101106546;
185
185
SELECT * FROM t1;
224
224
show create table t1;
225
225
alter table t1 modify v char(10);
226
226
show create table t1;
227
 
alter table t1 modify t varchar(10);
 
227
alter table t1 modify t varchar(50);
228
228
show create table t1;
229
229
select concat('*',v,'*',c,'*',t,'*') from t1;
230
230
drop table t1,t2,t3;