Skip to content
This repository has been archived by the owner on Jul 2, 2024. It is now read-only.

Tableau schema detection fails #4878

Open
sebastian opened this issue Jan 4, 2021 · 1 comment
Open

Tableau schema detection fails #4878

sebastian opened this issue Jan 4, 2021 · 1 comment

Comments

@sebastian
Copy link
Member

They try to run SELECT * FROM table queries, which we reject because of the uid-column being selected.
Then they run the following query:

SELECT n.nspname,
       c.relname,
       a.attname,
       a.atttypid,
       t.typname,
       a.attnum,
       a.attlen,
       a.atttypmod,
       a.attnotnull,
       c.relhasrules,
       c.relkind,
       c.oid,
       Pg_get_expr(d.adbin, d.adrelid),
       CASE t.typtype
         WHEN 'd' THEN t.typbasetype
         ELSE 0
       END,
       t.typtypmod,
       c.relhasoids
FROM   (((pg_catalog.pg_class c
          inner join pg_catalog.pg_namespace n
                  ON n.oid = c.relnamespace
                     AND c.relname LIKE 'games'
                     AND n.nspname LIKE 'public')
         inner join pg_catalog.pg_attribute a
                 ON ( NOT a.attisdropped )
                    AND a.attnum > 0
                    AND a.attrelid = c.oid)
        inner join pg_catalog.pg_type t
                ON t.oid = a.atttypid)
       left outer join pg_attrdef d
                    ON a.atthasdef
                       AND d.adrelid = a.attrelid
                       AND d.adnum = a.attnum
ORDER  BY n.nspname,
          c.relname,
          attnum 

to which we reply with:

2021-01-04 12:18:53.703 [info] psql server: sending {:syntax_error, "current transaction is aborted, commands ignored until end of transaction block"}

I'm not sure what is going on here to be honest.
I also don't think it necessarily needs to prevent us from making the release.

@sebastian
Copy link
Member Author

This happens when pulling in table players then games in the GamesAndPlayers dataset.
However when removing games and then adding it again, I get it to work quite consistently...

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

No branches or pull requests

1 participant