Re: BUG #16051: PQgetvalue(res,0,0) is null, PQgetlength(res,0,0) is 10

Thanks for taking a look at my code. The difference is because this table will be created once by a setup script that connects without the search_path option selecting a scheme  in connect, whereas the program that will run on this table connects with a search_path option. Changing the command to

res = PQexecParams(conn,
            "SELECT * FROM \"Schema1\".testdata;",
            0,
            NULL,
            NULL,
            NULL,
            NULL,
            1
        );

makes no difference, the test still fails.

This is the main function that initalises the connection in this test file:

int main(int argc, char**argv){
    doctest::Context context;
        conn = PQconnectdb("host=127.0.0.1 port=5432 user=sab24 dbname=Testing options='-c search_path=\"Schema1\"'");
        if (PQstatus(conn) != CONNECTION_OK){
        fprintf(stderr, "Connection to database failed: %s",
            PQerrorMessage(conn));
        exit(1);
    }
    int res = context.run();
    PQfinish(conn);
    return res;
}

Debugging also shows the output of PQgetvalue not available:

Process 6345 stopped
* thread #1, queue = 'com.apple.main-thread', stop reason = breakpoint 1.1
    frame #0: 0x0000000100015542 dbPostgres`_DOCTEST_ANON_FUNC_10() at dbPostgres.cpp:242:23
   239            PQclear(res);
   240        }
   241        else{
-> 242            std::cout << "value is: " << PQgetvalue(res, 0,0) << " length is: " << PQgetlength(res,0,0) << std::endl;
   243            REQUIRE(strcmp(PQgetvalue(res, 0,0), "1234") == 0);
   244        }
   245    }
(lldb) p (char*)PQgetvalue(res,0,0)
(char *) $0 = 0x000000010080af10 <no value available>