Menu

#5 tables with 'SET' in name cannot be queried

open
nobody
Core Error (4)
5
2004-01-21
2004-01-21
Mike Traum
No

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

Discussion


Log in to post a comment.