]> git.saurik.com Git - redis.git/blame - tests/unit/sort.tcl
faster server starting in Redis tests
[redis.git] / tests / unit / sort.tcl
CommitLineData
5d4f3a8c
PN
1start_server {
2 tags {"sort"}
3 overrides {
4 "list-max-ziplist-value" 16
5 "list-max-ziplist-entries" 32
2b9a5947 6 "set-max-intset-entries" 32
5d4f3a8c
PN
7 }
8} {
9 proc create_random_dataset {num cmd} {
10 set tosort {}
11 set result {}
12 array set seenrand {}
13 r del tosort
14 for {set i 0} {$i < $num} {incr i} {
15 # Make sure all the weights are different because
16 # Redis does not use a stable sort but Tcl does.
17 while 1 {
18 randpath {
19 set rint [expr int(rand()*1000000)]
20 } {
21 set rint [expr rand()]
22 }
23 if {![info exists seenrand($rint)]} break
24 }
25 set seenrand($rint) x
26 r $cmd tosort $i
27 r set weight_$i $rint
28 r hset wobj_$i weight $rint
29 lappend tosort [list $i $rint]
30 }
31 set sorted [lsort -index 1 -real $tosort]
32 for {set i 0} {$i < $num} {incr i} {
33 lappend result [lindex $sorted $i 0]
34 }
35 set _ $result
36 }
37
ced6709c
PN
38 foreach {num cmd enc title} {
39 16 lpush ziplist "Ziplist"
452ccf7a 40 1000 lpush linkedlist "Linked list"
41 10000 lpush linkedlist "Big Linked list"
029e5577 42 16 sadd intset "Intset"
452ccf7a 43 1000 sadd hashtable "Hash table"
44 10000 sadd hashtable "Big Hash table"
ced6709c
PN
45 } {
46 set result [create_random_dataset $num $cmd]
47 assert_encoding $enc tosort
48
49 test "$title: SORT BY key" {
50 assert_equal $result [r sort tosort {BY weight_*}]
51 }
5d4f3a8c 52
ced6709c
PN
53 test "$title: SORT BY hash field" {
54 assert_equal $result [r sort tosort {BY wobj_*->weight}]
55 }
5d4f3a8c
PN
56 }
57
ced6709c 58 set result [create_random_dataset 16 lpush]
5d4f3a8c
PN
59 test "SORT GET #" {
60 assert_equal [lsort -integer $result] [r sort tosort GET #]
61 }
62
63 test "SORT GET <const>" {
64 r del foo
65 set res [r sort tosort GET foo]
66 assert_equal 16 [llength $res]
67 foreach item $res { assert_equal {} $item }
68 }
69
70 test "SORT GET (key and hash) with sanity check" {
71 set l1 [r sort tosort GET # GET weight_*]
72 set l2 [r sort tosort GET # GET wobj_*->weight]
73 foreach {id1 w1} $l1 {id2 w2} $l2 {
74 assert_equal $id1 $id2
75 assert_equal $w1 [r get weight_$id1]
76 assert_equal $w2 [r get weight_$id1]
77 }
78 }
79
80 test "SORT BY key STORE" {
81 r sort tosort {BY weight_*} store sort-res
82 assert_equal $result [r lrange sort-res 0 -1]
83 assert_equal 16 [r llen sort-res]
84 assert_encoding ziplist sort-res
85 }
86
87 test "SORT BY hash field STORE" {
88 r sort tosort {BY wobj_*->weight} store sort-res
89 assert_equal $result [r lrange sort-res 0 -1]
90 assert_equal 16 [r llen sort-res]
91 assert_encoding ziplist sort-res
92 }
93
94 test "SORT DESC" {
95 assert_equal [lsort -decreasing -integer $result] [r sort tosort {DESC}]
96 }
97
98 test "SORT ALPHA against integer encoded strings" {
98578b57
PN
99 r del mylist
100 r lpush mylist 2
101 r lpush mylist 1
102 r lpush mylist 3
103 r lpush mylist 10
104 r sort mylist alpha
105 } {1 10 2 3}
106
5d4f3a8c
PN
107 test "SORT sorted set" {
108 r del zset
109 r zadd zset 1 a
110 r zadd zset 5 b
111 r zadd zset 2 c
112 r zadd zset 10 d
113 r zadd zset 3 e
114 r sort zset alpha desc
115 } {e d c b a}
98578b57 116
5d4f3a8c
PN
117 test "SORT sorted set: +inf and -inf handling" {
118 r del zset
119 r zadd zset -100 a
120 r zadd zset 200 b
121 r zadd zset -300 c
122 r zadd zset 1000000 d
123 r zadd zset +inf max
124 r zadd zset -inf min
125 r zrange zset 0 -1
126 } {min c a b d max}
98578b57 127
5d4f3a8c
PN
128 test "SORT regression for issue #19, sorting floats" {
129 r flushdb
130 set floats {1.1 5.10 3.10 7.44 2.1 5.75 6.12 0.25 1.15}
131 foreach x $floats {
132 r lpush mylist $x
133 }
134 assert_equal [lsort -real $floats] [r sort mylist]
135 }
98578b57 136
5d4f3a8c
PN
137 tags {"slow"} {
138 set num 100
139 set res [create_random_dataset $num lpush]
98578b57 140
5d4f3a8c 141 test "SORT speed, $num element list BY key, 100 times" {
7f7499ee
PN
142 set start [clock clicks -milliseconds]
143 for {set i 0} {$i < 100} {incr i} {
144 set sorted [r sort tosort {BY weight_* LIMIT 0 10}]
145 }
146 set elapsed [expr [clock clicks -milliseconds]-$start]
147 puts -nonewline "\n Average time to sort: [expr double($elapsed)/100] milliseconds "
148 flush stdout
5d4f3a8c 149 }
98578b57 150
5d4f3a8c 151 test "SORT speed, $num element list BY hash field, 100 times" {
7f7499ee
PN
152 set start [clock clicks -milliseconds]
153 for {set i 0} {$i < 100} {incr i} {
154 set sorted [r sort tosort {BY wobj_*->weight LIMIT 0 10}]
155 }
156 set elapsed [expr [clock clicks -milliseconds]-$start]
157 puts -nonewline "\n Average time to sort: [expr double($elapsed)/100] milliseconds "
158 flush stdout
5d4f3a8c 159 }
98578b57 160
5d4f3a8c 161 test "SORT speed, $num element list directly, 100 times" {
7f7499ee
PN
162 set start [clock clicks -milliseconds]
163 for {set i 0} {$i < 100} {incr i} {
164 set sorted [r sort tosort {LIMIT 0 10}]
165 }
166 set elapsed [expr [clock clicks -milliseconds]-$start]
167 puts -nonewline "\n Average time to sort: [expr double($elapsed)/100] milliseconds "
168 flush stdout
5d4f3a8c 169 }
98578b57 170
5d4f3a8c 171 test "SORT speed, $num element list BY <const>, 100 times" {
7f7499ee
PN
172 set start [clock clicks -milliseconds]
173 for {set i 0} {$i < 100} {incr i} {
174 set sorted [r sort tosort {BY nokey LIMIT 0 10}]
175 }
176 set elapsed [expr [clock clicks -milliseconds]-$start]
177 puts -nonewline "\n Average time to sort: [expr double($elapsed)/100] milliseconds "
178 flush stdout
98578b57 179 }
5d4f3a8c 180 }
98578b57 181}