Details
Minor
Description
This script:
DROP TABLE IF EXISTS t1,t2; CREATE TABLE t1 (a DATE, b DATE); CREATE TABLE t2 AS SELECT COALESCE(a,b), NULLIF(a,b) FROM t1; SHOW COLUMNS FROM t2;
creates these columns:
+---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | COALESCE(a,b) | date | YES | | NULL | | | NULLIF(a,b) | varchar(10) | YES | | NULL | | +---------------+-------------+------+-----+---------+-------+
NULLIF erroneously created a VARCHAR column.
Notice, on the contrary, COALESCE correctly created a DATE column.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions