diff options
| author | unknown <svoj@april.(none)> | 2006-05-18 18:49:52 +0500 |
|---|---|---|
| committer | unknown <svoj@april.(none)> | 2006-05-18 18:49:52 +0500 |
| commit | 481ba7789b6b3113c34585af84310d01a8c75d1a (patch) | |
| tree | df1b5eb8db09ae65ea711dc3271e2de8e3be3720 /mysql-test/r/heap.result | |
| parent | 7937b3e6a282b5b18a7891e70e8cb8b42b9b0463 (diff) | |
| parent | 0086d5abd9d59dc984d402e07a6df6f9c447f098 (diff) | |
| download | mariadb-git-481ba7789b6b3113c34585af84310d01a8c75d1a.tar.gz | |
Merge april.(none):/home/svoj/devel/mysql/BUG18233/mysql-5.0
into april.(none):/home/svoj/devel/mysql/BUG18233/mysql-5.1
mysql-test/r/heap.result:
Auto merged
storage/heap/hp_create.c:
Auto merged
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index 2c0e8123667..a75f6c96b20 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -718,3 +718,16 @@ Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length I t1 MEMORY 10 Fixed 0 11 0 # 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL t2 MEMORY 10 Fixed 0 12 0 # 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL drop table t1, t2; +CREATE TABLE t1(a VARCHAR(1), b VARCHAR(2), c VARCHAR(256), +KEY(a), KEY(b), KEY(c)) ENGINE=MEMORY; +INSERT INTO t1 VALUES('a','aa',REPEAT('a', 256)),('a','aa',REPEAT('a',256)); +SELECT COUNT(*) FROM t1 WHERE a='a'; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 WHERE b='aa'; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 WHERE c=REPEAT('a',256); +COUNT(*) +2 +DROP TABLE t1; |