MoetDB的SQL手册——Debug

DEBUG SQL STMT

        

The SQL statements are translated into MAL programs, which are optimized and stored away in anuser module.   The generated code can be inspected with the MAL debugger.

The example below illustrates the start of such a session:

 

SQL语句被翻译成为Mal程序，优化存储为用户模块。代码可以用MAL_debugger跟踪，以下是一个调试的例子。

 

>debug select count(*) from tables;#    mdb.start()mdb>next#    user.s1_0()mdb>next#    _2:bat[:oid,:int]  := sql.bind(_3="sys", _4="ptables", _5="id", _6=0)mdb>next#    _8:bat[:oid,:int]  := sql.bind(_3="sys", _4="ptables", _5="id", _9=1)mdb> ...