db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rich...@rswheeldon.com
Subject substring/concat/curdate/curtime
Date Sat, 02 Sep 2006 21:40:29 GMT

Are these supposed to work? They're declared in the grammar,
appear to have useful code associated with them, but none
of them seem to do anything:

ij> select substring('s',2) from simple_tab;
ERROR 42X01: Syntax error: Encountered "substring" at line 1, column 8.
ij> select substring('s',1,2) from simple_tab;
ERROR 42X01: Syntax error: Encountered "substring" at line 1, column 8.
ij> select concat('ab', 'cd') from simple_tab;
ERROR 42Y03: 'CONCAT' is not recognized as a function or procedure.
ij> select curtime() from simple_tab;
ERROR 42Y03: 'CURDATE' is not recognized as a function or procedure.
ij> select curtime() from simple_tab;
ERROR 42Y03: 'CURTIME' is not recognized as a function or procedure.
ij> 

I think this is possibly related to the previous issues with
the use of builtins in views,

Regards,

Richard


Mime
View raw message