Example showing weird behavior of selects on associated_data table... sql> select * from associated_data; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 90a78030dfc3bce9891981d3da00a66c 0 type org.kepler.reporting.roml.ReportLayout 0 21f5fa5b8d1134ad420deaa4d72d1162 1 type org.kepler.reporting.rio.ReportInstance 0 afd9cb2707c118957ab28b17fb8f7377 2 type java.io.File 0 90a78030dfc3bce9891981d3da00a66c 3 type org.kepler.reporting.roml.ReportLayout 1 a6768a0d6cac98f4f990fd7e148f96c4 4 type org.kepler.reporting.rio.ReportInstance 1 8ec4a8979433724a25484766acec4336 5 type java.io.File 1 60c172334743249addf0afcdb2e20895 6 type org.kepler.reporting.roml.ReportLayout 2 73d1d6609851d83979b54e7b94751938 7 type org.kepler.reporting.rio.ReportInstance 2 5ff6e45ddcbb8c029efdd39b84b8d1fd 8 type java.io.File 2 9 rows sql> select * from associated_data where id=8; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- ------------ ---------- 5ff6e45ddcbb8c029efdd39b84b8d1fd 8 type java.io.File 2 sql> select * from associated_data where wf_exec_id = 2; DATA_ID ID NAME VAL WF_EXEC_ID ------- -- ---- --- ---------- 0 rows sql> select * from associated_data where wf_exec_id = 0; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 21f5fa5b8d1134ad420deaa4d72d1162 1 type org.kepler.reporting.rio.ReportInstance 0 sql> elect * from associated_data where wf_exec_id = 1; SQL Error at 'stdin' line 12: "elect * from associated_data where wf_exec_id = 1" Unexpected token: ELECT in statement [elect] sql> select * from associated_data where wf_exec_id = 1; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 90a78030dfc3bce9891981d3da00a66c 3 type org.kepler.reporting.roml.ReportLayout 1 a6768a0d6cac98f4f990fd7e148f96c4 4 type org.kepler.reporting.rio.ReportInstance 1 2 rows sql> select * from associated_data where wf_exec_id = 2; DATA_ID ID NAME VAL WF_EXEC_ID ------- -- ---- --- ---------- 0 rows sql> select wf_exec_id from associated_data; 0 0 0 1 1 1 2 2 2 9 rows sql> \dt ACTOR ACTOR_FIRE ASSOCIATED_DATA DATA DIRECTOR ENTITY PARAMETER PORT PORT_EVENT WORKFLOW WORKFLOW_CHANGE WORKFLOW_EXEC 12 rows sql> select * from workflow; ID NAME LSID -- ------------- ---------------------------------------------- 0 testWorkflow urn:lsid:gamma.msi.ucsb.edu/OpenAuth/:260:1936 1 testWorkflow2 urn:lsid:gamma.msi.ucsb.edu/OpenAuth/:260:2015 2 rows 6 rows sql> select * from associated_data where wf_exec_id LIKE '%0%'; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 90a78030dfc3bce9891981d3da00a66c 0 type org.kepler.reporting.roml.ReportLayout 0 21f5fa5b8d1134ad420deaa4d72d1162 1 type org.kepler.reporting.rio.ReportInstance 0 afd9cb2707c118957ab28b17fb8f7377 2 type java.io.File 0 3 rows sql> select * from associated_data where wf_exec_id LIKE '%1%'; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 90a78030dfc3bce9891981d3da00a66c 3 type org.kepler.reporting.roml.ReportLayout 1 a6768a0d6cac98f4f990fd7e148f96c4 4 type org.kepler.reporting.rio.ReportInstance 1 8ec4a8979433724a25484766acec4336 5 type java.io.File 1 3 rows sql> select * from associated_data where wf_exec_id LIKE '%2%'; DATA_ID ID NAME VAL WF_EXEC_ID -------------------------------- -- ---- --------------------------------------- ---------- 60c172334743249addf0afcdb2e20895 6 type org.kepler.reporting.roml.ReportLayout 2 73d1d6609851d83979b54e7b94751938 7 type org.kepler.reporting.rio.ReportInstance 2 5ff6e45ddcbb8c029efdd39b84b8d1fd 8 type java.io.File 2