Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET
От | Sami Imseih |
---|---|
Тема | Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET |
Дата | |
Msg-id | CAA5RZ0sv0ChY8iVYbO4uLr_RLWBpEhJm7RyabJpgH3iEeP1VOg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET (Michael Paquier <michael@paquier.xyz>) |
Ответы |
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET
|
Список | pgsql-hackers |
> FWIW, another idea I have on top of my mind is the addition of a > counter in JumbleState that we increment each time we enter > _jumbleNode(), then simply call JUMBLE_FIELD_SINGLE() after the > incrementation. And we can rely on this counter to be unique each > time we jumble a node.. With this approach, the author of the custom function will need to remember to increment the counter, right? Also, I am wondering what is the difference between appending an incrementing counter in JState vs just appending a constant for every node ( NULL or NOT NULL ) ? appending some constant or null-term to the hash: <expression 1> <0><expression 2> <0> <0> vs appending an incremented value: expression_1 <1> expression_2 <2> <3> Both will do the job of adding the required entropy -- Sami
В списке pgsql-hackers по дате отправления: