Hi,
i hit a strange problem when using alias for an expression in group
by
i run into this with a complex view containing multiple UNION ALL
queries but after a while everything boiled down to a fairly simple
test case that will always produce the error
Welcome to mclient, the MonetDB/SQL interactive
terminal (Feb2013-SP1)
Database: MonetDB v11.15.3 (Feb2013-SP1),
'mapi:monetdb://lux-analytics:50000/zkdev1'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>CREATE VIEW mmtest_v AS SELECT date'2012-01-01' as
period, 1 as quantity;
operation successful (213.074ms)
sql>SELECT extract(month from period) as m, count(1) as cnt
FROM mmtest_v GROUP BY m;
Connection terminated
I am on Ubuntu 12.04.2 LTS
As the alias in GROUP BY works in other cases i expect this is a bug
- pls confirm and i will be happy to file it.
BTW it looks like MonetDB has generally issues with selects from
more complex views - i.e. views based on another view(s).
In such cases the results do not match expectations or there is even
an error. I can reproduce the problem but i only on quite large set
of data (typically 20+ mil. records) and after some data
manipulation got involved, so i cannot give a simple test case as
above.
Any idea how to pass such problem (when large data-set is involved)
to the development team?
Thanks in advance
milan