---
# TC0
# Test that single value from the end of second interval is returned
test case: Get last value from second interval
in:
  history:
  - itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    data:
    - &row12
      value: value 1.2
      ts: 2017-01-10 10:00:01.200000000 +00:00
    - &row15
      value: value 1.5
      ts: 2017-01-10 10:00:01.500000000 +00:00
    - &row17
      value: value 1.7
      ts: 2017-01-10 10:00:01.700000000 +00:00
    - &row22
      value: value 2.2
      ts: 2017-01-10 10:00:02.200000000 +00:00
    - &row25
      value: value 2.5
      ts: 2017-01-10 10:00:02.500000000 +00:00
    - &row27
      value: value 2.7
      ts: 2017-01-10 10:00:02.700000000 +00:00
    - &row32
      value: value 3.2
      ts: 2017-01-10 10:00:03.200000000 +00:00
    - &row35
      value: value 3.5
      ts: 2017-01-10 10:00:03.500000000 +00:00
    - &row37
      value: value 3.7
      ts: 2017-01-10 10:00:03.700000000 +00:00
    - &row42
      value: value 4.2
      ts: 2017-01-10 10:00:04.200000000 +00:00
    - &row45
      value: value 4.5
      ts: 2017-01-10 10:00:04.500000000 +00:00
    - &row47
      value: value 4.7
      ts: 2017-01-10 10:00:04.700000000 +00:00
    - &row52
      value: value 5.2
      ts: 2017-01-10 10:00:05.200000000 +00:00
    - &row55
      value: value 5.5
      ts: 2017-01-10 10:00:05.500000000 +00:00
    - &row57
      value: value 5.7
      ts: 2017-01-10 10:00:05.700000000 +00:00
  precache:
  - time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    seconds: 0
    count: 1
    end: 2017-01-10 10:00:04.999999999 +00:00
  test:
    time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    end: 2017-01-10 10:00:04.999999999 +00:00
out:
  values:
  - *row47
  cache:
    items:
    - itemid: 1
      value type: ITEM_VALUE_TYPE_STR
      data:
      - *row42
      - *row45
      - *row47
      - *row52
      - *row55
      - *row57
      status:
      active_range: 597
      values_total: 6
      db_cached_from: 2017-01-10 10:00:04.000000000 +00:00
    mode: ZBX_VC_MODE_NORMAL
    hits: 1
    misses: 0
---
# TC1
# Test that single value from the middle of second interval is returned
test case: Get middle value from second interval
in:
  history:
  - itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    data:
    - &row12
      value: value 1.2
      ts: 2017-01-10 10:00:01.200000000 +00:00
    - &row15
      value: value 1.5
      ts: 2017-01-10 10:00:01.500000000 +00:00
    - &row17
      value: value 1.7
      ts: 2017-01-10 10:00:01.700000000 +00:00
    - &row22
      value: value 2.2
      ts: 2017-01-10 10:00:02.200000000 +00:00
    - &row25
      value: value 2.5
      ts: 2017-01-10 10:00:02.500000000 +00:00
    - &row27
      value: value 2.7
      ts: 2017-01-10 10:00:02.700000000 +00:00
    - &row32
      value: value 3.2
      ts: 2017-01-10 10:00:03.200000000 +00:00
    - &row35
      value: value 3.5
      ts: 2017-01-10 10:00:03.500000000 +00:00
    - &row37
      value: value 3.7
      ts: 2017-01-10 10:00:03.700000000 +00:00
    - &row42
      value: value 4.2
      ts: 2017-01-10 10:00:04.200000000 +00:00
    - &row45
      value: value 4.5
      ts: 2017-01-10 10:00:04.500000000 +00:00
    - &row47
      value: value 4.7
      ts: 2017-01-10 10:00:04.700000000 +00:00
    - &row52
      value: value 5.2
      ts: 2017-01-10 10:00:05.200000000 +00:00
    - &row55
      value: value 5.5
      ts: 2017-01-10 10:00:05.500000000 +00:00
    - &row57
      value: value 5.7
      ts: 2017-01-10 10:00:05.700000000 +00:00
  precache:
  - time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    seconds: 0
    count: 1
    end: 2017-01-10 10:00:04.999999999 +00:00
  test:
    time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    end: 2017-01-10 10:00:04.500000000 +00:00
out:
  values:
  - *row45
  cache:
    items:
    - itemid: 1
      value type: ITEM_VALUE_TYPE_STR
      data:
      - *row42
      - *row45
      - *row47
      - *row52
      - *row55
      - *row57
      status:
      active_range: 597
      values_total: 6
      db_cached_from: 2017-01-10 10:00:04.000000000 +00:00
    mode: ZBX_VC_MODE_NORMAL
    hits: 1
    misses: 0
---
# TC1
# Test that single value from the beginning of second interval is returned
test case: Get first value from second interval
in:
  history:
  - itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    data:
    - &row12
      value: value 1.2
      ts: 2017-01-10 10:00:01.200000000 +00:00
    - &row15
      value: value 1.5
      ts: 2017-01-10 10:00:01.500000000 +00:00
    - &row17
      value: value 1.7
      ts: 2017-01-10 10:00:01.700000000 +00:00
    - &row22
      value: value 2.2
      ts: 2017-01-10 10:00:02.200000000 +00:00
    - &row25
      value: value 2.5
      ts: 2017-01-10 10:00:02.500000000 +00:00
    - &row27
      value: value 2.7
      ts: 2017-01-10 10:00:02.700000000 +00:00
    - &row32
      value: value 3.2
      ts: 2017-01-10 10:00:03.200000000 +00:00
    - &row35
      value: value 3.5
      ts: 2017-01-10 10:00:03.500000000 +00:00
    - &row37
      value: value 3.7
      ts: 2017-01-10 10:00:03.700000000 +00:00
    - &row42
      value: value 4.2
      ts: 2017-01-10 10:00:04.200000000 +00:00
    - &row45
      value: value 4.5
      ts: 2017-01-10 10:00:04.500000000 +00:00
    - &row47
      value: value 4.7
      ts: 2017-01-10 10:00:04.700000000 +00:00
    - &row52
      value: value 5.2
      ts: 2017-01-10 10:00:05.200000000 +00:00
    - &row55
      value: value 5.5
      ts: 2017-01-10 10:00:05.500000000 +00:00
    - &row57
      value: value 5.7
      ts: 2017-01-10 10:00:05.700000000 +00:00
  precache:
  - time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    seconds: 0
    count: 1
    end: 2017-01-10 10:00:04.999999999 +00:00
  test:
    time: 2017-01-10 10:10:00.000000000 +00:00
    itemid: 1
    value type: ITEM_VALUE_TYPE_STR
    end: 2017-01-10 10:00:04.400000000 +00:00
out:
  values:
  - *row42
  cache:
    items:
    - itemid: 1
      value type: ITEM_VALUE_TYPE_STR
      data:
      - *row42
      - *row45
      - *row47
      - *row52
      - *row55
      - *row57
      status:
      active_range: 597
      values_total: 6
      db_cached_from: 2017-01-10 10:00:04.000000000 +00:00
    mode: ZBX_VC_MODE_NORMAL
    hits: 1
    misses: 0
...