Parameter type inference is order dependent

[AlexHorstkoetter]

This query

SELECT * FROM "users"
WHERE :lastNameFilter IS NULL OR :lastNameFilter = "lastName";

raises the error

Error in query. Details: {
  errorCode: 'check_parameter_resolution_walker',
  hint: undefined,
  message: 'could not determine data type of parameter $1',
  position: '30'
}

However, the equivalent query

SELECT * FROM "users"
WHERE :lastNameFilter = "lastName" OR :lastNameFilter IS NULL;

works just fine. It seems like the parameter type is inferred from its first occurance.

[adelsz]

Thanks for flagging this. We delegate type inference to the Postgres engine and can't really fix this as part of pgTyped.