Posted almost 9 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 (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 old versions of Ruby on Rails (3.2 and 2.3).
