oneiroi
07/05/2022, 5:33 PMSELECT 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 🙇♂️