diff options
| author | serg@serg.mylan <> | 2004-11-22 14:53:18 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-11-22 14:53:18 +0100 |
| commit | 41c33c29a3bbdd6a32ad3103545abe726f84dbb9 (patch) | |
| tree | 5275ac54d53fc6e3a0af08020e0fde153e8a2493 /mysql-test/r/heap.result | |
| parent | 4e52cc2ded1316c2607079e9f4d513d52fc06312 (diff) | |
| download | mariadb-git-41c33c29a3bbdd6a32ad3103545abe726f84dbb9.tar.gz | |
Bug #6748 heap_rfirst() doesn't work (and never did!)
range for BETWEEN typo fixed
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index 4950799137a..1f994b100e2 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -233,3 +233,10 @@ SELECT * FROM t1 WHERE B is not null; a B 1 1 DROP TABLE t1; +CREATE TABLE t1 (pseudo char(35) PRIMARY KEY, date int(10) unsigned NOT NULL) ENGINE=HEAP; +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); +DELETE FROM t1 WHERE date<1101106546; +SELECT * FROM t1; +pseudo date +ZoomZip 1101106546 +DROP TABLE t1; |