Null and concat

Bart Pietercil bart.pietercil at gmail.com
Fri Oct 5 07:03:46 CDT 2007


Hi List,

this example taken from the WIKI <http://www.valentina-db.com/ 
dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:expr:functions:strin 
g>
(and corrected Ruslan, the first ' is missing in the WIKI


SELECT CONCAT('Va’, NULL, ‘na’);

crashes VStudio

if I do

SELECT CONCAT('Va’, NULL)

I get unexpected token NULL.

Is concat broken (and is this the reason my unique constraints are  
not working) ???

Bart


More information about the Valentina mailing list