cube-js / cube

📊 Cube — The Semantic Layer for Building Data Applications
https://cube.dev
Other
17.8k stars 1.76k forks source link

Describing the table in psql returns error #8142

Open maver1ck opened 5 months ago

maver1ck commented 5 months ago

Describe the bug I'm trying to describe table in psql command line

To Reproduce Steps to reproduce the behavior:

  1. run psql
  2. run
    test=> \d dw_fct_xxx;
  3. see error
    ERROR:  Unable to parse: ParserError("Expected end of statement, found: OPERATOR")
    QUERY: SELECT c.oid,
    n.nspname,
    c.relname
    FROM pg_catalog.pg_class c
     LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
    WHERE c.relname OPERATOR(pg_catalog.~) '^(dw_fct_xxx)$' COLLATE pg_catalog.default
    AND pg_catalog.pg_table_is_visible(c.oid)
    ORDER BY 2, 3;

Expected behavior I should get description of the table

Version: 0.35.7

igorlukanin commented 2 days ago

Still reproduces on v0.36.4, query pushdown on.