SQL Integration does not report DB Size

[bearhntr]

The problem

I am building a new VM hosted HA on ProxMox using the scripts from TTeck - System has been up and running (with very little moved from working ThinClient installed HA) - I want to get everything working as I go.

I installed the SQL integration and used the posted help for it to enter QUERY to pull DB Size on the pre-installed Recorder DB. You can plainly see in this image it is not 0.0.

What version of Home Assistant Core has the issue?

2024.3.3

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

SQL

Link to integration documentation on our website

https://www.home-assistant.io/integrations/sql

Diagnostics information

home-assistant_sql_2024-05-15T17-51-54.435Z.log

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response

[home-assistant]

Hey there @gjohansson-ST, @dougiteixeira, mind taking a look at this issue as it has been labeled with an integration (sql) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of sql can trigger bot actions by commenting:

• @home-assistant close Closes the issue.
• @home-assistant rename Awesome new title Renames the issue.
• @home-assistant reopen Reopen the issue.
• @home-assistant unassign sql Removes the current integration label and assignees on the issue, add the integration domain after the command.
• @home-assistant add-label needs-more-information Add a label (needs-more-information, problem in dependency, problem in custom component) to the issue.
• @home-assistant remove-label needs-more-information Remove a label (needs-more-information, problem in dependency, problem in custom component) on the issue.

_{^{(message by CodeOwnersMention)}}

---

sql documentation
sql source
_{^{(message by IssueLinks)}}