BUG: Use of Vertical Bar (|) Generates Syntax Error

SYMPTOMS

When you execute a SELECT, INSERT, UPDATE or DELETE queries with a vertical bar (|) contained in a character string, you receive an error that there is a syntax error in string in query expression.

For example, consider table test created like: Then executing any of the following,

INSERT INTO test VALUES('|')
				

DELETE FROM test WHERE t='|'
				

UPDATE test SET t='|'
				

will return an error, with