<emit source="sql"> behaves weird or crashes Roxen with Oracle DB
Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=828
Reported by Peter J. Holzer, WSR hjp@wsr.ac.at
System: Redhat Linux 6.0 Oracle 8.1.6 Roxen 2.1.166 (binary dist)
sometimes mixes up the columns (e.g., with query="select * from user_tables" &_.TABLE_NAME contains the name of the values of the TABLESPACE_NAME column.
For some other queries Roxen crashes with a segmentation fault: For example, in table pages with
Name Null? Type
PAGE_ID NOT NULL NUMBER(10) URL NOT NULL VARCHAR2(500)
and some other columns,
<emit source="sql" host="enkur2" query="select page_id from pages where
page_id < 40" >
&_.PAGE_ID;
</emit>
gives the expected result, while "select page_id, url ..." causes a segfault (No core file, unfortunately, but I should be able to get a backtrace with gdb.