ydb icon indicating copy to clipboard operation
ydb copied to clipboard

[pg] ignore from pg_settings in set_config queries

Open qrort opened this issue 9 months ago • 1 comments

Rewrite queries such as SELECT set_config(\'bytea_output\',\'hex\',false) FROM pg_settings WHERE name = \'bytea_output\'; into SELECT set_config(\'bytea_output\',\'hex\',false) if FROM clause contains pg_settings table.

qrort avatar May 03 '24 15:05 qrort

In the future we could force a query to execute as single stage. In such cases, we can execute SELECT set_config(\'bytea_output\',\'hex\',false) FROM pg_settings WHERE name = \'bytea_output\';

qrort avatar May 06 '24 14:05 qrort