If I create a table with 'SET' in the name, it cannot
be queried. Here's a session:
Ashpool~# CREATE TABLE TESTSET ( TEST1 string(30),
TEST2 string(30));
0 Rows Returned.
Total Time: 0 second(s) - 3ms
Ashpool~# SELECT COUNT(*) FROM TESTSET;
Error with command:
'SELECT COUNT(*) FROM TESTSET'
com.rohanclan.ashpool.core.AshpoolException:
datastore/TESTset.xml (No such file or directory)
Ashpool~# CREATE TABLE TESTSET2 ( TEST1 string(30),
TEST2 string(30));
0 Rows Returned.
Total Time: 0 second(s) - 50ms
Ashpool~# SELECT COUNT(*) FROM TESTSET2;
Error with command:
'SELECT COUNT(*) FROM TESTSET2'
com.rohanclan.ashpool.core.AshpoolException:
datastore/TESTset2.xml (No such file or directory)
[ashpool]$ ls datastore/TESTSET*
datastore/TESTSET2.xml datastore/TESTSET.xml
datastore/TESTSET2.xsd datastore/TESTSET.xsd
This is on Linux. I assume you don't experience the
problem on a system with a case-insensitive filesystem.
mike