DB Reader Error
Why does the DB Query Reader node return an error for a basic query like:
select sysdate from dual
ORA-00933: SQL command not properly ended
Knime generated query:
SELECT * FROM (select sysdate from dual) ‘‘tempTable_6172826319873019024’’ WHERE rownum <= 10
It can’t evaluate the query, but it will run it successfully.