signum-network / signum-node

Signum Node
https://signum.network
GNU General Public License v3.0
194 stars 77 forks source link

Indirect Incoming on GetAccountTransactions causes error when using MariaDB #818

Open ohager opened 4 months ago

ohager commented 4 months ago

A recent update to improve fetching performance for GetAccountTransactions with includeIndirect=true fails for MariaDB. Note that no issues were reported or seen when using H2 and/or Sqlite.

Apparently, the resulting query string (generated by jooq) is not compatible with MariaDB.

http://localhost:8125/burst?requestType=getAccountTransactions&account=10408446182290759991&firstIndex=0&lastIndex=9&includeIndirect=true

returns:

{"errorCode":1,"errorDescription":"Incorrect request","requestProcessingTime":1}

ohager commented 2 months ago

should be fixed with #829