These are chat archives for harelba/q
user defined function raised exception.
ls -alh | q 'SELECT * FROM - WHERE c3 REGEXP “staff”;’will cause the error whereas doing
ls -alh * | q 'SELECT * FROM - WHERE c3 REGEXP “staff”;’does not (note the
SELECT FROM - WHERE c3 IS NOT NULL AND c3 regexp '.*’
-m strict, you'll get an error if there are rows with different column counts (such as the "total XXX" row)