https://github.com/osquery/osquery logo
Title
o

oneiroi

07/05/2022, 5:33 PM
Hi Everyone, a QQ if I may,
SELECT bundle_short_version FROM apps WHERE bundle_identifier = 'com.google.Chrome' AND bundle_short_version < '103.0.5060.114';
returns 0 results, whilst,
SELECT bundle_short_version FROM apps WHERE bundle_identifier = 'com.google.Chrome' AND bundle_short_version < '103.0.5060.999';
returns :
+----------------------+
| bundle_short_version |
+----------------------+
| 103.0.5060.53        |
+----------------------+
Visually
103.0.5060.53
is less than `103.0.5060.114`yet using the boolean operator does not seem to follow this logic 🤔 . I'm presuming something is awry with my version comparison, any directions would be most appreciated, thank you 🙇‍♂️