Re: BUG #15904: ERROR: argument of LIMIT must not contain variables

Поиск
Список
Период
Сортировка
От Lakradi Marwan
Тема Re: BUG #15904: ERROR: argument of LIMIT must not contain variables
Дата
Msg-id CAF5OE-y3b0YEQW0tUiSmySCvwMdw0_7e3ayzwHr8CMsCk=Nwrw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15904: ERROR: argument of LIMIT must not contain variables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: BUG #15904: ERROR: argument of LIMIT must not contain variables
Список pgsql-bugs
Дерево обсуждения
Thank you for your quick feedback,

In my opinion, your query should return :
   Id, Text
1| 1, 'one'

and be interpreted as due to variable type :
LIMIT CASE WHEN 1 = 1 THEN 1 ELSE 2 END;

Am I wrong in the way I see the situation ?

I think that in the case of a variable, the data should be retrieved until the condition is reached. Like LIMIT_TILL {condition}

Marwan L.

Le jeu. 11 juil. 2019 à 17:27, David G. Johnston <david.g.johnston@gmail.com> a écrit :
On Thu, Jul 11, 2019 at 8:06 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15904
Logged by:          Lakradi Marwan
Email address:      lakradimarwan@gmail.com
PostgreSQL version: 11.4
Operating system:   Mac OS X - High Sierra
Description:       
 
I don't see the point, what is the main difference between
summary.amount_summed which is a float, and directly pass 100.0 ?

A limit applies to the query as a whole and cannot depend on individual records.  If you think that is wrong explain what the following query is supposed to return and why.

SELECT *
FROM (VALUES (1, 'one'), (2, 'two')) vals (i, t)
LIMIT CASE WHEN vals.i = 1 THEN 1 ELSE 2 END;

David J.

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