Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Query error when objects are in upper case #17

Open
yanmendes opened this issue Apr 14, 2020 · 0 comments
Open

Query error when objects are in upper case #17

yanmendes opened this issue Apr 14, 2020 · 0 comments

Comments

@yanmendes
Copy link

yanmendes commented Apr 14, 2020

I have been facing an issue with BigDAWG's querying module when there are table dimensions written in upper case. Here's the scenario:

Request:

curl -X POST http://localhost:8080/bigdawg/query -d "bdrel(
select * from workflow_exec)"

Object definition:

workflow_exec annotation,wf_contents_id,end_time,type,host_id,lsid,start_time,module_dependencies,wf_id,derived_from,wf_full_lsid,id,USER

Expected output:

annotation wf_contents_id end_time type host_id lsid start_time module_dependencies wf_id derived_from wf_full_lsid id USER
  3efa76b06a6ecf6b51f45e43fc9d5d53 2018-08-12T18:23:11.034Z complete localhost urn:lsid:kepler-project.org/ns/:87467:6:1 2018-08-12T18:23:10.983Z provenance-2.5.0;tagging-2.5.0;workflow-scheduler-gui-1.2.0;kepler-2.5.0;outreach-2.4.0;r-2.5.0;loader-2.4.0;display-redirect-1.1.0;actors-2.5.0;directors-2.1.0;opendap-2.1.0;dataturbine-2.4.0;ecogrid-2.5.0;authentication-gui-2.3.0;gui-2.5.0;module-manager-gui-2.5.0;authentication-2.4.0;repository-2.5.0;job-2.3.0;io-2.1.0;ssh-2.3.0;data-handling-2.2.0;sms-2.2.0;component-library-2.4.0;util-2.3.0;event-state-2.1.0;core-2.5.0;common-2.5.0;module-manager-2.5.0;configuration-manager-2.5.0;kepler-tasks-2.5.1;ptolemy-kepler-2.5.0 1   urn:lsid:kepler-project.org/ns/:7827:6:63 1 yanmendes

BigDAWG's output:

cannot find: wfe.\"USER\"; finder: \"USER\"; srcSchema: {annotation=workflow_exec.annotation:character varying, wf_contents_id=workflow_exec.wf_contents_id:character varying, end_time=workflow_exec.end_time:timestamp, type=workflow_exec.type:character varying, host_id=workflow_exec.host_id:character varying, lsid=workflow_exec.lsid:character varying, start_time=workflow_exec.start_time:timestamp, module_dependencies=workflow_exec.module_dependencies:character varying, wf_id=workflow_exec.wf_id:integer, derived_from=workflow_exec.derived_from:character varying, wf_full_lsid=workflow_exec.wf_full_lsid:character varying, id=workflow_exec.id:integer, USER=workflow_exec.USER:character varying}

If you need a reproducible environment, just follow the installation steps here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant