-
Notifications
You must be signed in to change notification settings - Fork 1.2k
Open
Labels
area/ysqlYugabyte SQL (YSQL)Yugabyte SQL (YSQL)kind/bugThis issue is a bugThis issue is a bugkind/failing-testTests and testing infraTests and testing infrapriority/mediumMedium priority issueMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failuresBugs identified via itest-system, LST, Stress automation or causing automation failures
Description
Jira Link: DB-914
Description
SQLsmith found this in Debug build, reproducible:
CREATE TABLE airports(ident TEXT,
type TEXT,
name TEXT,
elevation_ft INT,
continent TEXT,
iso_country TEXT,
iso_region TEXT,
municipality TEXT,
gps_code TEXT,
iata_code TEXT,
local_code TEXT,
coordinates TEXT,
PRIMARY KEY (iso_region HASH, ident ASC));
CREATE INDEX airports_idx1 ON airports(iso_region hash, name DESC);
CREATE INDEX airports_idx2 ON airports(iso_region ASC, gps_code ASC);
CREATE INDEX airports_idx3 ON airports((iso_region, type) HASH, coordinates, ident, name)
INCLUDE (gps_code);
COPY airports FROM '/Users/deen/code/yugabyte-db/src/postgres/src/test/regress/data/airport-codes.csv' CSV HEADER;
delete from public.airports
where
EXISTS (
select
ref_0.coordinates as c0,
public.airports.elevation_ft as c1,
ref_0.ident as c2,
public.airports.name as c3,
ref_0.name as c4,
public.airports.name as c5
from
public.airports as ref_0
where true
limit 127)
returning
(select name from public.airports limit 1 offset 3)
as c0,
case when public.airports.coordinates is not NULL then public.airports.type else public.airports.type end
as c1,
public.airports.name as c2,
35 as c3,
pg_catalog.to_tsquery(
cast(public.airports.ident as text)) as c4,
public.airports.name as c5,
public.airports.municipality as c6,
public.airports.iso_country as c7,
public.airports.ident as c8,
public.airports.elevation_ft as c9,
public.airports.local_code as c10,
public.airports.type as c11,
42 as c12,
case when public.airports.coordinates is not NULL then public.airports.continent else public.airports.continent end;
Crashes postgres, failure in postgres log:
TRAP: FailedAssertion("!(tuple != ((void*)0))", File: "../../../../../../src/postgres/src/backend/executor/execTuples.c", Line: 355)
Metadata
Metadata
Assignees
Labels
area/ysqlYugabyte SQL (YSQL)Yugabyte SQL (YSQL)kind/bugThis issue is a bugThis issue is a bugkind/failing-testTests and testing infraTests and testing infrapriority/mediumMedium priority issueMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failuresBugs identified via itest-system, LST, Stress automation or causing automation failures