summaryrefslogtreecommitdiff
path: root/test/suite/test_join05.py
blob: ef2be4c646085e5827b708a8a6f3cd6377fe9cb9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
#!/usr/bin/env python
#
# Public Domain 2014-2016 MongoDB, Inc.
# Public Domain 2008-2014 WiredTiger, Inc.
#
# This is free and unencumbered software released into the public domain.
#
# Anyone is free to copy, modify, publish, use, compile, sell, or
# distribute this software, either in source code form or as a compiled
# binary, for any purpose, commercial or non-commercial, and by any
# means.
#
# In jurisdictions that recognize copyright laws, the author or authors
# of this software dedicate any and all copyright interest in the
# software to the public domain. We make this dedication for the benefit
# of the public at large and to the detriment of our heirs and
# successors. We intend this dedication to be an overt act of
# relinquishment in perpetuity of all present and future rights to this
# software under copyright law.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
# OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
# ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.

import wiredtiger, wttest
from wtscenario import check_scenarios, multiply_scenarios, number_scenarios

# test_join05.py
#    Tests based on JIRA reports
class test_join05(wttest.WiredTigerTestCase):

    # test join having the first index just be lt/le
    def test_wt_2384(self):
        self.session.create("table:test_2384",
                       "key_format=i,value_format=i,columns=(k,v)")
        self.session.create("index:test_2384:index", "columns=(v)")
        cursor = self.session.open_cursor("table:test_2384", None, None)
        cursor[1] = 11
        cursor[2] = 12
        cursor[3] = 13
        cursor.close()

        cursor = self.session.open_cursor("index:test_2384:index", None, None)
        cursor.set_key(13)
        self.assertEquals(cursor.search(), 0)

        jcursor = self.session.open_cursor("join:table:test_2384", None, None)
        self.session.join(jcursor, cursor, "compare=lt")

        nr_found = 0
        while jcursor.next() == 0:
            [k] = jcursor.get_keys()
            [v] = jcursor.get_values()
            #self.tty("jcursor: k=" + str(k) + ", v=" + str(v))
            nr_found += 1

        self.assertEquals(nr_found, 2)
        jcursor.close()
        cursor.close()

if __name__ == '__main__':
    wttest.run()