Bugs item #2853458, was opened at 2009-09-07 12:03
Message generated for change (Tracker Item Submitted) made by skinkie
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2853458&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: cast exceeding maximum value, returns null

Initial Comment:
Should this be prevented? Or is a cast a cast?

>select cast(power(2,63) as bigint);
+----------------------+
| power_single_value   |
+======================+
|                 null |
+----------------------+
1 tuple
sql>select power(2,63);
+------------------------+
| power_single_value     |
+========================+
| 9.2233720368547758e+18 |
+------------------------+
1 tuple


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2853458&group_id=56967

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to