Re: [HACKERS] Testing plperl<->plperlu interaction

[Andrew Dunstan]

Tim Bunce wrote:
I was investigating a bug in an 8.4.1 production system and distilled a
test case down to this:

    CREATE OR REPLACE FUNCTION bar() RETURNS integer AS $$
        #die 'BANG!'; # causes server process to exit(2)
        # alternative - causes server process to exit(255)
        spi_exec_query("invalid sql statement");
    $$ language plperl; -- plperl or plperlu
   
    CREATE OR REPLACE FUNCTION foo() RETURNS integer AS $$
        spi_exec_query("SELECT * FROM bar()");
        return 1;
    $$ LANGUAGE plperlu; -- must be opposite to language of bar
   
    SELECT * FROM bar(); -- throws exception normally
    SELECT * FROM foo(); -- causes the server to exit abnormaly

before then rereading the 8.4.2 release notes and seeing that the bug
was already fixed. D'oh!

I see the test suite doesn't have any plperlu tests at all.
Is there any reason for that?


  

Just that we haven't bothered. But we can't run tests for both in the 
same session because that doesn't work on all platforms. I actually 
played a bit with it the other day. Setting up some plperlu tests would 
be very simple.

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers