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

FITS Data Vaults does not work when using user/pw and other than sys schema name #6253

monetdb-team opened this issue Nov 30, 2020 · 0 comments


Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

Date: 2017-03-29 13:55:52 +0200
From: @bartscheers
To: SQL devs <>
Version: 11.25.9 (Dec2016-SP2)
CC: @kutsurak

Last updated: 2017-03-31 13:28:47 +0200

Comment 25185

Date: 2017-03-29 13:55:52 +0200
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:52.0) Gecko/20100101 Firefox/52.0
Build Identifier:

CALL fitsattach('/to/fits/file') or
CALL sys.fitsattach('/to/fits/file') results in errors.

Reproducible: Always

Steps to Reproduce:

  1. get the fits file
  2. run the script (3 cases: a) default: works; b) user/pw: works; c) user/pw/schema: not working

Actual Results:

call without sys prefix
SELECT: no such unary operator 'fitsattach(char)'
SELECT: no such table 'fits_tables'

call with sys prefix
INSERT INTO: no such table 'fits_columns'
INSERT INTO: no such table 'fits_columns'
SELECT: no such table 'fits_tables'

Expected Results:

Same results as for the other two cases

Comment 25186

Date: 2017-03-29 14:00:59 +0200
From: @bartscheers

Created attachment 547

Cannot attach the 2MB fits file. Hopefully you have one yourself.

Attached file: (application/x-shellscript, 1214 bytes)
Description: script

Comment 25187

Date: 2017-03-29 14:01:31 +0200
From: @bartscheers

Created attachment 548
sql to set user/pw

Attached file: prep_user.sql (application/sql, 103 bytes)
Description: sql to set user/pw

Comment 25188

Date: 2017-03-29 14:01:56 +0200
From: @bartscheers

Created attachment 549
script to set user/pw/schema

Attached file: prep_schema.sql (application/sql, 195 bytes)
Description: script to set user/pw/schema

Comment 25190

Date: 2017-03-30 13:59:49 +0200
From: @kutsurak

Fixed in changeset bb76f5c6a6fc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant