-
Notifications
You must be signed in to change notification settings - Fork 373
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[osquery 5.13] does not respect ROUND sql #17069
Comments
This appears to be an osquery issue. Here's what I'm seeing on {
"queries": {
"fleet_distributed_query_425": [
{
"pid": "658407",
"total_size": "1215423651840",
"name": "chrome",
"used": "1159118.3200000001"
},
{
"pid": "658476",
"total_size": "1215403827200",
"name": "chrome",
"used": "1159099.4099999999"
},
{
"pid": "1116467",
"total_size": "109725528064",
"name": "WebKitWebProces",
"used": "104642.42"
},
{
"pid": "1116436",
"total_size": "94692233216",
"name": "gnome-shell-por",
"used": "90305.550000000003"
}, |
osquery PR: osquery/osquery#8302 |
@pacamaster This issue has a workaround -- cast the problematic data as text, like: SELECT pid, total_size, name, CAST(ROUND(((total_size * 1.0) / (1024 * 1024)), 2) AS text) AS used FROM processes ORDER BY total_size DESC; |
@getvictor I removed the milestone since this is osquery core, and we are not sure about the ETA. |
QA notesI'm still seeing the issue after building osqueryd on macOS with today's commit in
Query: |
Waiting for latest PR to be merged: osquery/osquery#8355 |
This is a tracking issue for osquery issue: osquery/osquery#8301
Fleet version:
4.45.0
Web browser and operating system:
Current and up-to-date (Chrome Version 121.0.6167.184 (Official Build) (arm64) / Sonoma 14.3.1)
💥 Actual behavior
Running query with
ROUND
returns strange results, osquery shell returns correct data and respectsROUND
SELECT pid, total_size, name, ROUND(((total_size * 1.0) / (1024 * 1024)), 2) AS used FROM processes ORDER BY total_size DESC;
The tagged client reported this issue and I was able to reproduce it in the current Fleet release with our dogfood
🧑💻 Steps to reproduce
ROUND
in osqueryi shell🕯️ More info (optional)
Unsure if this was more of a feature request, but couldn't find the issue filed either for this.
With the extra lines of data it takes up a bunch of extra space/resources.
The text was updated successfully, but these errors were encountered: