~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap.test

• browse files at revision 755.2.1
• compare with another revision
• download diff
• download tarball
• view history from revision 755.2.1

• reverse the comparison (755.2.1 to 482)
• stop comparing with revision 482

Show diffs side-by-side

added

removed

tests/t/heap.test

284

284

select sql_big_result trim(v),count(c) from t1 group by v limit 10;

285

285

select c,count(*) from t1 group by c limit 10;

286

286

select c,count(t) from t1 group by c limit 10;

287

 

select sql_big_result c,count(t) from t1 group by c limit 10;

288

287

select t,count(*) from t1 group by t limit 10;

289

288

select t,count(t) from t1 group by t limit 10;

290

289

select sql_big_result trim(t),count(t) from t1 group by t limit 10;

396

395

show create table t1;

397

396

drop table t1;

398

397

 

399

 

create table t1 (v varchar(65530), key(v(10)));

 

398

create table t1 (v varchar(16383), key(v(10)));

400

399

show create table t1;

401

 

insert into t1 values(repeat('a',65530));

402

 

select length(v) from t1 where v=repeat('a',65530);

 

400

insert into t1 values(repeat('a',16383));

 

401

select length(v) from t1 where v=repeat('a',16383);

403

402

drop table t1;

404

403

 

405

404

#

454

453

#

455

454

create table t1 (c char(10)) engine=memory;

456

455

create table t2 (c varchar(10)) engine=memory;

457

 

--replace_column 8 #

 

456

--replace_column 3 # 8 #

458

457

show table status like 't_';

459

458

drop table t1, t2;

460

459

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1