ij> --
--   Licensed to the Apache Software Foundation (ASF) under one or more
--   contributor license agreements.  See the NOTICE file distributed with
--   this work for additional information regarding copyright ownership.
--   The ASF licenses this file to You under the Apache License, Version 2.0
--   (the "License"); you may not use this file except in compliance with
--   the License.  You may obtain a copy of the License at
--
--      http://www.apache.org/licenses/LICENSE-2.0
--
--   Unless required by applicable law or agreed to in writing, software
--   distributed under the License is distributed on an "AS IS" BASIS,
--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--   See the License for the specific language governing permissions and
--   limitations under the License.
--
-- this file contains any ejbql tests which produce an error which
-- includes a column number. The column number will change for SPS tests
-- so these tests can't be included in allAsSPS
-- absolute is not a reserved word any more
create table absolute( a int );
0 rows inserted/updated/deleted
ij> values{ fn abs( NULL ) };
ERROR 42X01: Syntax error: Encountered "NULL" at line 1, column 17.
ij> values{ fn abs( null ) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 17.
ij> values{ fn abs( ) };
ERROR 42X01: Syntax error: Encountered ")" at line 1, column 17.
ij> -- Error
values{ fn concat( ) };
ERROR 42X01: Syntax error: Encountered ")" at line 2, column 20.
ij> values{ fn concat( 'error0' ) };
ERROR 42X01: Syntax error: Encountered ")" at line 1, column 29.
ij> values  fn concat( 'syntax', ' error1' );
ERROR 42X01: Syntax error: Encountered "concat" at line 1, column 12.
ij> values{ fn concat { 'syntax', ' error2' }};
ERROR 42X01: Syntax error: Encountered "{" at line 1, column 19.
ij> values{ fn concat( 'syntax', ' error3' });
ERROR 42X01: Syntax error: Encountered "}" at line 1, column 40.
ij> values{ fn concat( fn concat( 'nested', ' not ' ), ' allowed!' ) };
ERROR 42X01: Syntax error: Encountered "concat" at line 1, column 23.
ij> values{ fn concat( values{ fn concat( 'nested', ' not ' ) }, ' allowed!' ) };
ERROR 42X01: Syntax error: Encountered "values" at line 1, column 20.
ij> values{ fn locate( null, null ) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 20.
ij> values{ fn locate( null, ''   ) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 20.
ij> values{ fn locate( '', null   ) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 24.
ij> values{ fn locate( null, null,1) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 20.
ij> values{ fn locate( null, ''  ,1) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 20.
ij> values{ fn locate( '', null  ,1) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 24.
ij> values{ fn sqrt( NULL ) };
ERROR 42X01: Syntax error: Encountered "NULL" at line 1, column 18.
ij> values{ fn sqrt( null ) };
ERROR 42X01: Syntax error: Encountered "null" at line 1, column 18.
ij> values{ fn sqrt( ) };
ERROR 42X01: Syntax error: Encountered ")" at line 1, column 18.
ij> -- Substring tests. Valid only as escaped function
values substring('asdf', 1);
ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed. 
ij> values substring(X'101101', 3);
ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed. 
ij> values substring('asdf', 1, 2);
ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed. 
ij> values {fn substring('asdf', 1)};
1   
----
asdf
ij> values {fn substring(X'101101', 3)};
ERROR 42X25: The 'SUBSTR' function is not allowed on the 'CHAR () FOR BIT DATA' type.
ij> values {fn substring('asdf', 1, 2)};
1   
----
as  
ij>