ConText result table conid -- length of number

From: Gerhard Moeller <Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.de>
Date: 1998/01/09
Message-ID: <695du5$sv3@news.Informatik.Uni-Oldenburg.DE>#1/1

Hi again,

For a web based application I have to unique create query_ids that contain a time stamp. This is rather easy, as you could take the julian date, the seconds since midnight and a sequence value.

However, the resulting number is rather long, as you can see below.

begin
CTX_QUERY.CONTAINS(

POLICY_NAME => 'soifs_keys_de_no_soundex',
TEXT_QUERY  => 'test',
RESTAB      => 'ctx_results',
SHARELEVEL  => 1,
QUERY_ID    => 24508234044010055 );

end;
/

The problem now is that ctx_query.contains obviously does not handle long integers. The interface states that query_id is type NUMBER, which should allow 38 digits. The ctx.log tells me that indeed the number is accepted:

15:08:36 01/09/98 Cmd 3022: contains, user=DEVTEST, polid=1789, query=test, restab=DEVTEST.CTX_RESULTS, shr=1, conid=24508234044010055, curid=0, floorid=0, ceilid=0

Howevr, the conid in ctx_results is not set right:

select * from ctx_results;
Hit Enter To Continue...

TEXTK SCORE CONID
----- ---------- ----------

1             10 2147483647
2             10 2147483647
3             10 2147483647
4             10 2147483647
5             10 2147483647

As the body of the ctx_query package is wrapped, I cannot see what is done. So, can someone explain to me what is happening, why

24508234044010055 ---> 2147483647

And, most important, what I could do to work around my problem...

Thank you very much, Gerhard.

Oh, I forgot. I use ConText 2.0.4 with RDBMS 7.3.3 on a DEC alpha with OSF.

-- 
Dipl. Inform. Gerhard Möller -- Gerhard.Moeller_at_OFFIS.Uni-Oldenburg.DE
                                      ICQ PIN: 2804938
OFFIS                  | | | | | |    Tel.:    0441/9722-122
Escherweg 2            | | | | | |    Sekr.:   0441/9722-113 oder -101
D-26121 Oldenburg      |O|F|F|I|S|    Fax:     0441/9722-102

Received on Fri Jan 09 1998 - 00:00:00 CST