From 5daef2dd3f41064882dce19091ea0263ba21c5bf Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Sun, 11 Aug 2019 18:58:51 +0900 Subject: [PATCH] Fix extra test failure of extended-query-test/disable-load-balance-default. It expected the first BIND/EXECUTE was sent to load balance node. This is not correct since previous parse message was sent to primary node because of parse_before_bind treatment. Fix is, just adjust the test script. Also fix comment in tests/disable-load-balance-default.data. --- .../extra_scripts/disable-load-balance-default.data | 2 +- .../tests/disable-load-balance-default.data | 5 +++-- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/src/test/extended-query-test/extra_scripts/disable-load-balance-default.data b/src/test/extended-query-test/extra_scripts/disable-load-balance-default.data index 14b2dd3c0..016dc2973 100755 --- a/src/test/extended-query-test/extra_scripts/disable-load-balance-default.data +++ b/src/test/extended-query-test/extra_scripts/disable-load-balance-default.data @@ -2,7 +2,7 @@ # expected results: Parse: 1 Parse: 0 Execute: 0 Parse: 0 Execute: 0 # Parse: 1 Execute: 1 Parse: 1 Execute: 1 Parse: 1 Execute: 1 -set 1 0 0 0 0 1 1 1 1 1 +set 1 0 0 0 0 1 1 0 1 1 grep "SELECT" $PGPOOLLOG | grep -v version |awk '{print $9}' | while read node do diff --git a/src/test/extended-query-test/tests/disable-load-balance-default.data b/src/test/extended-query-test/tests/disable-load-balance-default.data index 74344f9eb..ff347628c 100644 --- a/src/test/extended-query-test/tests/disable-load-balance-default.data +++ b/src/test/extended-query-test/tests/disable-load-balance-default.data @@ -55,8 +55,9 @@ 'B' "" "" 0 0 0 'E' "" 0 -# Issue Bind/Execute SELECT. This should be sent to node 1 because -# disable_load_balance_on_write = 'transaction'. +# Issue Bind/Execute SELECT. This should be sent to node 0 despite +# disable_load_balance_on_write = 'transaction' because previous prase +# messge was sent to primary node which was done by parse_before_bind. 'B' "" "S1" 0 0 0 'E' "" 0 -- 2.39.5