Bug #13939 | extension to SQL syntax: SELECT DEFAULT_IF_NULL | ||
---|---|---|---|
Submitted: | 11 Oct 2005 20:55 | Modified: | 15 Dec 2010 11:15 |
Reporter: | SweetAs | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
Version: | n/a | OS: | Any (n/a) |
Assigned to: | CPU Architecture: | Any |
[11 Oct 2005 20:55]
SweetAs
[15 Dec 2010 11:15]
Valeriy Kravchuk
Makes some sense, when many columns are selected (or as SQL Server compatibility feature). But for most cases workarounds like mentioned or IFNULL(col1, DEFAULT(col1)) will work.