tablesample clause doesnt support to be applied to subquery.

Поиск

Список

Период

Сортировка

От	Wind
Тема	tablesample clause doesnt support to be applied to subquery.
Дата	8 августа 2022 г. 10:52:17
Msg-id	6c33bee6.2d89.1827c70b59a.Coremail.guolipengyeah@126.com обсуждение исходный текст
Ответы	Re: tablesample clause doesnt support to be applied to subquery. (rob stone <floriparob@tpg.com.au>)
Список	pgsql-general

hi~

I test "tablesample" feature on pg9.5 and found that tablesample doesnt support to be applied to subquery.

for example this sql doesnt work on pg9.5:

```

create table t1(

c1 int,

c2 int

);

select c2 from (select * from t1) as t2 tablesample system (50);

```

while i read sql2003 standard about tablesample and think it should allow this usage according to standard.

is it a deviation to sql standard?

В списке pgsql-general по дате отправления:

От: Aleš Zelený
Дата: 07 августа 2022 г., 22:47:09
Сообщение: Re: PostgreSQL 14.4 ERROR: out of memory issues

От: rob stone
Дата: 08 августа 2022 г., 11:05:51
Сообщение: Re: tablesample clause doesnt support to be applied to subquery.