Hi Everyone, a QQ if I may, `SELECT bundle_short_v...
# general
o
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 :
Copy code
+----------------------+
| 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 🙇‍♂️