Kbase P11909: Sequence is SQL-92 Reserve word beginning with 9.1D.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2009 |
|
Status: Unverified
SYMPTOM(s):
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
Error running SQL-92 query in 9.1D
Same SQL-92 query worked in 9.1B
Select statement is calling a table or field named sequence.
FACT(s) (Environment):
Progress 9.1D
CHANGE:
Upgraded from 9.1B to 9.1D.
CAUSE:
Sequence functionality was added to SQL-92 in 9.1D. As of 9.1D, sequence is a SQL-92 reserve word.
FIX:
Any reference to a table or field named sequence must be qualified with a double quote (pub.custtable."sequence").