galaxyproject / galaxyproject/gxadmin
query training-members* broken
- Dominant language
- Shell
- Stars
- 24
- Forks
- 30
- Avg merge
- 3d 10h
- Merged PRs (30d)
- 5
Description
Both `gxadmin query training-members` and `training-members-remove --yesdoit` do not work for me:
~~~
root@sn06:~$ gxadmin query training-members-remove pxe-test mira-miracoli --yesdoit
ERROR: syntax error at or near ")"
LINE 1: COPY () to STDOUT with CSV DELIMITER E'\t'
^
delete from user_group_association where id =
~~~
~~~
root@sn06:/tmp$ gxadmin query training-members pxe-test
ERROR: syntax error at or near "as"
LINE 1: ...ALESCE(galaxy_user.username::text, '__UNKNOWN__') as usernam...
~~~
while this works:
~~~
root@sn06:~$ gxadmin query training-members-remove pxe-test mira-miracoli
id | username | name
-------+---------------+-------------------
36476 | mira-miracoli | training-pxe-test
~~~
VERSION:
~~~
root@sn06:~$ gxadmin version
22
~~~
Contributor guide
Research direction
Start with the gxadmin query training-members and training-members-remove entry points and reproduce both failures on version 22. Compare their generated SQL with the working training-members-remove output; done means both reported commands execute without syntax errors and the removal command retains its demonstrated behavior.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- shell, sql
- Domain
- cli, database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100