Consensys/ethql

transactionsRoles with to and from fields not returning correct transactions

akhila-raju opened this issue · 1 comments

transactionsRoles with the 'to' and 'from' fields specified is returning transactions that satisfy either the 'to' address or the 'from' address or satisfy both. It should return just transactions that satisfy both the 'from' and the 'to' address.

This query

{
  block(number: 5450945) {
    transactionsRoles(from: "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE", to:"0x4156D3342D5c385a87D264F90653733592000581") {
      from {
        address
      }
      to {
        address
      }
    }
  }
}

gave me:

{
    "block": {
      "transactionsRoles": [
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x0D17Ed2bBB242173d72B28bBc42216AC2fE53a88"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x85d505391C63a592Dd6e5C818f2Df0D4212D0B17"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x7619E379B1ee0b48528e3C9055bB7eF5Ff6f46b7"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x0845795a785d761A58ab24e9C5d9ef211BB9a3F5"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x9251E976A7d1107f3c1B4B0ea48dF67EB53F7Ec4"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0xF970b8E36e23F7fC3FD752EeA86f8Be8D83375A6"
          }
        },
        {
          "from": {
            "address": "0x3f5CE5FBFe3E9af3971dD833D26bA9b5C936f0bE"
          },
          "to": {
            "address": "0x4156D3342D5c385a87D264F90653733592000581"
          }
        }
      ]
    }
  }

which is incorrect :)