problems with test/version

[Åsmund Østvold]

hi again

I have some problem getting the test/version test to pass.  When the run  
the test in version_datatype things passes:

[aostvold@localhost version_datatype]$ LD_PRELOAD=./libtvnbr.so ./test_vnbr
version_nbr_in: parse error (NULL ptr or empty string)
version_nbr_in: parse error (NULL ptr or empty string)
version_nbr_in: parse error in  
5015710751050157107051701015805105801851.1:32 (number too long)
version_nbr_in: parse error in 1.13a.1:5 (dots in release type)
version_nbr_in: parse error in 1.2.3.4.5.6:7 (too many dots)
version_nbr_in: parse error in 1.2.3.4.:7 (too many dots)
version_nbr_in: parse error in 1.2-rc3.0:7 (dots in quantifier)
version_nbr_in: parse error in 1.2 rc3v1:7 (duplicate release type string)
version_nbr_in: parse error in 1.2 rc*3:6 (invalid character '*')
version_nbr_in: parse error in 1.2 ?:4984820 (only 7-bit ASCII is  
supported)
version_nbr_in: parse error in 1.2 release_canditate3:18 (release type too  
long)
version_nbr_in: parse error in rc3:0 (must start with number)
VALID: IN: 1, OUT: 1
VALID: IN: 1.3.0-rc2, OUT: 1.3.0rc2
VALID: IN: 2.0a, OUT: 2.0a
VALID: IN: 2.0  , OUT: 2.0
VALID: IN: 2.0  test, OUT: 2.0test
VALID: IN: 12.3.4.5 beta 2, OUT: 12.3.4.5beta2
VALID: IN: 1., OUT: 1
CMP: IN: 1.2, OUT: 1.2
CMP: IN: 1.19, OUT: 1.19
CMP: IN: 1.3.0-rc1, OUT: 1.3.0rc1
CMP: IN: 1.3.0-rc2, OUT: 1.3.0rc2
CMP: IN: 2.0.1a, OUT: 2.0.1a
CMP: IN: 2.0.1b, OUT: 2.0.1b
CMP: IN: 2alpha, OUT: 2alpha
CMP: IN: 2beta, OUT: 2beta
CMP: IN: 1.1.2a, OUT: 1.1.2a
CMP: IN: 1.1.2 a, OUT: 1.1.2a
CMP: IN: 2.01, OUT: 2.1
CMP: IN: 2.1, OUT: 2.1
CMP: IN: 1.2.3.4a2, OUT: 1.2.3.4a2
CMP: IN: 1.2.3.4a1, OUT: 1.2.3.4a1
SUCCESS.


This looks OK to me.


When I try to run `make` in test/version i get:

[aostvold@localhost version]$ make
*** running 2 tests in 'version'
#* ERROR in version: could not setup experiment. See test.log
make: *** [testing] Error 1


The test.log file is attached and the start is like this:

#* ERROR: creating SQL datatype 'version_nbr' failed.
ERROR:  btree procedures must return integer


CREATE FUNCTION version_nbr_in(opaque)
         RETURNS version_nbr AS 'libvnbr.so'
         LANGUAGE 'c';

CREATE FUNCTION version_nbr_out(opaque)
         RETURNS opaque AS 'libvnbr.so'
         LANGUAGE 'c';

CREATE TYPE version_nbr (
         internallength=24,
         input=version_nbr_in,
         output=version_nbr_out
);

CREATE FUNCTION version_nbr_eq(version_nbr, version_nbr)
         RETURNS bool AS 'libvnbr.so'
         LANGUAGE 'c';

[...]


And the end of the file is like this:

[...]
CREATE OPERATOR = (
         leftarg = version_nbr,
         rightarg = version_nbr,
         procedure = version_nbr_eq,
         restrict = eqsel,
         join = eqjoinsel,
         commutator = =,
         negator = <>,
         sort1 = <,
         sort2 = <
);

CREATE OPERATOR CLASS version_nbr_ops
     DEFAULT FOR TYPE version_nbr USING btree AS
         OPERATOR        1       < ,
         OPERATOR        2       <= ,
         OPERATOR        3       = ,
         OPERATOR        4       >= ,
         OPERATOR        5       > ,
         FUNCTION        1       version_nbr_lt_int(version_nbr,  
version_nbr);


#* ERROR: could not add value 'v_prot' to database!
     'ERROR:  type "version_nbr" does not exist\n\nALTER TABLE rundata_once  
ADD COLUMN v_prot version_nbr'
#* Setting up the experiment failed. No database created.


My OS is FC4 and I believe I have installed libvnbr.so files on the  
correct place.  I even installed it bothe in /usr/lib/ and /usr/lib/pgsql:


[aostvold@localhost version]$ locate nbr|grep lib
/home/aostvold/perfbase/perfbase-0.9.0/pgsql/version_datatype/libvnbr.so.1.0
/home/aostvold/perfbase/perfbase-0.9.0/pgsql/version_datatype/libtvnbr.so
/usr/lib/pgsql/libvnbr.so.1.0
/usr/lib/pgsql/libvnbr.so.1
/usr/lib/pgsql/libvnbr.so
/usr/lib/libvnbr.so.1.0
/usr/lib/libvnbr.so.1
/usr/lib/libvnbr.so


I believe this is the corrcet place but I am not sure.  ld.so should be  
albe to find the filse to because:

[aostvold@localhost version_datatype]$ /sbin/ldconfig -p |grep libvnbr
         libvnbr.so.1 (libc6) => /usr/lib/libvnbr.so.1


I have for sure done something stupid but I am not able to find out what.  
If somebody see what I have done wrong do tell! :)


Best regards

Åsmund

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...