plus/src/test/resources/sql/functions.iq

# 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.
#
!use CALCITE_AS_ADMIN
!set outputformat mysql

# Checks whether ASCONCATOFPARAMS function is properly computed and not passed to subschema, like jdbc
SELECT email, ASCONCATOFPARAMS(firstname, lastname) AS joined FROM SIMPLE_CUSTOMER limit 3;
+-----------------------+------------------------------+
| email                 | joined                       |
+-----------------------+------------------------------+
| ftremblay@gmail.com   | CONCAT = [François+Tremblay] |
| leonekohler@surfeu.de | CONCAT = [Leonie+Köhler]     |
| luisg@embraer.com.br  | CONCAT = [Luís+Gonçalves]    |
+-----------------------+------------------------------+
(3 rows)

!ok

# Checks whether CHOOSENCUSTOMFUNCTION function is properly computed and not passed to subschema, like jdbc
SELECT * FROM SIMPLE_CUSTOMER WHERE email = CHOSENCUSTOMEREMAIL();
+-----------+----------+---------------------+
| FirstName | LastName | Email               |
+-----------+----------+---------------------+
| François  | Tremblay | ftremblay@gmail.com |
+-----------+----------+---------------------+
(1 row)

!ok