-
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 bugpriority/mediumMedium priority issueMedium priority issue
Description
Jira Link: DB-4794
This query is generated by SQLsmith. May be a duplicate of #9645 but it's not clear to me if that's the case. The query contains a TABLESAMPLE clause that has not been supported by Yugabyte DB yet (#4288) but hits the illegal state error without it, too.
select
cast(nullif(
pg_catalog.bit_and(
cast(cast(null as int2) as int2)) over (partition by ref_0.hasindexes order by ref_0.tableowner,ref_0.schemaname),
case when EXISTS (
select
ref_0.tablename as c0,
sample_0.fdwacl as c1,
sample_0.fdwacl as c2
from
pg_catalog.pg_foreign_data_wrapper as sample_0 tablesample system (9.1)
where cast(null as tinterval) #< cast(null as reltime)
limit 85) then cast(coalesce(pg_catalog.int2mod(
cast(cast(null as int2) as int2),
cast((select indnatts from pg_catalog.pg_index limit 1 offset 2)
as int2)),
pg_catalog.min(
cast(cast(null as int2) as int2)) over (partition by ref_0.hastriggers,ref_0.tablename order by ref_0.tablespace)) as int2) else cast(coalesce(pg_catalog.int2mod(
cast(cast(null as int2) as int2),
cast((select indnatts from pg_catalog.pg_index limit 1 offset 2)
as int2)),
pg_catalog.min(
cast(cast(null as int2) as int2)) over (partition by ref_0.hastriggers,ref_0.tablename order by ref_0.tablespace)) as int2) end
) as int2) as c0,
ref_0.rowsecurity as c1,
ref_0.schemaname as c2,
cast(nullif(ref_0.tableowner,
pg_catalog.current_user()) as name) as c3
from
pg_catalog.pg_tables as ref_0
where pg_catalog.pg_my_temp_schema() <> pg_catalog.oidlarger(
cast(pg_catalog.lo_create(
cast(pg_catalog.pg_my_temp_schema() as oid)) as oid),
cast(pg_catalog.pg_my_temp_schema() as oid))
limit 128;
ERROR: Illegal state: Transaction for catalog table write operation 'pg_largeobject_metadata' not found
Metadata
Metadata
Assignees
Labels
area/ysqlYugabyte SQL (YSQL)Yugabyte SQL (YSQL)kind/bugThis issue is a bugThis issue is a bugpriority/mediumMedium priority issueMedium priority issue
Type
Projects
Status
No status