[#DERBY-499] Expose BOOLEAN datatype to end users

Derby

Expose BOOLEAN datatype to end users

Created: 09/Aug/05 03:45 AM Updated: 18/Sep/09 10:42 AM

Return to search

Component/s:

SQL

Affects Version/s:

10.1.1.0

Fix Version/s:

None

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
BooleanFS.html	2007-05-09 01:53 PM	Rick Hillegas	81 kB
BooleanFS.html	2005-12-03 07:55 AM	Rick Hillegas	8 kB
BooleanType.html	2006-09-29 05:39 PM	Rick Hillegas	30 kB
BooleanType.html	2006-05-17 11:47 PM	Rick Hillegas	30 kB
BooleanType.sxw	2006-09-29 02:03 PM	Rick Hillegas	12 kB
BooleanType.sxw	2006-05-17 11:43 PM	Rick Hillegas	12 kB
bug499.diff	2005-12-18 08:17 AM	Rick Hillegas	254 kB
bug499_doc.zip	2005-12-07 07:47 AM	Rick Hillegas	583 kB
bug499_jdk13tests.diff	2006-01-11 12:00 AM	Rick Hillegas	697 kB
bug499_jdk13tests_rev2.diff	2006-01-14 02:13 AM	Rick Hillegas	693 kB
bug499_rev2.diff	2005-12-21 03:35 AM	Rick Hillegas	254 kB
bug499_rev3.diff	2005-12-21 05:46 AM	Rick Hillegas	254 kB
bug499_rev4.diff	2005-12-21 09:23 AM	Rick Hillegas	254 kB
jdk131BooleanFailures.zip	2006-01-07 10:47 AM	Kathey Marsden	67 kB

Issue Links:

Blocker

This issue is blocked by:

~~DERBY-887~~ Select statement returns wrong number of rows if you compare an integer column with a boolean expression in the where clause

Dependants

This issue blocks:

DERBY-2651 Embedded and client behave differently for IJ command "show indexes"

Reference

This issue relates to:

~~DERBY-1029~~ Backout boolean work from the 10.2 branch immediately after the branch is created

Description

« Hide

Veaceslav Chicu started an email thread on 8 August 2005 titled "boolean type". He was disappointed that Derby doesn't support the ansi BOOLEAN datatype. On closer inspection, Derby does internally support this type but does not expose this support to end users.

Derby should let users declare table columns of type BOOLEAN. This should be an indexable datatype.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Repository	Revision	Date	User	Message
ASF	#358163	Wed Dec 21 00:53:42 UTC 2005	djd	DERBY-499 Add BOOLEAN datatype. See jira comments for details. Commit of patch bug499_rev4.diff, contributed by Rick Hillegas
				Files Changed
				MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/db2Compatibility.sql ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/default_app.properties MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/logop.sql MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/SignedBinary.java ADD /db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Types.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/FdocaConstants.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Cursor.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/compatibility/CompatibilitySuite.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/CrossConverters.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/AppRequester.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/schemas.sql MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/Typdef.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/util/DerbyJUnitTest.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/syscat.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/aggregate.sql MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/EXTDTAInputStream.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/SQLTypes.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/compatibility/testScript.xml MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/LangSuite.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/subquery.sql MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/FdocaConstants.java ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/valuesclause.out MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetConfiguration.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/DatabaseMetaData.java ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/build.xml MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetStatementRequest.java ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/BooleanTest.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/compatibility/JDBCDriverTest.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/NetworkServerControlImpl.java MODIFY /db/derby/code/trunk/java/testing/build.xml

Repository	Revision	Date	User	Message
ASF	#369956	Tue Jan 17 23:19:09 UTC 2006	fuzzylogic	DERBY-499: Fix metadata.java and syscat.sql in jdk131 vms. Committed for Rick Hillegas <richard.hillegas@sun.com>
				Files Changed
				MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/syscat.out MODIFY /db/derby/code/trunk/tools/release/build.xml MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/syscat.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/syscat.sql

Repository	Revision	Date	User	Message
ASF	#370583	Thu Jan 19 19:46:37 UTC 2006	fuzzylogic	DERBY-499: Add missed masters from previous checkin of bug499_jdk13_rev2.diff
				Files Changed
				ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/syscat.out ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out

Repository	Revision	Date	User	Message
ASF	#423976	Thu Jul 20 16:22:18 UTC 2006	rhillegas	~~DERBY-1029~~: Commit ~~DERBY-1029~~_v05.diff, backing out the BOOLEAN datatype introduced by DERBY-499.
				Files Changed
				MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/db2Compatibility.sql MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/default_app.properties MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/logop.sql MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/SignedBinary.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DRDAConstants.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/logop.out MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Types.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/DRDAConnThread.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/FdocaConstants.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/Cursor.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/CrossConverters.java MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/AppRequester.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/schemas.sql MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/Typdef.java MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbylang.runall MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/cast.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedureInTrigger.out MODIFY /db/derby/code/trunk/java/drda/org/apache/derby/impl/drda/SQLTypes.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/aggregate.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedureInTrigger.sql MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/LangSuite.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/valuesclause.out MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/DatabaseMetaData.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/build.xml MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/syscat.out MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/net/NetStatementRequest.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/lang/BooleanTest.java MODIFY /db/derby/code/trunk/java/client/org/apache/derby/client/am/ColumnMetaData.java MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/db2Compatibility.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk14/metadata.out MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/junitTests/compatibility/JDBCDriverTest.java MODIFY /db/derby/code/trunk/java/testing/build.xml