Project

General

Custom queries

Profile

Actions
Copy link

Bug #11282

closed

search on numeric facts is broken if using "~".

Added by Amir Fefer almost 10 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Imri Zvik
Category:
Facts
Target version:
1.10.0
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/2626
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

When trying to search a numeric value fact and using operator '~' there a 500 error:
"PG::UndefinedFunction: ERROR: operator does not exist: numeric ~~* integer
LINE 1: ... E'^\\d+$' AND CAST ILIKE 0)) ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts."

recreate:
search- facts.uptime_days ~ 0

Related issues 1 (0 open — 1 closed)

Related to Foreman - Feature #11150: Allow searching of facts as types other than stringClosedImri Zvik07/19/2015Actions
#1

Updated by Dominic Cleal almost 10 years ago

  • Related to Feature #11150: Allow searching of facts as types other than string added
#2

Updated by Dominic Cleal almost 10 years ago

  • Translation missing: en.field_release set to 63
#6

Updated by The Foreman Bot over 9 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/2622 added
  • Pull request deleted ()
#7

Updated by Dominic Cleal over 9 years ago

  • Status changed from Ready For Testing to New
  • Pull request added
  • Pull request deleted (https://github.com/theforeman/foreman/pull/2622)
#8

Updated by The Foreman Bot over 9 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/2626 added
  • Pull request deleted ()
#9

Updated by Imri Zvik over 9 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
#10

Updated by Dominic Cleal over 9 years ago

  • Assignee set to Imri Zvik
Actions
Copy link

Also available in: Atom PDF