K2InformaticsGmbH / dderl

Web based Data Explorer / Data Jump Station with Erlang In-Memory Support
Apache License 2.0
23 stars 12 forks source link

oracle SQLs crash #620

Closed c-bik closed 5 years ago

c-bik commented 5 years ago

image

[error] [dderl<0.1224.0>@dderloci:exec:59] run_query(SELECT
    *
FROM
    all_tables,undefined,select all_tables.*, all_tables.ROWID from all_tables)
{function_clause,[{dderloci,'-result_exec_stmt/8-lc$^13/1-1-',
[{oci_port,statement,<0.1005.0>,2102479606608,2102479607456}], 
[{file,"dderl/src/dderloci.erl"},{line,361}]},
{dderloci,result_exec_stmt,8,[{file,"dderl/src/dderloci.erl"},{line,361}]},
{dderloci,exec,4,[{file,"dderl/src/dderloci.erl"},{line,54}]},
{oci_adapter,process_query,3,[{file,"dderl/src/oci_adapter.erl"},{line,666}]},
{oci_adapter,process_cmd,6,[{file,"dderl/src/oci_adapter.erl"},{line,233}]},
{dderl_session,spawn_process_call,8,[{file,"dderl/src/dderl_session.erl"},{line,651}]}]}

[error] [dderl<0.1224.0>@oci_adapter:process_query:702] query error {error,function_clause}
 for <<"SELECT\r\n    *\r\nFROM\r\n    all_tables">> whith bind values undefined
stoch commented 5 years ago

@c-bik

that should end up in imem_sec

close(SKey, Pid) -> imem_statement:close(SKey, Pid).

It looks that the transition from single Statement to multiple statements (with only one used) is not properly completed yet. The naming already points to this:

image

stoch commented 5 years ago

Can you please try to fix. I'm working on dderl_fsm only for now.