Sjoerd Mullender a écrit :
It you try explain select 1; you'll see that what it does is call the MAL function sql.exportValue(). The implementation of this function creates the resultset.
Thank you so much:
yziquel@seldon:~$ merovingian yziquel@seldon:~$ monetdb create test created database in maintenance mode: test yziquel@seldon:~$ monetdb status name state uptime health last crash test locked yziquel@seldon:~$ monetdb start test starting database 'test'... done yziquel@seldon:~$ monetdb status test name state uptime health last crash test locked 20s 100%, 0s - yziquel@seldon:~$ mclient --database=test --user=monetdb --passwd=monetdb -lsql Welcome to mclient, the MonetDB/SQL interactive terminal Database: MonetDB v5.18.1, 'test' Type \q to quit, \? for a list of available commands auto commit mode: on sql>explain select 1; +----------------------------------------------------------------------------------------+ | mal | +========================================================================================+ | function user.s1_1{autoCommit=true}():void; | | sql.exportValue(1,".","single_value","tinyint",8,0,6,1,""); | | end s1_1; | +----------------------------------------------------------------------------------------+ 3 tuples sql>
-- Guillaume Yziquel http://yziquel.homelinux.org/