Hello, Today I found out that Oracle didn't follow the SQL-standard for string concatenation and thus creating unexpected behaviour in our application. I immediately tested this as well in other databases like SQL Server, PostgreSQL and H2. Both SQL Server and PostgreSQL work according the SQL-standard, but H2 also didn't follow the SQL- standard.
If you concatenate a NULL-value with a string, this should return NULL. H2 returns in this case a string, which is wrong according the SQL-standard. It is easy to test with this statement which should return null and not 'aap': select null || 'aap' Some more info about string concatenation in SQL: http://troels.arvin.dk/db/rdbms/#functions-concat Kind regards, Remco Schoen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
