[
http://tracker.firebirdsql.org/browse/CORE-5167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Leyne reopened CORE-5167:
------------------------------
> Automatic boolean values convertation with string concatenation
> ---------------------------------------------------------------
>
> Key: CORE-5167
> URL: http://tracker.firebirdsql.org/browse/CORE-5167
> Project: Firebird Core
> Issue Type: Bug
> Affects Versions: 3.0 RC2
> Reporter: Alex Bekhtin
>
> select '' || cast( 1 as SMALLINT ) from rdb$database;
> select '' || cast( 1 as INTEGER ) from rdb$database;
> select '' || cast( 1 as BIGINT ) from rdb$database;
> select '' || cast( TRUE as BOOLEAN ) from rdb$database; -- Overflow occurred
> during data type conversion.
> -- conversion error
> from string "BOOLEAN".
> select '' || cast( 1.1 as FLOAT ) from rdb$database;
> select '' || cast( 1.1 as DOUBLE PRECISION ) from rdb$database;
> select '' || cast( 1.1 as NUMERIC(3,3) ) from rdb$database;
> select '' || cast( 1.1 as DECIMAL(3,3) ) from rdb$database;
> select '' || cast( '2015-01-01' as DATE ) from rdb$database;
> select '' || cast( '10:51:59' as TIME ) from rdb$database;
> select '' || cast( '2015-01-01 10:51:59' as TIMESTAMP ) from rdb$database;
> select '' || cast( 'char text' as CHAR(20) ) from rdb$database;
> select '' || cast( 'varchar text' as VARCHAR(20) ) from rdb$database;
> select '' || cast( 'blob text' as BLOB ) from rdb$database;
> select cast( TRUE as varchar(20) ) from rdb$database; -- works fine
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
