################################################################################
# t/partition_supported_sql_funcs_main.inc                                     #
#                                                                              #
# Purpose:                                                                     #
#  Tests around sql functions                                                  #
#                                                                              #
#                                                                              #
#------------------------------------------------------------------------------#
# Original Author: HH                                                          #
# Original Date: 2006-11-22                                                    #
# Change Author:                                                               #
# Change Date:                                                                 #
# Change:                                                                      #
################################################################################


let $sqlfunc = abs(col1);
let $valsqlfunc = abs(15);
let $coltype = int;
let $val1 =  5 ;
let $val2 = 13 ;
let $val3 = 17 ;
let $val4 = 15 ;
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = ascii(col1);
let $valsqlfunc = ascii('5');
let $coltype = char(1);
let $val1 =  '1';
let $val2 =  '9';
let $val3 =  '3';
let $val4 =  '8';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = cast(ceiling(col1) as signed integer);
let $valsqlfunc = cast(ceiling(15) as signed integer);
let $coltype = float(7,4);
let $val1 =  5.1230;
let $val2 = 13.345;
let $val3 = 17.987;
let $val4 = 15.654 ;
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = cast(floor(col1) as signed);
let $valsqlfunc = cast(floor(15.123) as signed);
let $coltype = float(7,4);
let $val1 =  5.1230;
let $val2 = 13.345;
let $val3 = 17.987;
let $val4 = 15.654 ;
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = cast(mod(col1,10) as signed);
let $valsqlfunc = cast(mod(15,10) as signed);
let $coltype = float(7,4);
let $val1 =  5.0000;
let $val2 = 19;
let $val3 = 17;
let $val4 = 15 ;
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = ord(col1);
let $valsqlfunc = ord('a');
let $coltype = char(3);
let $val1 =  '1';
let $val2 =  '9';
let $val3 =  '3';
let $val4 =  '8';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = day(col1);
let $valsqlfunc = day('2006-12-21');
let $coltype = date;
let $val1 =  '2006-02-03';
let $val2 =  '2006-01-17';
let $val3 =  '2006-01-25';
let $val4 =  '2006-02-05';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = dayofmonth(col1);
let $valsqlfunc = dayofmonth('2006-12-24');
let $coltype = date;
let $val1 =  '2006-02-03';
let $val2 =  '2006-01-17';
let $val3 =  '2006-01-25';
let $val4 =  '2006-02-05';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = dayofweek(col1);
let $valsqlfunc = dayofweek('2006-12-24');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-02-17';
let $val3 =  '2006-01-25';
let $val4 =  '2006-02-05';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = dayofyear(col1);
let $valsqlfunc = dayofyear('2006-12-25');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-01-17';
let $val3 =  '2006-02-25';
let $val4 =  '2006-02-05';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc
let $coltype = char(30);
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = extract(month from col1);
let $valsqlfunc = extract(year from '1998-11-23');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-02-17';
let $val3 =  '2006-01-25';
let $val4 =  '2006-02-05';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = hour(col1);
let $valsqlfunc = hour('18:30');
let $coltype = time;
let $val1 =  '09:09';
let $val2 =  '14:30';
let $val3 =  '21:59';
let $val4 =  '10:30';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = microsecond(col1);
let $valsqlfunc = microsecond('10:30:10.000010');
let $coltype = time;
let $val1 =  '09:09:15.000002';
let $val2 =  '04:30:01.000018';
let $val3 =  '00:59:22.000024';
let $val4 =  '05:30:34.000037';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = minute(col1);
let $valsqlfunc = minute('18:30');
let $coltype = time;
let $val1 =  '09:09:15';
let $val2 =  '14:30:45';
let $val3 =  '21:59:22';
let $val4 =  '10:24:23';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = second(col1);
let $valsqlfunc = second('18:30:14');
let $coltype = time;
let $val1 =  '09:09:09';
let $val2 =  '14:30:20';
let $val3 =  '21:59:22';
let $val4 =  '10:22:33';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc
let $coltype = char(30);
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = month(col1);
let $valsqlfunc = month('2006-10-14');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-12-17';
let $val3 =  '2006-05-25';
let $val4 =  '2006-11-06';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = quarter(col1);
let $valsqlfunc = quarter('2006-10-14');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-12-17';
let $val3 =  '2006-09-25';
let $val4 =  '2006-07-30';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = time_to_sec(col1)-(time_to_sec(col1)-20);
let $valsqlfunc = time_to_sec('18:30:14')-(time_to_sec('17:59:59'));
let $coltype = time;
let $val1 =  '09:09:15';
let $val2 =  '14:30:45';
let $val3 =  '21:59:22';
let $val4 =  '10:33:11';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = to_days(col1)-to_days('2006-01-01');
let $valsqlfunc = to_days('2006-02-02')-to_days('2006-01-01');
let $coltype = date;
let $val1 =  '2006-02-03';
let $val2 =  '2006-01-17';
let $val3 =  '2006-01-25';
let $val4 =  '2006-02-06';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = weekday(col1);
let $valsqlfunc = weekday('2006-10-14');
let $coltype = date;
let $val1 =  '2006-12-03';
let $val2 =  '2006-11-17';
let $val3 =  '2006-05-25';
let $val4 =  '2006-02-06';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = weekofyear(col1);
let $valsqlfunc = weekofyear('2006-02-14');
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-03-17';
let $val3 =  '2006-05-25';
let $val4 =  '2006-09-06';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = year(col1)-1990;
let $valsqlfunc = year('2005-10-14')-1990;
let $coltype = date;
let $val1 =  '1996-01-03';
let $val2 =  '2000-02-17';
let $val3 =  '2004-05-25';
let $val4 =  '2002-02-15';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc

let $sqlfunc = yearweek(col1)-200600;
let $valsqlfunc = yearweek('2006-10-14')-200600;
let $coltype = date;
let $val1 =  '2006-01-03';
let $val2 =  '2006-08-17';
let $val3 =  '2006-03-25';
let $val4 =  '2006-11-15';
--source suite/partitions/include/partition_supported_sql_funcs.inc
# --source include/partition_supported_sql_funcs.inc
