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

[YSQL][SQLsmith] ERROR: could not open relation with OID 1 #11225

Open
def- opened this issue Jan 26, 2022 · 0 comments
Open

[YSQL][SQLsmith] ERROR: could not open relation with OID 1 #11225

def- opened this issue Jan 26, 2022 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug kind/failing-test Tests and testing infra priority/medium Medium priority issue qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures

Comments

@def-
Copy link
Contributor

def- commented Jan 26, 2022

Jira Link: DB-908

Description

Another SQLsmith issue, not sure if this is an expected failure:

CREATE TABLE mvtest_boxes (id serial primary key, b box);
INSERT INTO mvtest_boxes (b) VALUES
  ('(32,32),(31,31)'),
  ('(2.0000004,2.0000004),(1,1)'),
  ('(1.9999996,1.9999996),(1,1)');
CREATE MATERIALIZED VIEW mvtest_boxmv AS SELECT * FROM mvtest_boxes;

CREATE TABLE mvtest_t (id int NOT NULL PRIMARY KEY, type text NOT NULL, amt numeric NOT NULL);
INSERT INTO mvtest_t VALUES
  (1, 'x', 2),
  (2, 'x', 3),
  (3, 'y', 5),
  (4, 'y', 7),
  (5, 'z', 11);
CREATE VIEW mvtest_tv AS SELECT type, sum(amt) AS totamt FROM mvtest_t GROUP BY type;
CREATE VIEW mvtest_tvv AS SELECT sum(totamt) AS grandtot FROM mvtest_tv;

select  
  pg_catalog.ts_headline(
    cast(cast(null as jsonb) as jsonb),
    cast(cast(null as tsquery) as tsquery)) as c0, 
  ref_0.grandtot as c1, 
  pg_catalog.yb_is_local_table(
    cast(
      pg_catalog.min(
        cast((select pg_catalog.min(datid) from pg_catalog.pg_stat_database)
           as oid)) over (partition by ref_0.grandtot order by ref_0.grandtot) as oid)) as c2, 
  ref_0.grandtot as c3, 
  (select pg_catalog.var_samp(total_time) from pg_catalog.pg_stat_xact_user_functions)
     as c4, 
  ref_0.grandtot as c5, 
  (select major from pg_catalog.pg_yb_migration limit 1 offset 6)
     as c6, 
  pg_catalog.lastval() as c7, 
  ref_0.grandtot as c8, 
  pg_catalog.pg_stat_get_db_blocks_hit(
    cast(case when (pg_catalog.circle(
            cast((select b from public.mvtest_boxmv limit 1 offset 3)
               as box)) &<| pg_catalog.circle_add_pt(
            cast(cast(null as circle) as circle),
            cast(cast(null as point) as point))) 
        and (ref_0.grandtot is NULL) then (select pg_catalog.min(dictnamespace) from pg_catalog.pg_ts_dict)
         else (select pg_catalog.min(dictnamespace) from pg_catalog.pg_ts_dict)
         end
       as oid)) as c9, 
  ref_0.grandtot as c10, 
  ref_0.grandtot as c11, 
  ref_0.grandtot as c12, 
  ref_0.grandtot as c13, 
  ref_0.grandtot as c14, 
  ref_0.grandtot as c15, 
  ref_0.grandtot as c16, 
  ref_0.grandtot as c17, 
  ref_0.grandtot as c18
from 
  public.mvtest_tvv as ref_0
where ref_0.grandtot <= ref_0.grandtot;

Failure:

ERROR:  could not open relation with OID 1
@def- def- added kind/bug This issue is a bug area/ysql Yugabyte SQL (YSQL) labels Jan 26, 2022
@def- def- changed the title [YSQL] ERROR: could not open relation with OID 1 [YSQL][SQLsmith] ERROR: could not open relation with OID 1 Feb 3, 2022
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 8, 2022
@kripasreenivasan kripasreenivasan added the qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures label Sep 13, 2022
@yugabyte-ci yugabyte-ci added the kind/failing-test Tests and testing infra label Oct 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug kind/failing-test Tests and testing infra priority/medium Medium priority issue qa_automation Bugs identified via itest-system, LST, Stress automation or causing automation failures
Projects
None yet
Development

No branches or pull requests

4 participants