db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3662) Derby should support the SQL 2003 explict casting behavior
Date Mon, 05 May 2008 14:35:55 GMT
Derby should support the SQL 2003 explict casting behavior

                 Key: DERBY-3662
                 URL: https://issues.apache.org/jira/browse/DERBY-3662
             Project: Derby
          Issue Type: Improvement
            Reporter: Rick Hillegas

The "CAST function" section of the Derby Developer's Guide says that Derby supports the casts
which were legal in SQL 92. There are a number of casts which are legal in SQL 2003 which
Derby does not support. These include the casting of exact numerics to varchar and the casting
of inexact numerics to char and varchar. The SQL 2003 rules are defined in part 2 section
6.12 (<cast specification>). Derby should support the liberal 2003 casting behavior.
See for instance this user feedback from  Bogdan Calmac: http://www.nabble.com/Concatenating-two-numbers-as-a-string-td17036203.html#a17036203

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message