Hi,

Do you think it is reasonable for the following statement to fail?
    select 1 from dual where 'a'=1

The exception is:
   Data conversion error converting a; SQL statement:
   select 1 from dual where 'a'=1 [90021-107] 90021/90021

I see two reasons why this is not appropriate:
1) unclear why to convert 'a' to int rather then 1 to varchar
2) other databases (I checked mysql) run such a statement without
error

Regards,
Jacek

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to