Bug #40255 | INFORMATION_SCHEMA.WARNINGS - a CREATE/INSERT .. SELECT friendly table | ||
---|---|---|---|
Submitted: | 22 Oct 2008 15:10 | Modified: | 23 Oct 2008 11:29 |
Reporter: | Serdar S. Kacar | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any | |
Tags: | CREATE ... SELECT, cursor, INSERT ... SELECT, show warnings |
[22 Oct 2008 15:10]
Serdar S. Kacar
[22 Oct 2008 15:29]
Valeriy Kravchuk
Thank you for a reasonable feature request.
[22 Oct 2008 20:04]
Marc ALFF
This is related to: WL#2110 (GET DIAGNOSTICS)
[23 Oct 2008 10:57]
Serdar S. Kacar
Note that SHOW WARNINGS is also not CURSOR friendly. So a workaround using CURSORs is not possible.
[23 Oct 2008 11:29]
Serdar S. Kacar
Many people need similar functionality and have similar concerns : http://bugs.mysql.com/bug.php?id=11660 Alhough I support having a session SQLSTATE variables like @@SQLSTATE and @@SQLSTATE_MESSAGE, they are limited to the single row of id and message. They have their own use. It is close but a separate topic. On the otherhand, SHOW WARNINGS is much more deep as a single statement can result in "multiple" notes/warnings/errors. So its INFORMATION_SCHEMA counterpart could be much more useful. Besides it is consistent with MySQL SHOW/INFORMATION_SCHEMA tradition and (in my opinion) cleaner/easier to implement.
[29 Oct 2008 20:37]
Peter Gulutzan
This is related to http://forge.mysql.com/worklog/task.php?id=2111 GET DIAGNOSTICS And Bug#10797. And Bug#11660. And Bug#16371.