Uppercase letters in sql query are always lowercased #3936

New issue

Open

opened 2026-02-28 03:45:44 -05:00 by deekerman · 2 comments

deekerman commented

2026-02-28 03:45:44 -05:00

Owner

Originally created by @kinouzero on GitHub (Jan 28, 2025).

When I try to add a query with a table with the first letter in capital, the query doesn't work

SELECT * FROM public.User
ORDER BY id ASC

I've this error

relation "public.user" does not exist

🛡️ Security Policy

I agree to have read this project Security Policy

Description

No response

👟 Reproduction steps

Make a query on table with an uppercase letter in the name

👀 Expected behavior

Don't lowercase the query

😓 Actual Behavior

lowercase the query

🐻 Uptime-Kuma Version

2.0.0-beta.1

💻 Operating System and Arch

Docker linux

🌐 Browser

All

🖥️ Deployment Environment

Runtime: Docker version 27.4.1, build b9d17ea
Database: external MariaDB
Filesystem used to store the database on: SSD
number of monitors: 178

📝 Relevant log output

Originally created by @kinouzero on GitHub (Jan 28, 2025). ### 📑 I have found these related issues/pull requests When I try to add a query with a table with the first letter in capital, the query doesn't work ```sql SELECT * FROM public.User ORDER BY id ASC ``` I've this error ```sql relation "public.user" does not exist ``` ### 🛡️ Security Policy - [x] I agree to have read this project [Security Policy](https://github.com/louislam/uptime-kuma/security/policy) ### Description _No response_ ### 👟 Reproduction steps Make a query on table with an uppercase letter in the name ### 👀 Expected behavior Don't lowercase the query ### 😓 Actual Behavior lowercase the query ### 🐻 Uptime-Kuma Version 2.0.0-beta.1 ### 💻 Operating System and Arch Docker linux ### 🌐 Browser All ### 🖥️ Deployment Environment - Runtime: Docker version 27.4.1, build b9d17ea - Database: external MariaDB - Filesystem used to store the database on: SSD - number of monitors: 178 ### 📝 Relevant log output ```shell ```