Coalesc and limit error (sqlsmith)

[monetdb-team]

Date: 2017-05-13 23:04:14 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.25.21 (Dec2016-SP4)
CC: @njnes

Last updated: 2017-06-12 15:14:35 +0200

Comment 25318

Date: 2017-05-13 23:04:14 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0
Build Identifier:

The error reported is '!illegal argument'
Unclear why this message is raised.

Reproducible: Always

Steps to Reproduce:

select role_id,
cast(coalesce(role_id, login_id) as int)
from sys.user_role
limit 145;

Comment 25323

Date: 2017-05-14 21:55:10 +0200
From: @njnes

Seems to work now on Dec2016