https://bugs.kde.org/show_bug.cgi?id=498431
Bug ID: 498431
Summary: Some SQL queries with the SQL plugin are not processed
Classification: Applications
Product: kate
Version: 24.08.3
Platform: Manjaro
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: application
Assignee: kwrite-bugs-n...@kde.org
Reporter: isaac.o.bra...@gmail.com
Target Milestone: ---
SUMMARY
Connecting to a PostgreSQL database I can run SELECT queries without any
issue, but trying to run ALTER TABLE queries fails with error
```
ERROR: syntax error at or near "ALTER"
LINE 1: PREPARE qpsqlpstmt_7 AS ALTER TABLE ...
^
(42601) QPSQL: Unable to prepare statement
```
I looked the issue up on Qt and some are reporting that when using QPSQL Alter
Table statements need to be run without preparing them first (hence, I suppose,
the 'Unable to prepare statement' bit).
The action within Kate of preparing the statement seems to be inbuilt, but it
limits the types of statements that can be run.
STEPS TO REPRODUCE
1. Ensure SQL Plugin is enabled
2. Connect to a PostgreSQL database using QPSQL
3. Run a normal SELECT statement to ensure the connection is working
4. Run an ALTER TABLE statement
OBSERVED RESULT
(see error message above)
EXPECTED RESULT
It should run the SQL as is.
SOFTWARE/OS VERSIONS
Linux/KDE Plasma:
KDE Plasma Version: 6.2.4
KDE Frameworks Version: 6.8.0
Qt Version: 6.8.1
ADDITIONAL INFORMATION
--
You are receiving this mail because:
You are watching all bug changes.
