You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2010/09/29 19:44:37 UTC
svn commit: r1002785 - in /db/derby/docs/trunk/src/ref: refderby.ditamap
rrefsqlj33562.dita rrefsqlj58560.dita rrefsqljBoolean.dita
Author: rhillegas
Date: Wed Sep 29 17:44:36 2010
New Revision: 1002785
URL: http://svn.apache.org/viewvc?rev=1002785&view=rev
Log:
DERBY-4737: Add user documentation for BOOLEAN datatype.
Added:
db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita (with props)
Modified:
db/derby/docs/trunk/src/ref/refderby.ditamap
db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
db/derby/docs/trunk/src/ref/rrefsqlj58560.dita
Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1002785&r1=1002784&r2=1002785&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Wed Sep 29 17:44:36 2010
@@ -442,6 +442,7 @@ data type"></topicref>
</topicref>
<topicref href="rrefsqlj30435.dita" navtitle="BIGINT data type"></topicref>
<topicref href="rrefblob.dita" navtitle="BLOB data type"></topicref>
+<topicref href="rrefsqljBoolean.dita" navtitle="BOOLEAN data type"></topicref>
<topicref href="rrefsqlj13733.dita" navtitle="CHAR data type"></topicref>
<topicref href="rrefsqlj57924.dita" navtitle="CHAR FOR BIT DATA data type">
</topicref>
Modified: db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33562.dita?rev=1002785&r1=1002784&r2=1002785&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33562.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33562.dita Wed Sep 29 17:44:36 2010
@@ -43,21 +43,39 @@ second row lists the source data type SM
second row indicate the whether or not you can convert SMALLINT to the target
data types that are listed in the first row of the table.<table><title>Explicit
conversions between source types and target types for SQL data types</title>
-<tgroup cols="20"><colspec colname="colspec0" colwidth="330*"/><colspec colname="col2"
-colwidth="84*"/><colspec colname="col3" colwidth="84*"/><colspec colname="col4"
-colwidth="84*"/><colspec colname="col5" colwidth="84*"/><colspec colname="col6"
-colwidth="81*"/><colspec colname="colspec1" colwidth="84*"/><colspec colname="colspec9"
-colwidth="84*"/><colspec colname="colspec8" colwidth="84*"/><colspec colname="colspec7"
-colwidth="84*"/><colspec colname="colspec6" colwidth="81*"/><colspec colname="colspec5"
-colwidth="84*"/><colspec colname="colspec4" colwidth="87*"/><colspec colname="colspec3"
-colwidth="81*"/><colspec colname="colspec2" colwidth="84*"/><colspec colname="colspec10"
-colwidth="84*"/><colspec colname="colspec13" colwidth="84*"/><colspec colname="colspec12"
-colwidth="84*"/><colspec colname="colspec11" colwidth="84*"/><colspec colname="COLSPEC14"
-colwidth="84*"/>
+<tgroup cols="20">
+<colspec colname="colspec0" colwidth="330*"/>
+<colspec colname="col_boolean" colwidth="84*"/>
+<colspec colname="col_smallint" colwidth="84*"/>
+<colspec colname="col_integer" colwidth="84*"/>
+<colspec colname="col_bigint" colwidth="84*"/>
+<colspec colname="col_decimal" colwidth="84*"/>
+<colspec colname="col_real" colwidth="81*"/>
+<colspec colname="col_double" colwidth="84*"/>
+<colspec colname="col_float" colwidth="84*"/>
+<colspec colname="col_char" colwidth="84*"/>
+<colspec colname="col_varchar" colwidth="84*"/>
+<colspec colname="col_longvarchar" colwidth="81*"/>
+<colspec colname="col_charforbitdata" colwidth="84*"/>
+<colspec colname="col_varcharforbitdata" colwidth="87*"/>
+<colspec colname="col_longvarcharforbitdata" colwidth="81*"/>
+<colspec colname="col_clob" colwidth="84*"/>
+<colspec colname="col_blob" colwidth="84*"/>
+<colspec colname="col_date" colwidth="84*"/>
+<colspec colname="col_time" colwidth="84*"/>
+<colspec colname="col_timestamp" colwidth="84*"/>
+<colspec colname="col_xml" colwidth="84*"/>
<thead>
<row>
<entry colname="colspec0" valign="top">Types</entry>
-<entry colname="col2" valign="top"> <lines>S
+<entry colname="col_smallint" valign="top"> <lines>B
+O
+O
+L
+E
+A
+N</lines></entry>
+<entry colname="col_smallint" valign="top"> <lines>S
M
A
L
@@ -65,53 +83,53 @@ L
I
N
T</lines></entry>
-<entry colname="col3" valign="top"> <lines>I
+<entry colname="col_integer" valign="top"> <lines>I
N
T
E
G
E
R</lines></entry>
-<entry colname="col4" valign="top"> <lines>B
+<entry colname="col_bigint" valign="top"> <lines>B
I
G
I
N
T</lines></entry>
-<entry colname="col5" valign="top"> <lines>D
+<entry colname="col_decimal" valign="top"> <lines>D
E
C
I
M
A
L</lines></entry>
-<entry colname="col6" valign="top"> <lines>R
+<entry colname="col_real" valign="top"> <lines>R
E
A
L</lines></entry>
-<entry colname="colspec1" valign="top"> <lines>D
+<entry colname="col_double" valign="top"> <lines>D
O
U
B
L
E</lines></entry>
-<entry colname="colspec9" valign="top"> <lines>F
+<entry colname="col_float" valign="top"> <lines>F
L
O
A
T</lines></entry>
-<entry colname="colspec8" valign="top"> <lines>C
+<entry colname="col_char" valign="top"> <lines>C
H
A
R</lines></entry>
-<entry colname="colspec7" valign="top"> <lines>V
+<entry colname="col_varchar" valign="top"> <lines>V
A
R
C
H
A
R</lines></entry>
-<entry colname="colspec6" valign="top"> <lines>L
+<entry colname="col_longvarchar" valign="top"> <lines>L
O
N
G
@@ -123,7 +141,7 @@ C
H
A
R</lines></entry>
-<entry colname="colspec5" valign="top"> <lines>C
+<entry colname="col_charforbitdata" valign="top"> <lines>C
H
A
R
@@ -140,7 +158,7 @@ D
A
T
A</lines></entry>
-<entry colname="colspec4" valign="top"> <lines>V
+<entry colname="col_varcharforbitdata" valign="top"> <lines>V
A
R
C
@@ -160,7 +178,7 @@ D
A
T
A</lines></entry>
-<entry colname="colspec3" valign="top"> <lines>L
+<entry colname="col_longvarcharforbitdata" valign="top"> <lines>L
O
N
G
@@ -185,23 +203,23 @@ D
A
T
A</lines></entry>
-<entry colname="colspec2" valign="top"> <lines>C
+<entry colname="col_clob" valign="top"> <lines>C
L
O
B</lines></entry>
-<entry colname="colspec10" valign="top"> <lines>B
+<entry colname="col_blob" valign="top"> <lines>B
L
O
B</lines></entry>
-<entry colname="colspec13" valign="top"> <lines>D
+<entry colname="col_date" valign="top"> <lines>D
A
T
E</lines></entry>
-<entry colname="colspec12" valign="top"> <lines>T
+<entry colname="col_time" valign="top"> <lines>T
I
M
E</lines></entry>
-<entry colname="colspec11" valign="top"> <lines>T
+<entry colname="col_timestamp" valign="top"> <lines>T
I
M
E
@@ -210,429 +228,471 @@ T
A
M
P</lines></entry>
-<entry colname="COLSPEC14" valign="top"> <lines>X
+<entry colname="col_xml" valign="top"> <lines>X
M
L</lines></entry>
</row>
</thead>
<tbody>
<row>
+<entry colname="colspec0">BOOLEAN</entry>
+<entry colname="col_boolean">Y</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">Y</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
+</row>
+<row>
<entry colname="colspec0">SMALLINT</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">INTEGER</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">BIGINT</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">DECIMAL</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">REAL</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">DOUBLE</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">FLOAT</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">Y</entry>
-<entry colname="colspec1">Y</entry>
-<entry colname="colspec9">Y</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">Y</entry>
+<entry colname="col_double">Y</entry>
+<entry colname="col_float">Y</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">CHAR</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">Y</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">Y</entry>
-<entry colname="colspec12">Y</entry>
-<entry colname="colspec11">Y</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">Y</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">Y</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">Y</entry>
+<entry colname="col_time">Y</entry>
+<entry colname="col_timestamp">Y</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">VARCHAR</entry>
-<entry colname="col2">Y</entry>
-<entry colname="col3">Y</entry>
-<entry colname="col4">Y</entry>
-<entry colname="col5">Y</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">Y</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">Y</entry>
-<entry colname="colspec12">Y</entry>
-<entry colname="colspec11">Y</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">Y</entry>
+<entry colname="col_smallint">Y</entry>
+<entry colname="col_integer">Y</entry>
+<entry colname="col_bigint">Y</entry>
+<entry colname="col_decimal">Y</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">Y</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">Y</entry>
+<entry colname="col_time">Y</entry>
+<entry colname="col_timestamp">Y</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">Y</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">Y</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">Y</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">CHAR FOR BIT DATA</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">Y</entry>
-<entry colname="colspec4">Y</entry>
-<entry colname="colspec3">Y</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">Y</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">Y</entry>
+<entry colname="col_varcharforbitdata">Y</entry>
+<entry colname="col_longvarcharforbitdata">Y</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">Y</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">VARCHAR FOR BIT DATA</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">Y</entry>
-<entry colname="colspec4">Y</entry>
-<entry colname="colspec3">Y</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">Y</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">Y</entry>
+<entry colname="col_varcharforbitdata">Y</entry>
+<entry colname="col_longvarcharforbitdata">Y</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">Y</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR FOR BIT DATA</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">Y</entry>
-<entry colname="colspec4">Y</entry>
-<entry colname="colspec3">Y</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">Y</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">Y</entry>
+<entry colname="col_varcharforbitdata">Y</entry>
+<entry colname="col_longvarcharforbitdata">Y</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">Y</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">CLOB</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">Y</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">Y</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">Y</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">Y</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">Y</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">BLOB</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">Y</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">Y</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">DATE</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">Y</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">Y</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">TIME</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">Y</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">Y</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">TIMESTAMP</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">Y</entry>
-<entry colname="colspec7">Y</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">Y</entry>
-<entry colname="colspec12">Y</entry>
-<entry colname="colspec11">Y</entry>
-<entry colname="COLSPEC14">-</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">Y</entry>
+<entry colname="col_varchar">Y</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">Y</entry>
+<entry colname="col_time">Y</entry>
+<entry colname="col_timestamp">Y</entry>
+<entry colname="col_xml">-</entry>
</row>
<row>
<entry colname="colspec0">XML</entry>
-<entry colname="col2">-</entry>
-<entry colname="col3">-</entry>
-<entry colname="col4">-</entry>
-<entry colname="col5">-</entry>
-<entry colname="col6">-</entry>
-<entry colname="colspec1">-</entry>
-<entry colname="colspec9">-</entry>
-<entry colname="colspec8">-</entry>
-<entry colname="colspec7">-</entry>
-<entry colname="colspec6">-</entry>
-<entry colname="colspec5">-</entry>
-<entry colname="colspec4">-</entry>
-<entry colname="colspec3">-</entry>
-<entry colname="colspec2">-</entry>
-<entry colname="colspec10">-</entry>
-<entry colname="colspec13">-</entry>
-<entry colname="colspec12">-</entry>
-<entry colname="colspec11">-</entry>
-<entry colname="COLSPEC14">Y</entry>
+<entry colname="col_boolean">-</entry>
+<entry colname="col_smallint">-</entry>
+<entry colname="col_integer">-</entry>
+<entry colname="col_bigint">-</entry>
+<entry colname="col_decimal">-</entry>
+<entry colname="col_real">-</entry>
+<entry colname="col_double">-</entry>
+<entry colname="col_float">-</entry>
+<entry colname="col_char">-</entry>
+<entry colname="col_varchar">-</entry>
+<entry colname="col_longvarchar">-</entry>
+<entry colname="col_charforbitdata">-</entry>
+<entry colname="col_varcharforbitdata">-</entry>
+<entry colname="col_longvarcharforbitdata">-</entry>
+<entry colname="col_clob">-</entry>
+<entry colname="col_blob">-</entry>
+<entry colname="col_date">-</entry>
+<entry colname="col_time">-</entry>
+<entry colname="col_timestamp">-</entry>
+<entry colname="col_xml">Y</entry>
</row>
</tbody>
</tgroup>
@@ -640,16 +700,23 @@ L</lines></entry>
between the source and target types might cause runtime errors.</p> </section>
<section><title>Notes</title> <p>In this discussion, the <ph conref="../conrefs.dita#prod/productshortname"></ph> SQL-92
data types are categorized as follows: <ul>
-<li><i>numeric</i> <ul>
-<li>Exact numeric (<xref href="rrefsqlj16221.dita#rrefsqlj16221">SMALLINT</xref>,
-<xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>,
-<xref href="rrefsqlj30435.dita#rrefsqlj30435">BIGINT</xref>,
-<xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref>,
-<xref href="rrefsqlj12362.dita#rrefsqlj12362">NUMERIC</xref>)</li>
-<li>Approximate numeric (<xref href="rrefsqlj27281.dita#rrefsqlj27281">FLOAT</xref>,
-<xref href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref>,
-<xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE PRECISION</xref>)</li>
-</ul></li>
+<li><i>logical</i>
+ <ul>
+ <li><xref href="rrefsqljBoolean.dita#rrefsqljBoolean">BOOLEAN</xref></li>
+ </ul>
+</li>
+<li><i>numeric</i>
+ <ul>
+ <li>Exact numeric (<xref href="rrefsqlj16221.dita#rrefsqlj16221">SMALLINT</xref>,
+ <xref href="rrefsqlj10696.dita#rrefsqlj10696">INTEGER</xref>,
+ <xref href="rrefsqlj30435.dita#rrefsqlj30435">BIGINT</xref>,
+ <xref href="rrefsqlj15260.dita#rrefsqlj15260">DECIMAL</xref>,
+ <xref href="rrefsqlj12362.dita#rrefsqlj12362">NUMERIC</xref>)</li>
+ <li>Approximate numeric (<xref href="rrefsqlj27281.dita#rrefsqlj27281">FLOAT</xref>,
+ <xref href="rrefsqlj14122.dita#rrefsqlj14122">REAL</xref>,
+ <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE PRECISION</xref>)</li>
+ </ul>
+</li>
<li><i>string</i> <ul>
<li>Character string (<xref href="rrefclob.dita#rrefclob">CLOB</xref>,
<xref href="rrefsqlj13733.dita#rrefsqlj13733">CHAR</xref>,
@@ -666,6 +733,15 @@ data types are categorized as follows:
<li><xref href="rrefsqlj27620.dita#rrefsqlj27620">TIMESTAMP</xref></li>
</ul></li>
</ul></p> </section>
+<section><title>Conversions to and from logical types</title>
+<p>
+A BOOLEAN value can be cast explicitly to any of the string types. The result is
+'true', 'false', or null.
+Conversely, string types
+can be cast to BOOLEAN. However, an error is raised if the string value is not
+'true', 'false', 'unknown', or null. Casting 'unknown' to boolean results in a null value.
+</p>
+</section>
<section><title>Conversions from numeric types</title> <p>A numeric type can
be converted to any other numeric type. If the target type cannot represent
the non-fractional component without truncation, an exception is raised. If
@@ -676,7 +752,7 @@ For example, casting 763.1234 as INTEGER
can be converted to other bit strings, but not character strings. Strings
that are converted to bit strings are padded with trailing zeros to fit the
size of the target bit string. The BLOB type is more limited and requires
-explicit casting. In most cases the BLOB type cannot be casted to and from
+explicit casting. In most cases the BLOB type cannot be cast to and from
other types.</p> </section>
<section id="sqlj75614"><title>Conversions of date/time values</title> <p>A
date/time value can always be converted to and from a TIMESTAMP. If a DATE
Modified: db/derby/docs/trunk/src/ref/rrefsqlj58560.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj58560.dita?rev=1002785&r1=1002784&r2=1002785&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj58560.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj58560.dita Wed Sep 29 17:44:36 2010
@@ -29,20 +29,39 @@ limitations under the License.
<table><title>Assignments allowed by <ph conref="../conrefs.dita#prod/productshortname"></ph></title>
<desc>This table displays valid assignments between data types in <ph conref="../conrefs.dita#prod/productshortname"></ph>.
A "Y" indicates that the assignment is valid.</desc>
-<tgroup cols="20"><colspec colname="colspec0" colwidth="350*"/><colspec colname="col2"
-colwidth="84*"/><colspec colname="col3" colwidth="84*"/><colspec colname="col4"
-colwidth="84*"/><colspec colname="col5" colwidth="84*"/><colspec colname="col6"
-colwidth="81*"/><colspec colname="colspec1" colwidth="84*"/><colspec colname="colspec9"
-colwidth="84*"/><colspec colname="colspec8" colwidth="84*"/><colspec colname="colspec7"
-colwidth="84*"/><colspec colname="colspec6" colwidth="81*"/><colspec colname="colspec5"
-colwidth="84*"/><colspec colname="colspec4" colwidth="87*"/><colspec colname="colspec3"
-colwidth="81*"/><colspec colname="colspec2" colwidth="84*"/><colspec colname="colspec10"
-colwidth="84*"/><colspec colname="colspec13" colwidth="84*"/><colspec colname="colspec12"
-colwidth="84*"/><colspec colname="colspec11" colwidth="84*"/><colspec colname="COLSPEC14"
-colwidth="84*"/><colspec colname="colspec15" colwidth="84*"/>
+<tgroup cols="20">
+<colspec colname="colspec0" colwidth="350*"/>
+<colspec colname="colbool" colwidth="84*"/>
+<colspec colname="col2" colwidth="84*"/>
+<colspec colname="col3" colwidth="84*"/>
+<colspec colname="col4" colwidth="84*"/>
+<colspec colname="col5" colwidth="84*"/>
+<colspec colname="col6" colwidth="81*"/>
+<colspec colname="colspec1" colwidth="84*"/>
+<colspec colname="colspec9" colwidth="84*"/>
+<colspec colname="colspec8" colwidth="84*"/>
+<colspec colname="colspec7" colwidth="84*"/>
+<colspec colname="colspec6" colwidth="81*"/>
+<colspec colname="colspec5" colwidth="84*"/>
+<colspec colname="colspec4" colwidth="87*"/>
+<colspec colname="colspec3" colwidth="81*"/>
+<colspec colname="colspec2" colwidth="84*"/>
+<colspec colname="colspec10" colwidth="84*"/>
+<colspec colname="colspec13" colwidth="84*"/>
+<colspec colname="colspec12" colwidth="84*"/>
+<colspec colname="colspec11" colwidth="84*"/>
+<colspec colname="COLSPEC14" colwidth="84*"/>
+<colspec colname="colspec15" colwidth="84*"/>
<thead>
<row>
<entry colname="colspec0" valign="top">Types</entry>
+<entry colname="col2" valign="top"> <lines>B
+O
+O
+L
+E
+A
+N</lines></entry>
<entry colname="col2" valign="top"> <lines>S
M
A
@@ -220,7 +239,32 @@ e</lines></entry>
</thead>
<tbody>
<row>
-<entry colname="colspec0">SMALL INT</entry>
+<entry colname="colspec0">BOOLEAN</entry>
+<entry colname="colbool">Y</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC14">-</entry>
+<entry colname="colspec15">-</entry>
+</row>
+<row>
+<entry colname="colspec0">SMALLINT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -244,6 +288,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">INTEGER</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -267,6 +312,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">BIGINT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -290,6 +336,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DECIMAL</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -313,6 +360,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">REAL</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -336,6 +384,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DOUBLE</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -359,6 +408,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">FLOAT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -382,6 +432,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -405,6 +456,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">VARCHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -428,6 +480,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -451,6 +504,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -474,6 +528,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">VARCHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -497,6 +552,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -520,6 +576,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CLOB</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -543,6 +600,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">BLOB</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -566,6 +624,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DATE</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -589,6 +648,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">TIME</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -612,6 +672,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">TIMESTAMP</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -635,6 +696,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">XML</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -658,6 +720,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">User-defined type</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -688,20 +751,39 @@ allowed.</p></section>
<table><title>Comparisons allowed by Derby</title><desc>This table displays
valid comparisons between data types in <ph conref="../conrefs.dita#prod/productshortname"></ph>.
A "Y" indicates that the comparison is allowed.</desc>
-<tgroup cols="20"><colspec colname="colspec0" colwidth="350*"/><colspec colname="col2"
-colwidth="83*"/><colspec colname="col3" colwidth="83*"/><colspec colname="col4"
-colwidth="83*"/><colspec colname="col5" colwidth="83*"/><colspec colname="col6"
-colwidth="80*"/><colspec colname="colspec1" colwidth="83*"/><colspec colname="colspec9"
-colwidth="83*"/><colspec colname="colspec8" colwidth="83*"/><colspec colname="colspec7"
-colwidth="83*"/><colspec colname="colspec6" colwidth="80*"/><colspec colname="colspec5"
-colwidth="83*"/><colspec colname="colspec4" colwidth="86*"/><colspec colname="colspec3"
-colwidth="80*"/><colspec colname="colspec2" colwidth="83*"/><colspec colname="colspec10"
-colwidth="83*"/><colspec colname="colspec13" colwidth="75*"/><colspec colname="colspec12"
-colwidth="89*"/><colspec colname="colspec11" colwidth="89*"/><colspec colname="COLSPEC15"
-colwidth="89*"/><colspec colname="colspec14" colwidth="80*"/>
+<tgroup cols="20">
+<colspec colname="colspec0" colwidth="350*"/>
+<colspec colname="colbool" colwidth="83*"/>
+<colspec colname="col2" colwidth="83*"/>
+<colspec colname="col3" colwidth="83*"/>
+<colspec colname="col4" colwidth="83*"/>
+<colspec colname="col5" colwidth="83*"/>
+<colspec colname="col6" colwidth="80*"/>
+<colspec colname="colspec1" colwidth="83*"/>
+<colspec colname="colspec9" colwidth="83*"/>
+<colspec colname="colspec8" colwidth="83*"/>
+<colspec colname="colspec7" colwidth="83*"/>
+<colspec colname="colspec6" colwidth="80*"/>
+<colspec colname="colspec5" colwidth="83*"/>
+<colspec colname="colspec4" colwidth="86*"/>
+<colspec colname="colspec3" colwidth="80*"/>
+<colspec colname="colspec2" colwidth="83*"/>
+<colspec colname="colspec10" colwidth="83*"/>
+<colspec colname="colspec13" colwidth="75*"/>
+<colspec colname="colspec12" colwidth="89*"/>
+<colspec colname="colspec11" colwidth="89*"/>
+<colspec colname="COLSPEC15" colwidth="89*"/>
+<colspec colname="colspec14" colwidth="80*"/>
<thead>
<row>
<entry colname="colspec0" valign="top">Types</entry>
+<entry colname="col2" valign="top"> <lines>B
+O
+O
+L
+E
+A
+N</lines></entry>
<entry colname="col2" valign="top"> <lines>S
M
A
@@ -879,7 +961,32 @@ e</lines></entry>
</thead>
<tbody>
<row>
-<entry colname="colspec0">SMALL INT</entry>
+<entry colname="colspec0">BOOLEAN</entry>
+<entry colname="colbool">Y</entry>
+<entry colname="col2">-</entry>
+<entry colname="col3">-</entry>
+<entry colname="col4">-</entry>
+<entry colname="col5">-</entry>
+<entry colname="col6">-</entry>
+<entry colname="colspec1">-</entry>
+<entry colname="colspec9">-</entry>
+<entry colname="colspec8">-</entry>
+<entry colname="colspec7">-</entry>
+<entry colname="colspec6">-</entry>
+<entry colname="colspec5">-</entry>
+<entry colname="colspec4">-</entry>
+<entry colname="colspec3">-</entry>
+<entry colname="colspec2">-</entry>
+<entry colname="colspec10">-</entry>
+<entry colname="colspec13">-</entry>
+<entry colname="colspec12">-</entry>
+<entry colname="colspec11">-</entry>
+<entry colname="COLSPEC15">-</entry>
+<entry colname="colspec14">-</entry>
+</row>
+<row>
+<entry colname="colspec0">SMALLINT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -899,9 +1006,11 @@ e</lines></entry>
<entry colname="colspec12">-</entry>
<entry colname="colspec11">-</entry>
<entry colname="COLSPEC15">-</entry>
+<entry colname="colspec14">-</entry>
</row>
<row>
<entry colname="colspec0">INTEGER</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -921,9 +1030,11 @@ e</lines></entry>
<entry colname="colspec12">-</entry>
<entry colname="colspec11">-</entry>
<entry colname="COLSPEC15">-</entry>
+<entry colname="colspec14">-</entry>
</row>
<row>
<entry colname="colspec0">BIGINT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -947,6 +1058,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DECIMAL</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -970,6 +1082,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">REAL</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -993,6 +1106,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DOUBLE</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -1016,6 +1130,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">FLOAT</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">Y</entry>
<entry colname="col3">Y</entry>
<entry colname="col4">Y</entry>
@@ -1039,6 +1154,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1062,6 +1178,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">VARCHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1085,6 +1202,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1108,6 +1226,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1131,6 +1250,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">VARCHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1154,6 +1274,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">LONG VARCHAR FOR BIT DATA</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1177,6 +1298,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">CLOB</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1200,6 +1322,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">BLOB</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1223,6 +1346,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">DATE</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1246,6 +1370,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">TIME</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1269,6 +1394,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">TIMESTAMP</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1292,6 +1418,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">XML</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
@@ -1315,6 +1442,7 @@ e</lines></entry>
</row>
<row>
<entry colname="colspec0">User-defined type</entry>
+<entry colname="colbool">-</entry>
<entry colname="col2">-</entry>
<entry colname="col3">-</entry>
<entry colname="col4">-</entry>
Added: db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita?rev=1002785&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita Wed Sep 29 17:44:36 2010
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+-->
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rrefsqljBoolean" xml:lang="en-us">
+<title>BOOLEAN data type</title>
+<prolog><metadata>
+<keywords><indexterm>BOOLEAN data type</indexterm></keywords>
+</metadata></prolog>
+
+<refbody>
+
+<section> <p>BOOLEAN provides 1 byte of storage for logical values.</p></section>
+
+<refsyn><title>Syntax</title> <codeblock><b>BOOLEAN</b></codeblock> </refsyn>
+
+<section><title>Corresponding compile-time Java type</title> <p><i>java.lang.Boolean</i></p> </section>
+
+<section><title>JDBC metadata type (java.sql.Types)</title> <p>BOOLEAN</p> </section>
+
+<section><title>Legal values</title>
+<p>
+The legal values are <i>true</i>, <i>false</i>, and <i>null</i>. BOOLEAN values can be cast to and from character typed values.
+For comparisons and ordering operations, <i>true</i> sorts higher than <i>false</i>.
+</p>
+</section>
+
+<example>
+<title>Examples</title>
+<codeblock><b>
+values true
+values false
+values cast (null as boolean)
+</b></codeblock>
+</example>
+
+</refbody>
+</reference>
+
Propchange: db/derby/docs/trunk/src/ref/rrefsqljBoolean.dita
------------------------------------------------------------------------------
svn:eol-style = native