Skip to content

[YSQL][SQLsmith] TRAP: FailedAssertion("!(tuple != ((void*)0))", File: "../../../../../../src/postgres/src/backend/executor/execTuples.c", Line: 355) #11300

@def-

Description

@def-

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)kind/bugThis issue is a bugkind/failing-testTests and testing infrapriority/mediumMedium priority issueqa_automationBugs identified via itest-system, LST, Stress automation or causing automation failures

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions