Error when querying issues using two or more negative Milestone filters: ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean
Summary
Querying the issues list via the UI using two negative Milestone
filters will render two errors:
An error occurred while loading issues
Failed to get issue count
Relevant logs and/or screenshots
For the An error occurred while loading issues
error message:
https://sentry.gitlab.net/gitlab/gitlabcom/issues/3190934/?referrer=gitlab_plugin
PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean: "Beta"
LINE 1: ...id" IN (1)) AND (milestones.title != 'March 2022','Beta' OR ...
^
lib/gitlab/graphql/tracers/timer_tracer.rb:20:in `trace'
yield
lib/gitlab/graphql/generic_tracing.rb:40:in `with_labkit_tracing'
return yield unless Labkit::Tracing.enabled?
lib/gitlab/graphql/generic_tracing.rb:30:in `platform_trace'
with_labkit_tracing(tags, &block)
lib/gitlab/graphql/tracers/logger_tracer.rb:14:in `trace'
yield
lib/gitlab/graphql/tracers/metrics_tracer.rb:13:in `trace'
result = yield
...
(245 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR: invalid input syntax for type boolean: "Beta"
LINE 1: ...id" IN (1)) AND (milestones.title != 'March 2022','Beta' OR ...
^
A slightly different exception is generated for the Failed to get issue count
error, Sentry link here, but unsure if a different issue should be opened as both errors seem to have the same root cause.
Output of checks
This bug happens on GitLab.com
Edited by Alejandro Guerrero