On Fri, Sep 18, 2015 at 07:14:45PM +0200, Robert Koch wrote:
Following the manual
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/statistics
I am trying to reproduce this, but it fails with a type conversion error:
sql>call sys.analyze('sys', 'types'); conversion of string 'sys' to type int failed. sql>SELECT * FROM sys.statistics; +-----------+------+-------+-------+--------+-------+--------+------+--------+--------+ | column_id | type | width | stamp | sample | count | unique | nils | minval | maxval |> +===========+======+=======+=======+========+=======+========+======+========+========+ +-----------+------+-------+-------+--------+-------+--------+------+--------+--------+ 0 tuples (3.013ms) !1 column dropped!
Tried it with different schema/table/column names. Both with system and user-generated tables. Always the same error.
Running 11.21.5 here. just call analyze sys.types;
Niels
Thanks. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl