#1461 colon not working as fs separator

[George Herson]

A text table named hello.txt containing only "hello:world" returns "Access is denied" or "constraint violation" when
SET TABLE iedict SOURCE "hello.txt;fs=:"
is executed. Changing only the colon in hello.txt and the fs value in SET TABLE to another separator, e.g., "!" or "\semi", succeeds.

[Fred Toussi]

When parsing the text source string, it checks for the colon character as a filepath character and disallows it to avoid absolute references to files such as
SET TABLE iedict SOURCE "c:hello.txt;fs=|"
Knowing that, you should be able to get it to work by setting the system property allow_full_path which is documented in the Guide, Properties chapter

[George Herson]

Hi Fred,
I had tried that, and just tried again.  I get the same error, Access denied.
I referenced the bare filename as shown below, and attempted again with the full filespec (both forward and backward slashes).  All attempts return Access denied.

Does it work for you?
May be worth enabling a \colon special indicator.
Thank you,George H

[Fred Toussi]

Thanks for reporting it. We've had text tables for 14 years and this is the first time someone has tried to use the colon as separator. I will enable \colon escape as you suggested.

[Fred Toussi]

In the meantime, use allow_full_path as suggested in the Guide as a system property (not a connection property). You do this by adding a -D switch to the Java command.

Or better, use the \u003A unicode escape sequence

SET TABLE iedict SOURCE "c:hello.txt;fs=\u003A"

[George Herson]

clever, thanks.

[Fred Toussi]

Support for \colon escape for separators added to SVN.