1connected 2 3-- TEST using SQLExecute after SQLPrepare 4 5Query: SELECT {fn CONCAT(?, ?) } 6Param 1: foo 7Param 2: bar 8Result set: 9foobar 10 11Query: SELECT {fn LOCATE(?, ?, 2) } 12Param 1: needle 13Param 2: this is a needle in an ol' haystack 14Result set: 1511 16 17Query: SELECT {fn LOCATE({fn SUBSTRING(?, 2, 4)}, {fn SUBSTRING(?, 3)}, 3) } 18Param 1: needle 19Param 2: this is a needle in an ol' haystack 20Result set: 2110 22 23Query: SELECT 'x' || {fn SPACE(10) } || 'x' 24Result set: 25x x 26 27Query: { call length(?) } 28Param 1: foobar 29Result set: 306 31 32Query: { call right(?, ?) } 33Param 1: foobar 34Param 2: 3 35Result set: 36bar 37 38Query: { ? = call length('foo') } 39Param 1 is an OUT parameter 40Result set: 41 42OUT param: 3 43 44Query: { ? = call concat(?::text, ?::text) } 45Param 1 is an OUT parameter 46Param 2: foo 47Param 3: bar 48Result set: 49 50OUT param: foobar 51 52Query: SELECT {d '2014-12-21' } + '1 day'::interval 53Result set: 542014-12-22 00:00:00 55 56Query: SELECT {t '20:30:40' } + '1 hour 1 minute 1 second'::interval 57Result set: 5821:31:41 59 60Query: SELECT {ts '2014-12-21 20:30:40' } + '1 day 1 hour 1 minute 1 second'::interval 61Result set: 622014-12-22 21:31:41 63 64Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 65Param 1 is an OUT parameter 66Param 2: 2017-02-23 11:34:46 67Param 3 is an I-O parameter 68Param 4: 3.4 69Param 5 is an OUT parameter 70Result set: 716.7999999999999998 7 2017-02-24 11:34:46 72OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 73 74Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 75Param 1 (e) is an OUT parameter 76Param 2 (a) is an OUT parameter 77Param 3 (b): 2017-02-23 11:34:46 78Param 4 (c) is an I-O parameter 79Param 5 (d): 3.4 80Result set: 816.7999999999999998 7 2017-02-24 11:34:46 82OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 83 84Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 85Param 1 (b): 2017-02-23 11:34:46 86Param 2 (c) is an I-O parameter 87Param 3 (d): 3.4 88Param 4 (e) is an OUT parameter 89Param 5 (a) is an OUT parameter 90Result set: 916.7999999999999998 7 2017-02-24 11:34:46 92OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 93 94-- TEST using SQLExecDirect 95 96Query: SELECT {fn CONCAT(?, ?) } 97Param 1: foo 98Param 2: bar 99Result set: 100foobar 101 102Query: SELECT {fn LOCATE(?, ?, 2) } 103Param 1: needle 104Param 2: this is a needle in an ol' haystack 105Result set: 10611 107 108Query: SELECT {fn LOCATE({fn SUBSTRING(?, 2, 4)}, {fn SUBSTRING(?, 3)}, 3) } 109Param 1: needle 110Param 2: this is a needle in an ol' haystack 111Result set: 11210 113 114Query: SELECT 'x' || {fn SPACE(10) } || 'x' 115Result set: 116x x 117 118Query: { call length(?) } 119Param 1: foobar 120Result set: 1216 122 123Query: { call right(?, ?) } 124Param 1: foobar 125Param 2: 3 126Result set: 127bar 128 129Query: { ? = call length('foo') } 130Param 1 is an OUT parameter 131Result set: 132 133OUT param: 3 134 135Query: { ? = call concat(?::text, ?::text) } 136Param 1 is an OUT parameter 137Param 2: foo 138Param 3: bar 139Result set: 140 141OUT param: foobar 142 143Query: SELECT {d '2014-12-21' } + '1 day'::interval 144Result set: 1452014-12-22 00:00:00 146 147Query: SELECT {t '20:30:40' } + '1 hour 1 minute 1 second'::interval 148Result set: 14921:31:41 150 151Query: SELECT {ts '2014-12-21 20:30:40' } + '1 day 1 hour 1 minute 1 second'::interval 152Result set: 1532014-12-22 21:31:41 154 155Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 156Param 1 is an OUT parameter 157Param 2: 2017-02-23 11:34:46 158Param 3 is an I-O parameter 159Param 4: 3.4 160Param 5 is an OUT parameter 161Result set: 1626.7999999999999998 7 2017-02-24 11:34:46 163OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 164 165Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 166Param 1 (e) is an OUT parameter 167Param 2 (a) is an OUT parameter 168Param 3 (b): 2017-02-23 11:34:46 169Param 4 (c) is an I-O parameter 170Param 5 (d): 3.4 171Result set: 1726.7999999999999998 7 2017-02-24 11:34:46 173OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 174 175Query: {call a_b_c_d_e(?, ?, ?, ?, ?)} 176Param 1 (b): 2017-02-23 11:34:46 177Param 2 (c) is an I-O parameter 178Param 3 (d): 3.4 179Param 4 (e) is an OUT parameter 180Param 5 (a) is an OUT parameter 181Result set: 1826.7999999999999998 7 2017-02-24 11:34:46 183OUT params: 6.7999999999999998 : 7 : 2017-02-24 11:34:46 184disconnecting 185