This is an automated email from the ASF dual-hosted git repository.
struberg pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/openjpa.git
The following commit(s) were added to refs/heads/master by this push:
new d8b3fd8 OPENJPA-2868 add tested reserved word list for MS SQLServer
d8b3fd8 is described below
commit d8b3fd87ff111ab071a95dcc137fc340f7434b07
Author: Mark Struberg <[email protected]>
AuthorDate: Sun May 2 16:45:43 2021 +0200
OPENJPA-2868 add tested reserved word list for MS SQLServer
no list has previously been maintained.
---
.../openjpa/jdbc/sql/SQLServerDictionary.java | 23 ++++++++++++++++++++++
1 file changed, 23 insertions(+)
diff --git
a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
index a7061c4..43e9836 100644
---
a/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
+++
b/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/SQLServerDictionary.java
@@ -31,6 +31,7 @@ import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.OffsetDateTime;
+import java.util.Arrays;
import java.util.Calendar;
import java.util.Locale;
@@ -83,6 +84,28 @@ public class SQLServerDictionary extends
AbstractSQLServerDictionary {
timestampWithZoneTypeName = "DATETIMEOFFSET";
indexPhysicalForeignKeys = true; // MS-SQLServer does not
automatically create an index for a foreign key so we will
+
+ // reservedWordSet subset that CANNOT be used as valid column names
+ // (i.e., without surrounding them with double-quotes)
+ // generated at 2021-05-02T16:15:30.630 via
org.apache.openjpa.reservedwords.ReservedWordsIT
+ invalidColumnWordSet.addAll(Arrays.asList(new String[] {
+ "ADD", "ALL", "ALTER", "AND", "ANY", "AS", "ASC", "AUTHORIZATION",
"BACKUP", "BEGIN", "BETWEEN", "BREAK", "BROWSE",
+ "BULK", "BY", "CASCADE", "CASE", "CHECK", "CHECKPOINT", "CLOSE",
"CLUSTERED", "COALESCE", "COLLATE", "COLUMN",
+ "COMMIT", "COMPUTE", "CONSTRAINT", "CONTAINS", "CONTAINSTABLE",
"CONTINUE", "CONVERT", "CREATE", "CROSS", "CURRENT",
+ "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP",
"CURRENT_USER", "CURSOR", "DATABASE", "DBCC", "DEALLOCATE",
+ "DECLARE", "DEFAULT", "DELETE", "DENY", "DESC", "DISTINCT",
"DISTRIBUTED", "DOUBLE", "DROP", "ELSE", "END", "END-EXEC",
+ "ERRLVL", "ESCAPE", "EXCEPT", "EXEC", "EXECUTE", "EXISTS", "EXIT",
"EXTERNAL", "FETCH", "FILE", "FILLFACTOR", "FOR",
+ "FOREIGN", "FREETEXT", "FREETEXTTABLE", "FROM", "FULL",
"FUNCTION", "GOTO", "GRANT", "GROUP", "HAVING", "HOLDLOCK",
+ "IDENTITY", "IDENTITY_INSERT", "IDENTITYCOL", "IF", "IN", "INDEX",
"INNER", "INSERT", "INTERSECT", "INTO", "IS",
+ "JOIN", "KEY", "KILL", "LEFT", "LIKE", "LINENO", "MERGE",
"NATIONAL", "NOCHECK", "NONCLUSTERED", "NOT", "NULL",
+ "NULLIF", "OF", "OFF", "OFFSETS", "ON", "OPEN", "OPENDATASOURCE",
"OPENQUERY", "OPENROWSET", "OPENXML", "OPTION",
+ "OR", "ORDER", "OUTER", "OVER", "PERCENT", "PLAN", "PRIMARY",
"PRINT", "PROC", "PROCEDURE", "PUBLIC", "RAISERROR",
+ "READ", "READTEXT", "RECONFIGURE", "REFERENCES", "REPLICATION",
"RESTORE", "RESTRICT", "RETURN", "REVOKE", "RIGHT",
+ "ROLLBACK", "ROWCOUNT", "ROWGUIDCOL", "RULE", "SAVE", "SCHEMA",
"SELECT", "SESSION_USER", "SET", "SETUSER", "SHUTDOWN",
+ "SOME", "STATISTICS", "SYSTEM_USER", "TABLE", "TABLESAMPLE",
"TEXTSIZE", "THEN", "TO", "TOP", "TRAN", "TRANSACTION",
+ "TRIGGER", "TRUNCATE", "TSEQUAL", "UNION", "UNIQUE", "UPDATE",
"UPDATETEXT", "USE", "USER", "VALUES", "VARYING",
+ "VIEW", "WAITFOR", "WHEN", "WHERE", "WHILE", "WITH", "WRITETEXT",
+ }));
}
@Override
