I am confused about why I get different results when searching a table that has been indexed via a vortex script vs. when the same table has been indexed from the command line using tsql.exe. Here is the Vortex script:
<script language=vortex>
<a name=main>
<sql db=D:\myDB "set delexp=0;"></sql>
<sql db=D:\myDB "set addexp='\alnum{1,99}';"></sql>
<sql db=D:\myDB "set keepnoise=1;"></sql>
<sql db=D:\myDB "create metamorph inverted index testdata_mi on testdata (PATN_TTL\ABST_PAx\CLMS_PAx)"></sql>
</a>
</script>
Here is the tsql.exe command line:
tsql.exe -d D:\myDB -i D:\indexScript.sql
The content of D:\indexScript.sql is as follows:
set delexp=0;
set addexp='\alnum{1,99}';
set keepnoise=1;
create metamorph inverted index testdata_mi on testdata (PATN_TTL\ABST_PAx\CLMS_PAx);
As you can see, the same sequence of statements is used to create the index in both cases. However, when I index the table using the vortex script, I find that one of our metamorph queries against the table does NOT return a hit, whereas the same metamorph query DOES return a hit when the table is indexed using the tsql.exe command. I understand that there are subtle differences between vortex and tsql, but this one has me stumped. The only thing I can think of that might be going on here is in how vortex and tsql differ when it comes to handling multiple statements. But if that is so, I don't see how to get around it. We want to create the index via our vortex script, but that is not working. As I said, we are finding that there are queries that do NOT return a hit in this case, when we know that they should.
I have not included the specific query nor the data in the table testdata, since (it seems to me) that the problem is somewhere in the way that I am indexing. However, I would be happy to include both of those if it would be helpful. The query is about 4800 characters in length, and rather complex, involving many references to terms found in a large equivalence file.
FYI, our Texis version is:
Commercial Version 6.01.1342629243 20120718 (i686-intel-winnt-64-32)
Thanks for your help.
<script language=vortex>
<a name=main>
<sql db=D:\myDB "set delexp=0;"></sql>
<sql db=D:\myDB "set addexp='\alnum{1,99}';"></sql>
<sql db=D:\myDB "set keepnoise=1;"></sql>
<sql db=D:\myDB "create metamorph inverted index testdata_mi on testdata (PATN_TTL\ABST_PAx\CLMS_PAx)"></sql>
</a>
</script>
Here is the tsql.exe command line:
tsql.exe -d D:\myDB -i D:\indexScript.sql
The content of D:\indexScript.sql is as follows:
set delexp=0;
set addexp='\alnum{1,99}';
set keepnoise=1;
create metamorph inverted index testdata_mi on testdata (PATN_TTL\ABST_PAx\CLMS_PAx);
As you can see, the same sequence of statements is used to create the index in both cases. However, when I index the table using the vortex script, I find that one of our metamorph queries against the table does NOT return a hit, whereas the same metamorph query DOES return a hit when the table is indexed using the tsql.exe command. I understand that there are subtle differences between vortex and tsql, but this one has me stumped. The only thing I can think of that might be going on here is in how vortex and tsql differ when it comes to handling multiple statements. But if that is so, I don't see how to get around it. We want to create the index via our vortex script, but that is not working. As I said, we are finding that there are queries that do NOT return a hit in this case, when we know that they should.
I have not included the specific query nor the data in the table testdata, since (it seems to me) that the problem is somewhere in the way that I am indexing. However, I would be happy to include both of those if it would be helpful. The query is about 4800 characters in length, and rather complex, involving many references to terms found in a large equivalence file.
FYI, our Texis version is:
Commercial Version 6.01.1342629243 20120718 (i686-intel-winnt-64-32)
Thanks for your help.
