Lookup of asset id 0 yields unexpected behavior.

[barnjamin]

Subject of the issue

A request like https://mainnet-idx.algonode.cloud/v2/assets/0

Will generate the query

 SELECT index, creator_addr, params, created_at, closed_at, deleted FROM asset a WHERE NOT a.deleted ORDER BY index ASC LIMIT 1

Which just returns the first asset it comes across by index since the 0 is omitted from the query parameters.

This is strange behavior and should either be documented or return a 404

Your environment

Indexer 2.11.1