> When the second part is non-number string. Did you mean something like: select 1 + 'aaa' from dual
The above example will fail anyway, when we are trying to add a number and string. In oracle, executing the above query gives: ORA-01722: invalid number Did you mean in other databases the above query expects 1aaa as output? On Thursday, June 28, 2012 11:48:43 AM UTC-4, Noel Grandin wrote: > > > On 2012-06-28 17:14, Vinod wrote: > > I have made the following change in Operation.optimize(Session > > session), and it is working fine now. > > > > The change is to consider datatype as DECIMAL when: > > a) one side is integer and other is unknown (1 + ?) > > > This part is likely to break other places where the second part is a > non-number string, because they tend to expect the result to be a string. > So I don't think this patch is acceptable as is. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/IXeqJmXSqgUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
