LinuxJedi Is the test suite fixed ? If not let us fix it and close it

not yet, it was flagged in my MCOL-25 test as something that needed fixing too

With infinidb: 5.1.73-log InfiniDB 4.6.7-1 cot(0) gets mapped to null regardless of storage engine.

With latest build columnstore: 10.1.17-MariaDB Columnstore 1.0.4-1, innodb returns an out of range error:
MariaDB [test]> select id, cot(id) from testi;
ERROR 1690 (22003): DOUBLE value is out of range in 'cot(`test`.`testi`.`id`)'
MariaDB [test]>

While columnstore continues to return null.

cot(0) is invalid as it is basically a divide by zero so this should also return an error in column store.

Good catch. If you explicitly use '0' (as the test did) it errors. If it is a column value it returns NULL.

This one will probably need a test which isn't in test001 (because the error will cause a test failure).

Note: the COT(0) test has been remove from bug2954.sql as it wasn't using ColumnStore's COT() function.

Build verified: a1.0.4-1
Name : mariadb-columnstore-platform
Version : 1.0.4
Release : 1
Architecture: x86_64
Install Date: Tue 04 Oct 2016 01:38:36 PM CDT
Group : Applications/Databases
Size : 11506458
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.4-1.src.rpm
Build Date : Fri 30 Sep 2016 01:02:40 PM CDT

MariaDB [mytest]> select cinteger, cot(cinteger), cdecimal4_2,cot(cdecimal4_2) from datatypetestm;
-------------------------------------------------------------+

-------------------------------------------------------------+

-------------------------------------------------------------+
11 rows in set (0.04 sec)