SELECT '' is NULL rather than empty string · Issue #49 · mithrandie/csvq
Why does SELECT '' result in NULL rather than ''? $ csvq "SELECT '' AS col1" +------+ | col1 | +------+ | NULL | +------+ For comparison, in both MySQL 5.7 and PostgreSQL 13, SELECT '' produces ''.