You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Mamta A. Satoor (JIRA)" <de...@db.apache.org> on 2005/12/15 18:30:45 UTC
[jira] Created: (DERBY-761) The reserved words list in the reference manual doesn't look uptodate
The reserved words list in the reference manual doesn't look uptodate
---------------------------------------------------------------------
Key: DERBY-761
URL: http://issues.apache.org/jira/browse/DERBY-761
Project: Derby
Type: Bug
Components: Documentation
Reporter: Mamta A. Satoor
I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Eric Radzinski updated DERBY-761:
---------------------------------
Attachment: derby761-3.diff
rrefkeywords29722.html
latest patch changes _DEFAULT to DEFAULT.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761-2.diff, derby761-3.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365160 ]
Satheesh Bandaram commented on DERBY-761:
-----------------------------------------
I have reviewed the changes... I think this patch is ready to be committed.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761-2.diff, derby761-3.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Re: [jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by Army <qo...@sbcglobal.net>.
Mamta A. Satoor (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365110 ]
>
> Mamta A. Satoor commented on DERBY-761:
> ---------------------------------------
>
> I am glad you are looking at the list too. I was surprised to see D and T in the
> TOKEN reserved words list. Here is what I see in sqlgrammar.jj
<snip token list>
> But I don't see them in the reservedKeyword() so I guess D and T are not reserved words.
> Thanks for catching it. Eric, please take those off from your changes.
I haven't looked at this closely, but note that "TS" is in the same category as
"D" and "T". They're for timestamp, date, and time, respectively. So whatever
happens to "D" and "T" should probably (I assume, having not investigated
further) also occur for "TS". I.e. if you're going to remove "D" and "T", it
seems (to me) that you should probably remove "TS", as well...?
Army
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365110 ]
Mamta A. Satoor commented on DERBY-761:
---------------------------------------
I am glad you are looking at the list too. I was surprised to see D and T in the TOKEN reserved words list. Here is what I see in sqlgrammar.jj
/*
This list should contain only and all SQL92 keywords that are reserved.
Reserved keywords can be used as identifiers in the language only
as delimited identifiers.
*/
/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
* or nonReservedKeyword() as well!
*/
TOKEN [IGNORE_CASE] :
{ /* SQL92 reserved Keywords */
<ADD: "add">
| <ALL: "all">
| <ALLOCATE: "allocate">
| <ALTER: "alter">
| <AND: "and">
| <ANY: "any">
| <ARE: "are">
| <AS: "as">
| <ASC: "asc">
| <ASSERTION: "assertion">
| <AT: "at">
| <AUTHORIZATION: "authorization">
| <AVG: "avg">
| <BEGIN: "begin">
| <BETWEEN: "between">
| <BINARY: "binary">
| <BIT: "bit">
| <BOTH: "both">
| <BY: "by">
| <CASCADE: "cascade">
| <CASCADED: "cascaded">
| <CASE: "case">
| <CAST: "cast">
| <CHAR: "char">
| <CHARACTER: "character">
| <CHARACTER_LENGTH: "character_length">
| <CHECK: "check">
| <CLOSE: "close">
| <COALESCE: "coalesce">
| <COLLATE: "collate">
| <COLLATION: "collation">
| <COLUMN: "column">
| <COMMIT: "commit">
| <CONNECT: "connect">
| <CONNECTION: "connection">
| <CONSTRAINT: "constraint">
| <CONSTRAINTS: "constraints">
| <CONTINUE: "continue">
| <CONVERT: "convert">
| <CORRESPONDING: "corresponding">
| <COUNT: "count">
| <CREATE: "create">
| <CURRENT: "current">
| <CURRENT_DATE: "current_date">
| <CURRENT_TIME: "current_time">
| <CURRENT_TIMESTAMP: "current_timestamp">
| <CURRENT_USER: "current_user">
| <CURSOR: "cursor">
| <D: "d">
| <DEALLOCATE: "deallocate">
| <DEC: "dec">
| <DECIMAL: "decimal">
| <DECLARE: "declare">
| <_DEFAULT: "default">
| <DEFERRABLE: "deferrable">
| <DEFERRED: "deferred">
| <DELETE: "delete">
| <DESC: "desc">
| <DESCRIBE: "describe">
| <DIAGNOSTICS: "diagnostics">
| <DISCONNECT: "disconnect">
| <DISTINCT: "distinct">
| <DOUBLE: "double">
| <DROP: "drop">
| <ELSE: "else">
| <END: "end">
| <ENDEXEC: "end-exec">
| <ESCAPE: "escape">
| <EXCEPT: "except">
| <EXCEPTION: "exception">
| <EXEC: "exec">
| <EXECUTE: "execute">
| <EXISTS: "exists">
| <EXTERNAL: "external">
| <FALSE: "false">
| <FETCH: "fetch">
| <FIRST: "first">
| <FLOAT: "float">
| <FOR: "for">
| <FOREIGN: "foreign">
| <FOUND: "found">
| <FROM: "from">
| <FULL: "full">
| <FUNCTION: "function">
| <GET: "get">
| <GLOBAL: "global">
| <GO: "go">
| <GOTO: "goto">
| <GRANT: "grant">
| <GROUP: "group">
| <HAVING: "having">
| <HOUR: "hour">
| <IDENTITY: "identity">
| <IMMEDIATE: "immediate">
| <IN: "in">
| <INDICATOR: "indicator">
| <INITIALLY: "initially">
| <INNER: "inner">
| <INPUT: "input">
| <INSENSITIVE: "insensitive">
| <INSERT: "insert">
| <INT: "int">
| <INTEGER: "integer">
| <INTERSECT: "intersect">
| <INTO: "into">
| <IS: "is">
| <ISOLATION: "isolation">
| <JOIN: "join">
| <KEY: "key">
| <LAST: "last">
| <LEFT: "left">
| <LIKE: "like">
| <LOWER: "lower">
| <MATCH: "match">
| <MAX: "max">
| <MIN: "min">
| <MINUTE: "minute">
| <MODULE: "module">
| <NATIONAL: "national">
| <NATURAL: "natural">
| <NCHAR: "nchar">
| <NEXT: "next">
| <NO: "no">
| <NOT: "not">
| <NULL: "null">
| <NULLIF: "nullif">
| <NUMERIC: "numeric">
| <OF: "of">
| <ON: "on">
| <ONLY: "only">
| <OPEN: "open">
| <OPTION: "option">
| <OR: "or">
| <ORDER: "order">
| <OUTER: "outer">
| <OUTPUT: "output">
| <OVERLAPS: "overlaps">
| <PAD: "pad">
| <PARTIAL: "partial">
| <PREPARE: "prepare">
| <PRESERVE: "preserve">
| <PRIMARY: "primary">
| <PRIOR: "prior">
| <PRIVILEGES: "privileges">
| <PROCEDURE: "procedure">
| <PUBLIC: "public">
| <READ: "read">
| <REAL: "real">
| <REFERENCES: "references">
| <RELATIVE: "relative">
| <RESTRICT: "restrict">
| <REVOKE: "revoke">
| <RIGHT: "right">
| <ROLLBACK: "rollback">
| <ROWS: "rows">
| <SCHEMA: "schema">
| <SCROLL: "scroll">
| <SECOND: "second">
| <SELECT: "select">
| <SESSION_USER: "session_user">
| <SET: "set">
| <SMALLINT: "smallint">
| <SOME: "some">
| <SPACE: "space">
| <SQL: "sql">
| <SQLCODE: "sqlcode">
| <SQLERROR: "sqlerror">
| <SQLSTATE: "sqlstate">
| <SUBSTRING: "substring">
| <SUM: "sum">
| <SYSTEM_USER: "system_user">
| <T: "t">
| <TABLE: "table">
| <TEMPORARY: "temporary">
| <TIMEZONE_HOUR: "timezone_hour">
| <TIMEZONE_MINUTE: "timezone_minute">
| <TO: "to">
| <TRANSACTION: "transaction">
| <TRANSLATE: "translate">
| <TRANSLATION: "translation">
| <TRUE: "true">
| <TS: "ts">
| <UNION: "union">
| <UNIQUE: "unique">
| <UNKNOWN: "unknown">
| <UPDATE: "update">
| <UPPER: "upper">
| <USER: "user">
| <USING: "using">
| <VALUE: "value">
| <VALUES: "values">
| <VARBINARY: "varbinary">
| <VARCHAR: "varchar">
| <VARYING: "varying">
| <VIEW: "view">
| <WHENEVER: "whenever">
| <WHERE: "where">
| <WITH: "with">
| <WORK: "work">
| <WRITE: "write">
| <YEAR: "year">
}
/*
The next lists should contain non-SQL92 keywords, and should
specify whether their keywords are reserved or non-reserved.
If they are non-reserved, they need to be added to the identifier() rule.
NOTE: XML, XMLPARSE, XMLSERIALIZE, and XMLEXISTS are considered reserved
words to comply with the SQL/XML (2003) standard, section 5.1.
*/
/* NOTE - If you add a keyword, then you must add it to reservedKeyword()
* or nonReservedKeyword() as well!
*/
TOKEN [IGNORE_CASE] :
{ /* Additional JSQL reserved keywords -- non-SQL92 reserved Keywords */
<BOOLEAN: "boolean">
| <CALL: "call">
| <CURDATE: "curdate">
| <CURTIME: "curtime">
| <DATABASE: "database">
| <GET_CURRENT_CONNECTION: "getCurrentConnection">
| <EXPLAIN: "explain">
| <LONGINT: "bigint">
| <LONG: "long">
| <LTRIM: "ltrim">
| <RTRIM: "rtrim">
| <SUBSTR: "substr">
| <XML: "xml">
| <XMLPARSE: "xmlparse">
| <XMLSERIALIZE: "xmlserialize">
| <XMLEXISTS: "xmlexists">
}
But I don't see them in the reservedKeyword() so I guess D and T are not reserved words. Thanks for catching it. Eric, please take those off from your changes.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365145 ]
Mamta A. Satoor commented on DERBY-761:
---------------------------------------
Satheesh, your list looks correct except for _DEFAULT. It should really be DEFAULT which is the reserved keyword.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761-2.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Satheesh Bandaram updated DERBY-761:
------------------------------------
Comment: was deleted
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365102 ]
Mamta A. Satoor commented on DERBY-761:
---------------------------------------
I looked at sqlgrammar.jj and found following set of keywords that are missing from the docs
1)BINARY
2)CHARACTER_LENGTH
3)COALESCE
4)D
5)_DEFAULT
6)LOWER
7)MODULE
8)T
9)TS
10)VALUE
11)VARBINARY
Following should be removed from the reserved keywords list from the doc
1)INOUT
2)NVARCHAR
3)OUT
4)TRAILING
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Eric Radzinski updated DERBY-761:
---------------------------------
Attachment: (was: rrefkeywords29722.html)
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365109 ]
Satheesh Bandaram commented on DERBY-761:
-----------------------------------------
Mamta, is D as a reserved word?
This is the list of reserved words I see in 10.2.
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUTHORIZATION
AVG
BEGIN
BETWEEN
BIT
BOTH
BY
CASCADE
CASCADED
CASE
CAST
CHAR
CHARACTER
CHECK
CLOSE
COLLATE
COLLATION
COLUMN
COMMIT
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
CREATE
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DEALLOCATE
DEC
DECIMAL
DECLARE
_DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DIAGNOSTICS
DISCONNECT
DISTINCT
DOUBLE
DROP
ELSE
END
ENDEXEC
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXTERNAL
FALSE
FETCH
FIRST
FLOAT
FOR
FOREIGN
FOUND
FROM
FULL
FUNCTION
GET
GET_CURRENT_CONNECTION
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
IDENTITY
IMMEDIATE
IN
INDICATOR
INITIALLY
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTO
IS
ISOLATION
JOIN
KEY
LAST
LEFT
LIKE
LOWER
MATCH
MAX
MIN
MINUTE
NATIONAL
NATURAL
NCHAR
NVARCHAR
NEXT
NO
NOT
NULL
NULLIF
NUMERIC
OF
ON
ONLY
OPEN
OPTION
OR
ORDER
OUT
OUTER
OUTPUT
OVERLAPS
PAD
PARTIAL
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
READ
REAL
REFERENCES
RELATIVE
RESTRICT
REVOKE
RIGHT
ROLLBACK
ROWS
SCHEMA
SCROLL
SECOND
SELECT
SESSION_USER
SET
SMALLINT
SOME
SPACE
SQL
SQLCODE
SQLERROR
SQLSTATE
SUBSTRING
SUM
SYSTEM_USER
TABLE
TEMPORARY
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRANSACTION
TRANSLATE
TRANSLATION
TRUE
UNION
UNIQUE
UNKNOWN
UPDATE
UPPER
USER
USING
VALUES
VARCHAR
VARYING
VIEW
WHENEVER
WHERE
WITH
WORK
WRITE
YEAR
BOOLEAN
CALL
EXPLAIN
LONGINT
LTRIM
RTRIM
SUBSTR
XML
XMLPARSE
XMLSERIALIZE
XMLEXISTS
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Eric Radzinski updated DERBY-761:
---------------------------------
Attachment: (was: rrefkeywords29722.html)
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761-2.diff, derby761-3.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365115 ]
Satheesh Bandaram commented on DERBY-761:
-----------------------------------------
Here is the correct list... My previous list had GET_CURRENT_CONNECTION, it should have been GETCURRENTCONNECTION.
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUTHORIZATION
AVG
BEGIN
BETWEEN
BIGINT
BIT
BOTH
BY
CASCADE
CASCADED
CASE
CAST
CHAR
CHARACTER
CHECK
CLOSE
COLLATE
COLLATION
COLUMN
COMMIT
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
CREATE
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DEALLOCATE
DEC
DECIMAL
DECLARE
_DEFAULT
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DIAGNOSTICS
DISCONNECT
DISTINCT
DOUBLE
DROP
ELSE
END
END-EXEC
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXTERNAL
FALSE
FETCH
FIRST
FLOAT
FOR
FOREIGN
FOUND
FROM
FULL
FUNCTION
GET
GETCURRENTCONNECTION
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
IDENTITY
IMMEDIATE
IN
INDICATOR
INITIALLY
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTO
IS
ISOLATION
JOIN
KEY
LAST
LEFT
LIKE
LOWER
MATCH
MAX
MIN
MINUTE
NATIONAL
NATURAL
NCHAR
NVARCHAR
NEXT
NO
NOT
NULL
NULLIF
NUMERIC
OF
ON
ONLY
OPEN
OPTION
OR
ORDER
OUT
OUTER
OUTPUT
OVERLAPS
PAD
PARTIAL
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
READ
REAL
REFERENCES
RELATIVE
RESTRICT
REVOKE
RIGHT
ROLLBACK
ROWS
SCHEMA
SCROLL
SECOND
SELECT
SESSION_USER
SET
SMALLINT
SOME
SPACE
SQL
SQLCODE
SQLERROR
SQLSTATE
SUBSTRING
SUM
SYSTEM_USER
TABLE
TEMPORARY
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRANSACTION
TRANSLATE
TRANSLATION
TRUE
UNION
UNIQUE
UNKNOWN
UPDATE
UPPER
USER
USING
VALUES
VARCHAR
VARYING
VIEW
WHENEVER
WHERE
WITH
WORK
WRITE
YEAR
BOOLEAN
CALL
EXPLAIN
LTRIM
RTRIM
SUBSTR
XML
XMLPARSE
XMLSERIALIZE
XMLEXISTS
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-761) The reserved words list in the reference
manual doesn't look uptodate
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Jean T. Anderson closed DERBY-761:
----------------------------------
No problems have been reported with the committed patch, so closing.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Fix For: 10.2.0.0
> Attachments: derby761-2.diff, derby761-3.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Eric Radzinski updated DERBY-761:
---------------------------------
Attachment: derby761-2.diff
rrefkeywords29722.html
This patch and HTML file are based on Sateesh's list.
Note that several of the keywords that Mamta originally suggested including are not present. These include: BINARY, CHARACTER_LENGTH, D, MODULE, T, TS, VALUE, and VARBINARY.
And this list does include INOUT and NVARCHAR, which Mamta suggested deleting.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761-2.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Eric Radzinski updated DERBY-761:
---------------------------------
Attachment: derby761.diff
rrefkeywords29722.html
attached patch addresses derby-761. HTML file is included for review.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Attachments: derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=all ]
Jean T. Anderson resolved DERBY-761:
------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Committed derby761-3.diff to the trunk, revision 374803. Modified files:
$ svn status
M src/ref/rrefkeywords29722.dita
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
> Fix For: 10.2.0.0
> Attachments: derby761-2.diff, derby761-3.diff, derby761.diff, rrefkeywords29722.html
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-761) The reserved words list in the
reference manual doesn't look uptodate
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-761?page=comments#action_12365094 ]
Eric Radzinski commented on DERBY-761:
--------------------------------------
If somebody can provide a complete list of reserved words, I'll update the reference guide.
> The reserved words list in the reference manual doesn't look uptodate
> ---------------------------------------------------------------------
>
> Key: DERBY-761
> URL: http://issues.apache.org/jira/browse/DERBY-761
> Project: Derby
> Type: Bug
> Components: Documentation
> Reporter: Mamta A. Satoor
>
> I looked at the 10.1 reference manual's reserved word list and noticed keywords like BINARY, COALESCE missing from the list. Haven't checked the list thoroughly to see what else might be missing but it would be good to fix this for 10.2
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira