summaryrefslogtreecommitdiff
path: root/src/third_party/wiredtiger/test/suite/test_hs23.py
blob: b251688f5943f2c4a14f44e8d03ba177436b986e (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
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
#!/usr/bin/env python
#
# Public Domain 2014-present 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 wttest
from wtscenario import make_scenarios

# test_hs23.py
# Test the case that we have update, out of order timestamp
# update, and update again in the same transaction
class test_hs23(wttest.WiredTigerTestCase):
    conn_config = 'cache_size=50MB'

    format_values = [
        ('column', dict(key_format='r', key=1, value_format='S')),
        ('column-fix', dict(key_format='r', key=1, value_format='8t')),
        ('string-row', dict(key_format='S', key=str(0), value_format='S')),
    ]

    scenarios = make_scenarios(format_values)

    def test(self):
        uri = 'table:test_hs23'
        format = 'key_format={},value_format={}'.format(self.key_format, self.value_format)
        self.session.create(uri, format)
        cursor = self.session.open_cursor(uri)
        self.conn.set_timestamp(
            'oldest_timestamp=' + self.timestamp_str(1) + ',stable_timestamp=' + self.timestamp_str(1))

        key = self.key

        if self.value_format == '8t':
            value1 = 97 # 'a'
            value2 = 98 # 'b'
            value3 = 99 # 'c'
            value4 = 100 # 'd'
            value5 = 101 # 'e'
        else:
            value1 = 'a'
            value2 = 'b'
            value3 = 'c'
            value4 = 'd'
            value5 = 'e'

        # Insert a key.
        self.session.begin_transaction()
        cursor[key] = value1
        self.session.commit_transaction('commit_timestamp=' + self.timestamp_str(2))

        # Update at 10, update at 20, update at 15 (out of order), and
        # update at 20 in the same transaction
        self.session.begin_transaction()
        cursor.set_key(key)
        cursor.set_value(value2)
        self.session.timestamp_transaction(
            'commit_timestamp=' + self.timestamp_str(10))
        self.assertEquals(cursor.update(), 0)

        cursor.set_key(key)
        cursor.set_value(value3)
        self.session.timestamp_transaction(
            'commit_timestamp=' + self.timestamp_str(20))
        self.assertEquals(cursor.update(), 0)

        cursor.set_key(key)
        cursor.set_value(value4)
        self.session.timestamp_transaction(
            'commit_timestamp=' + self.timestamp_str(15))
        self.assertEquals(cursor.update(), 0)

        cursor.set_key(key)
        cursor.set_value(value5)
        self.session.timestamp_transaction(
            'commit_timestamp=' + self.timestamp_str(20))
        self.assertEquals(cursor.update(), 0)
        self.session.commit_transaction()

        # Do a checkpoint to trigger
        # history store reconciliation.
        self.session.checkpoint()

        evict_cursor = self.session.open_cursor(uri, None, "debug=(release_evict)")

        # Search the key to evict it.
        self.session.begin_transaction()
        self.assertEqual(evict_cursor[key], value5)
        self.assertEqual(evict_cursor.reset(), 0)
        self.session.rollback_transaction()

        # Search the latest update
        self.session.begin_transaction("read_timestamp=" + self.timestamp_str(20))
        self.assertEqual(cursor[key], value5)
        self.session.rollback_transaction()

        # Search the out of order timestamp update
        self.session.begin_transaction("read_timestamp=" + self.timestamp_str(15))
        self.assertEqual(cursor[key], value4)
        self.session.rollback_transaction()