Hi,
I am now getting the following errror when trying to create an inverted index. I'm 90% sure this related my upgrading to the latest version of Texis.
Has something change with inverted index requirements?
SQL 1>create inverted index Catalog_PRAllX on Catalog(PR1\PR2\PR3\PR4\PR5\PR6\PR7);
create inverted index Catalog_PRAllX on Catalog(PR1\PR2\PR3\PR4\PR5\PR6\PR7);
015 Field must be integral and 64 bits or less in the function openvind
000 SQL failed
I can create the index as non-inverted the data type for these fields is INT.
TABLE DEF:
SQL 1>SELECT * FROM SYSCOLUMNS WHERE TBNAME='Catalog';
SELECT * FROM SYSCOLUMNS WHERE TBNAME='Catalog';
NAME TBNAME TYPE SIZE ORDINAL_POSITION IDX NULLABLE SQLTYPE PRECIS LENGTH SCALE RADIX REMARK
------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
id Catalog counter 1 1 1 -2 20 8 0 10
CatalogID Catalog int 1 2 1 4 10 4 0 10
ItemNumberID Catalog int 1 3 1 4 10 4 0 10
ProductTypeSort Catalog int 1 9 1 4 10 4 0 10
CategorySort Catalog int 1 13 1 4 10 4 0 10
IsTrophy Catalog int 1 15 1 4 10 4 0 10
MinPrice Catalog double 1 16 1 8 15 8 0 10
MaxPrice Catalog double 1 17 1 8 15 8 0 10
DisplayArtistID Catalog int 1 21 1 4 10 4 0 10
DateNumber Catalog int 1 23 1 4 10 4 0 10
EventID Catalog int 1 24 1 4 10 4 0 10
Year Catalog int 1 28 1 4 10 4 0 10
Month Catalog int 1 29 1 4 10 4 0 10
Day Catalog int 1 30 1 4 10 4 0 10
DateEnteredNumber Catalog int 1 31 1 4 10 4 0 10
PR1 Catalog int 1 45 1 4 10 4 0 10
PR2 Catalog int 1 46 1 4 10 4 0 10
PR3 Catalog int 1 47 1 4 10 4 0 10
PR4 Catalog int 1 48 1 4 10 4 0 10
PR5 Catalog int 1 49 1 4 10 4 0 10
PR6 Catalog int 1 50 1 4 10 4 0 10
PR7 Catalog int 1 51 1 4 10 4 0 10
ItemNumber Catalog varchar 80 4 0 -1 80 80 0 10
ItemNumberBase Catalog varchar 80 5 0 -1 80 80 0 10
ProductTypeID Catalog varchar 80 6 0 -1 80 80 0 10
ProductTypeName Catalog varchar 80 7 0 -1 80 80 0 10
I am now getting the following errror when trying to create an inverted index. I'm 90% sure this related my upgrading to the latest version of Texis.
Has something change with inverted index requirements?
SQL 1>create inverted index Catalog_PRAllX on Catalog(PR1\PR2\PR3\PR4\PR5\PR6\PR7);
create inverted index Catalog_PRAllX on Catalog(PR1\PR2\PR3\PR4\PR5\PR6\PR7);
015 Field must be integral and 64 bits or less in the function openvind
000 SQL failed
I can create the index as non-inverted the data type for these fields is INT.
TABLE DEF:
SQL 1>SELECT * FROM SYSCOLUMNS WHERE TBNAME='Catalog';
SELECT * FROM SYSCOLUMNS WHERE TBNAME='Catalog';
NAME TBNAME TYPE SIZE ORDINAL_POSITION IDX NULLABLE SQLTYPE PRECIS LENGTH SCALE RADIX REMARK
------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
id Catalog counter 1 1 1 -2 20 8 0 10
CatalogID Catalog int 1 2 1 4 10 4 0 10
ItemNumberID Catalog int 1 3 1 4 10 4 0 10
ProductTypeSort Catalog int 1 9 1 4 10 4 0 10
CategorySort Catalog int 1 13 1 4 10 4 0 10
IsTrophy Catalog int 1 15 1 4 10 4 0 10
MinPrice Catalog double 1 16 1 8 15 8 0 10
MaxPrice Catalog double 1 17 1 8 15 8 0 10
DisplayArtistID Catalog int 1 21 1 4 10 4 0 10
DateNumber Catalog int 1 23 1 4 10 4 0 10
EventID Catalog int 1 24 1 4 10 4 0 10
Year Catalog int 1 28 1 4 10 4 0 10
Month Catalog int 1 29 1 4 10 4 0 10
Day Catalog int 1 30 1 4 10 4 0 10
DateEnteredNumber Catalog int 1 31 1 4 10 4 0 10
PR1 Catalog int 1 45 1 4 10 4 0 10
PR2 Catalog int 1 46 1 4 10 4 0 10
PR3 Catalog int 1 47 1 4 10 4 0 10
PR4 Catalog int 1 48 1 4 10 4 0 10
PR5 Catalog int 1 49 1 4 10 4 0 10
PR6 Catalog int 1 50 1 4 10 4 0 10
PR7 Catalog int 1 51 1 4 10 4 0 10
ItemNumber Catalog varchar 80 4 0 -1 80 80 0 10
ItemNumberBase Catalog varchar 80 5 0 -1 80 80 0 10
ProductTypeID Catalog varchar 80 6 0 -1 80 80 0 10
ProductTypeName Catalog varchar 80 7 0 -1 80 80 0 10