← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/heap_btree.test

  • Committer: Brian Aker
  • Date: 2010-02-14 02:02:48 UTC
  • mfrom: (1273.13.64 fix_is)
  • Revision ID: brian@gaz-20100214020248-bhovaejhz9fmer3q
Merge in data_dictionary.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/heap_btree.test
223
223
#
224
224
# BUG#18160 - Memory-/MEMORY Table endless growing indexes
225
225
#
226
 
CREATE TEMPORARY TABLE t1(val INT, KEY USING BTREE(val)) ENGINE=memory;
227
 
INSERT INTO t1 VALUES(0);
228
 
--replace_result 37 21
229
 
SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='t1';
230
 
UPDATE t1 SET val=1;
231
 
--replace_result 37 21
232
 
SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='t1';
233
 
DROP TABLE t1;
 
226
#CREATE TEMPORARY TABLE t1(val INT, KEY USING BTREE(val)) ENGINE=memory;
 
227
#INSERT INTO t1 VALUES(0);
 
228
#--replace_result 37 21
 
229
#SELECT INDEX_LENGTH FROM data_dictionary.tables WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='t1';
 
230
#UPDATE t1 SET val=1;
 
231
#--replace_result 37 21
 
232
#SELECT INDEX_LENGTH FROM data_dictionary.tables WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='t1';
 
233
#DROP TABLE t1;
234
234
 
235
235
#
236
236
# BUG#12873 - BTREE index on MEMORY table with multiple NULL values doesn't