Posted over 11 years ago. Visible to the public. Repeats.
MySQL: CONCAT with NULL fields
In MySQL,
CopyCONCAT('foo', 'bar', NULL) = NULL
the NULL always wins in MySQL.
If you would rather treat NULL as an empty string, use
CONCAT_WS
Archive
(concatenation with separator) instead:
CopyCONCAT_WS('', 'foo', 'bar', NULL) = 'foobar'
PostgreSQL
In PostgreSQL the NULL is not viral in CONCAT:
CopyCONCAT('foo', 'bar', NULL) = 'foobar'
Does your version of Ruby on Rails still receive security updates?
Rails LTS provides security patches for unsupported versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2).
