Zabbix

---

test case: "successfully selected #1"

in:

  sql: select value from tablename1;

out:

  uint64:

    - &1 7

db data:

  tablename1:

    # value

    - [*1]

---

test case: "successfully selected #2"

in:

  sql: select test_1 from tablename2 where 1=1;

out:

  uint64:

    - &1 7

    - &2 8

db data:

  tablename2:

    # test_1

    - [*1]

    - [*2]

---

test case: "successfully selected #3"

in:

  sql: select test_2 from tablename1 join tablename2 as a1=b2;

out:

  uint64:

    - &1 7

db data:

  tablename1 tablename2:

    # test_2

    - [*1]

---

test case: "failed selected #1"

in:

  sql: select test_2 from tablename1 join tablename2 as a1=b2;

out:

  uint64:

    - &1 7

db data:

  tablename1 tablename2:

    # test_2

    - [*1]

...