[MDEV-7389] Request: log warnings into SQL_ERROR_LOG Created: 2014-12-29 Updated: 2023-05-24 Resolved: 2023-05-24 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Plugin - SQL_ERROR_LOG |
| Fix Version/s: | 10.11.4 |
| Type: | Task | Priority: | Major |
| Reporter: | Federico Razzoli | Assignee: | Michael Widenius |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Sprint: | 10.0.20, 10.0.22, 10.1.9-2, 10.0.23, 10.0.24, 10.0.28, 10.0.29 | ||||||||||||||||
| Description |
|
Could we have a server variable to log warnings into the SQL_ERROR_LOG? I know I could change the SQL_MODE to convert many warnings into errors, but 1) not all warnings, 2) some queries would not work, which is not what I want. |
| Comments |
| Comment by Sergei Golubchik [ 2015-02-20 ] |
|
The Audit API doesn't support it, unfortunately. The server doesn't report warnings to an audit plugin — and mainly because the Audit API doesn't have a concept of a "warning". If I change the server to report warnings to an audit plugin, the plugin will have no way of distinguishing a warning from an error. Extending the Audit API to support warnings is certainly possible, but it's not that easy. Both Oracle and we have already extended it, and differently. This is something we have to fix and at the same time I could add the support of warnings. But at the moment it's not exactly clear how to do that… |
| Comment by Michael Widenius [ 2023-05-24 ] |
|
Pushed into 10.11 |