db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ReferenceManualTenTwo" by RajeshKartha
Date Wed, 30 Aug 2006 20:02:10 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by RajeshKartha:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  [[Anchor(sqlreference)]]''' SQL Language Reference:'''
  
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- ||DECLARE GLOBAL TEMPORARY TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefdeclaretemptable.html
HTML URL] || Yip || Under Restrictions on Declared Global Temporary Tables, GRANT and REVOKE
should be added to that restriction list. ||
+ ||DECLARE GLOBAL TEMPORARY TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefdeclaretemptable.html
HTML URL] || Yip || Under Restrictions on Declared Global Temporary Tables, GRANT and REVOKE
should be added to that restriction list. || ||
- ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
HTML URL] || Yip || CREATE SCHEMA syntax needs to be updated.  The following are also allowed:
 CREATE SCHEMA schema-name AUTHORIZATION user-name and CREATE SCHEMA AUTHORIZATION user-name.
 Addtional examples to use these new syntax would be nice. ||
+ ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
HTML URL] || Yip || CREATE SCHEMA syntax needs to be updated.  The following are also allowed:
 CREATE SCHEMA schema-name AUTHORIZATION user-name and CREATE SCHEMA AUTHORIZATION user-name.
 Addtional examples to use these new syntax would be nice. || ||
- ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html
HTML URL] || Yip || RENAME TABLE needs to address that one can only perform renaming of a
table if the user is the database owner or the user have the authorization to the schema of
the table to be renamed. ||
+ ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html
HTML URL] || Yip || RENAME TABLE needs to address that one can only perform renaming of a
table if the user is the database owner or the user have the authorization to the schema of
the table to be renamed. || ||
- ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html HTML
URL] || Yip || LOCK TABLE needs to address that one can only perform locking of a table if
the user is the database owner or the user have the proper privilege to execute such an action.
 This is not covered in the design spec. ||
+ ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html HTML
URL] || Yip || LOCK TABLE needs to address that one can only perform locking of a table if
the user is the database owner or the user have the proper privilege to execute such an action.
 This is not covered in the design spec. || ||
- ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
HTML URL] || Yip || The statement "You can create a trigger in any schema except one that
starts with SYS." is no longer true when sql authorization is enabled.  Also, under the syntax
section, { INSERT | DELETE | UPDATE } [OF column-name [, column-name]* ] should be { INSERT
| DELETE | UPDATE [ OF column-name [, column-name]* ] } ||
+ ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
HTML URL] || Yip || The statement "You can create a trigger in any schema except one that
starts with SYS." is no longer true when sql authorization is enabled.  Also, under the syntax
section, { INSERT | DELETE | UPDATE } [OF column-name [, column-name]* ] should be { INSERT
| DELETE | UPDATE [ OF column-name [, column-name]* ] } || ||
- ||Built-in Functions || [http://db.apache.org/derby/docs/dev/ref/toc.html HTML URL] || Susan
|| The table of contents was edited to include the new Math Functions (see DERBY-1549) ACOS,
ASIN, ATAN, etc.  The word "function" was added to each of these functions in the toc, whereas
the existing functions do not contain this word.  For consistency it would be better if this
word was removed. ||
+ ||Built-in Functions || [http://db.apache.org/derby/docs/dev/ref/toc.html HTML URL] || Susan
|| The table of contents was edited to include the new Math Functions (see DERBY-1549) ACOS,
ASIN, ATAN, etc.  The word "function" was added to each of these functions in the toc, whereas
the existing functions do not contain this word.  For consistency it would be better if this
word was removed. || ||
- ||ATAN Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncatan.html HTML URL]
|| Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement
'If the specified number is zero (0), the result of this function is zero with the same sign
as the specified number. ' should be changed to this 'If the specified number is zero (0),
the result of this function is zero.'  ||
+ ||ATAN Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncatan.html HTML URL]
|| Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement
'If the specified number is zero (0), the result of this function is zero with the same sign
as the specified number. ' should be changed to this 'If the specified number is zero (0),
the result of this function is zero.'  || ||
- ||CEIL Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncceil.html HTML URL]
|| Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement
'If the specified number is less than zero but greater than -1.0, then the result of these
functions is negative zero.' should be changed to this 'If the specified number is less than
zero but greater than -1.0, then the result of these functions is zero.'  ||
+ ||CEIL Function || [http://db.apache.org/derby/docs/dev/ref/rreffuncceil.html HTML URL]
|| Susan  || According to DERBY-1548, Derby does not support negative zero, so this statement
'If the specified number is less than zero but greater than -1.0, then the result of these
functions is negative zero.' should be changed to this 'If the specified number is less than
zero but greater than -1.0, then the result of these functions is zero.'  || ||
- ||JDBC Escape Syntax - PI Function || [http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html
HTML URL] || Susan  || I think this is a typo - 'Returns an value that is closer than any
other value to pi.'  I believe this is correct, 'Returns a value that is closer than any other
value to pi.'  ||
+ ||JDBC Escape Syntax - PI Function || [http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html
HTML URL] || Susan  || I think this is a typo - 'Returns an value that is closer than any
other value to pi.'  I believe this is correct, 'Returns a value that is closer than any other
value to pi.'  || ||
- ||List of datatypes || http://db.apache.org/derby/docs/dev/ref/ || Dan D || In the list
of data types the XML type is listed as 'XML data type', remove the words 'data type', all
of the other types are listed just as the type name. Same is true of the page that describes
the XML type, it says 'XML data type', other types just have the name of the type, e.g. BLOB
||
+ ||List of datatypes || http://db.apache.org/derby/docs/dev/ref/ || Dan D || In the list
of data types the XML type is listed as 'XML data type', remove the words 'data type', all
of the other types are listed just as the type name. Same is true of the page that describes
the XML type, it says 'XML data type', other types just have the name of the type, e.g. BLOB
|| ||
- || XQUERY operator || docs/html/ref/rreffuncxmlquery.html || Dan D || This description:
''The result of the XMLQUERY operator is another Derby XML value. Unlike other XML values,
the result might represent an empty sequence of XML nodes or values. Atomic values, such as
strings, can be part of the result sequence. The result of an XMLQUERY operator is not guaranteed
to represent a valid XML document and it might not be possible to insert the result of an
XMLQUERY operator into a Derby XML column'' should be replaced with: The result of the XMLQUERY
operator is '''a value of type XML'''. '''The result represents a''' sequence of XML nodes
or values. Atomic values, such as strings, can be part of the result sequence. The result
of an XMLQUERY operator is not guaranteed to represent a '''well formed''' XML document and
it might not be possible to insert the result of an XMLQUERY operator into an XML column 
- Notes on the changes (bold), a) no need to use Derby b) The old word
 ing had the use of 'might' and 'empty sequence', I think it wanted to describe a sequence
and the result is always a sequence, not that it might be. c) Use of 'well-formed' is better
than 'valid'. ||
+ || XQUERY operator || docs/html/ref/rreffuncxmlquery.html || Dan D || This description:
''The result of the XMLQUERY operator is another Derby XML value. Unlike other XML values,
the result might represent an empty sequence of XML nodes or values. Atomic values, such as
strings, can be part of the result sequence. The result of an XMLQUERY operator is not guaranteed
to represent a valid XML document and it might not be possible to insert the result of an
XMLQUERY operator into a Derby XML column'' should be replaced with: The result of the XMLQUERY
operator is '''a value of type XML'''. '''The result represents a''' sequence of XML nodes
or values. Atomic values, such as strings, can be part of the result sequence. The result
of an XMLQUERY operator is not guaranteed to represent a '''well formed''' XML document and
it might not be possible to insert the result of an XMLQUERY operator into an XML column 
- Notes on the changes (bold), a) no need to use Derby b) The old word
 ing had the use of 'might' and 'empty sequence', I think it wanted to describe a sequence
and the result is always a sequence, not that it might be. c) Use of 'well-formed' is better
than 'valid'. || ||
  
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  [[Anchor(sql92support)]]'''Derby support for SQL-92 features: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || ||  ||
+ || ||  || ||  || ||
  
  
  [[Anchor(systemtables)]]'''Derby System Tables: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  
  [[Anchor(exceptionmessages)]]'''Derby exception messages and SQL States: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || Autogen of sqlstates || [https://issues.apache.org/jira/browse/DERBY-1566 DERBY-1566]
|| jta || See the Jira issue||
+ || Autogen of sqlstates || [https://issues.apache.org/jira/browse/DERBY-1566 DERBY-1566]
|| jta || See the Jira issue|| ||
  
  [[Anchor(jdbcref)]]'''JDBC Reference: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  
  [[Anchor(settingattr)]]'''Setting attributes for the database connection URL: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  
  [[Anchor(j2eecompliance)]]'''J2EE Compliance: Java Transaction API and javax.sql Extensions:
'''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  
  [[Anchor(derbyapi)]]'''Derby API: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  
  
  [[Anchor(derbylimits)]]'''Derby limitations: '''
  
- ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||
+ ||'''Sub Section''' || '''HTML Url''' or '''PDF Page''' || '''Reviewer'''|| '''Comment'''
||'''Resolution''' ||
- || ||  || || ||
+ || ||  || || || ||
  

Mime
View raw message