Closed as not planned
Description
Recently there was a regression (#14102) for not being able to connect RisingWave with 3rd-party tools, which primarily relies on the extended query mode. Despite the timely release of the quick fix in v1.5.2, we still didn't conduct any testing on it. As a result, it could be easily broken again in the future (#14105 (review)).
As shown in e2e_test/extended_mode, very limited cases are tested with extended mode.
risingwave/e2e_test/extended_mode/type.slt
Lines 21 to 28 in d5a8184
I would suggest adding more tests for extended mode query by focusing on the real cases. Possible approaches:
- Integrate 3rd-party tools in CI and emulate some basic operations. For GUI tools, use GUI automation.
- Manually emulate basic operations with 3rd-party tools, then dump the queries into a
sqllogictestcase.
However, it's worth noting thatsqllogictest-rsdoes not have full support on postgres extended mode: onlyprepareandqueryis covered. Improvements need to be made to supportparse,bind,execute,describeand so on.