1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski #ifndef _CONNECTIVITY_FILE_FSTRINGFUNCTIONS_HXX_ 25*b1cdbd2cSJim Jagielski #define _CONNECTIVITY_FILE_FSTRINGFUNCTIONS_HXX_ 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski #include "file/fcode.hxx" 28*b1cdbd2cSJim Jagielski #include "file/filedllapi.hxx" 29*b1cdbd2cSJim Jagielski 30*b1cdbd2cSJim Jagielski namespace connectivity 31*b1cdbd2cSJim Jagielski { 32*b1cdbd2cSJim Jagielski class OSQLParseNode; 33*b1cdbd2cSJim Jagielski namespace file 34*b1cdbd2cSJim Jagielski { 35*b1cdbd2cSJim Jagielski /** UCASE(str) 36*b1cdbd2cSJim Jagielski UPPER(str) 37*b1cdbd2cSJim Jagielski Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1): 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski > SELECT UCASE('Hej'); 40*b1cdbd2cSJim Jagielski -> 'HEJ' 41*b1cdbd2cSJim Jagielski 42*b1cdbd2cSJim Jagielski */ 43*b1cdbd2cSJim Jagielski class OOp_Upper : public OUnaryOperator 44*b1cdbd2cSJim Jagielski { 45*b1cdbd2cSJim Jagielski protected: 46*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 47*b1cdbd2cSJim Jagielski }; 48*b1cdbd2cSJim Jagielski 49*b1cdbd2cSJim Jagielski /** LCASE(str) 50*b1cdbd2cSJim Jagielski LOWER(str) 51*b1cdbd2cSJim Jagielski Returns the string str with all characters changed to lowercase according to the current character set mapping (the default is ISO-8859-1 Latin1): 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski > SELECT LCASE('QUADRATICALLY'); 54*b1cdbd2cSJim Jagielski -> 'quadratically' 55*b1cdbd2cSJim Jagielski 56*b1cdbd2cSJim Jagielski */ 57*b1cdbd2cSJim Jagielski class OOp_Lower : public OUnaryOperator 58*b1cdbd2cSJim Jagielski { 59*b1cdbd2cSJim Jagielski protected: 60*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 61*b1cdbd2cSJim Jagielski }; 62*b1cdbd2cSJim Jagielski 63*b1cdbd2cSJim Jagielski /** ASCII(str) 64*b1cdbd2cSJim Jagielski Returns the ASCII code value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL: 65*b1cdbd2cSJim Jagielski 66*b1cdbd2cSJim Jagielski > SELECT ASCII('2'); 67*b1cdbd2cSJim Jagielski -> 50 68*b1cdbd2cSJim Jagielski > SELECT ASCII(2); 69*b1cdbd2cSJim Jagielski -> 50 70*b1cdbd2cSJim Jagielski > SELECT ASCII('dx'); 71*b1cdbd2cSJim Jagielski -> 100 72*b1cdbd2cSJim Jagielski 73*b1cdbd2cSJim Jagielski */ 74*b1cdbd2cSJim Jagielski class OOp_Ascii : public OUnaryOperator 75*b1cdbd2cSJim Jagielski { 76*b1cdbd2cSJim Jagielski protected: 77*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 78*b1cdbd2cSJim Jagielski }; 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski /** LENGTH(str) 81*b1cdbd2cSJim Jagielski OCTET_LENGTH(str) 82*b1cdbd2cSJim Jagielski CHAR_LENGTH(str) 83*b1cdbd2cSJim Jagielski CHARACTER_LENGTH(str) 84*b1cdbd2cSJim Jagielski Returns the length of the string str: 85*b1cdbd2cSJim Jagielski 86*b1cdbd2cSJim Jagielski > SELECT LENGTH('text'); 87*b1cdbd2cSJim Jagielski -> 4 88*b1cdbd2cSJim Jagielski > SELECT OCTET_LENGTH('text'); 89*b1cdbd2cSJim Jagielski -> 4 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski */ 92*b1cdbd2cSJim Jagielski class OOp_CharLength : public OUnaryOperator 93*b1cdbd2cSJim Jagielski { 94*b1cdbd2cSJim Jagielski protected: 95*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 96*b1cdbd2cSJim Jagielski }; 97*b1cdbd2cSJim Jagielski 98*b1cdbd2cSJim Jagielski /** CHAR(N,...) 99*b1cdbd2cSJim Jagielski CHAR() interprets the arguments as integers and returns a string consisting of the characters given by the ASCII code values of those integers. NULL values are skipped: 100*b1cdbd2cSJim Jagielski 101*b1cdbd2cSJim Jagielski > SELECT CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')); 102*b1cdbd2cSJim Jagielski -> 'test' 103*b1cdbd2cSJim Jagielski > SELECT CHAR(77,77.3,'77.3'); 104*b1cdbd2cSJim Jagielski -> 'MMM' 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski */ 107*b1cdbd2cSJim Jagielski class OOp_Char : public ONthOperator 108*b1cdbd2cSJim Jagielski { 109*b1cdbd2cSJim Jagielski protected: 110*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 111*b1cdbd2cSJim Jagielski }; 112*b1cdbd2cSJim Jagielski 113*b1cdbd2cSJim Jagielski /** CONCAT(str1,str2,...) 114*b1cdbd2cSJim Jagielski Returns the string that results from concatenating the arguments. Returns NULL if any argument is NULL. May have more than 2 arguments. A numeric argument is converted to the equivalent string form: 115*b1cdbd2cSJim Jagielski 116*b1cdbd2cSJim Jagielski > SELECT CONCAT('OO', 'o', 'OO'); 117*b1cdbd2cSJim Jagielski -> 'OOoOO' 118*b1cdbd2cSJim Jagielski > SELECT CONCAT('OO', NULL, 'OO'); 119*b1cdbd2cSJim Jagielski -> NULL 120*b1cdbd2cSJim Jagielski > SELECT CONCAT(14.3); 121*b1cdbd2cSJim Jagielski -> '14.3' 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski */ 124*b1cdbd2cSJim Jagielski class OOp_Concat : public ONthOperator 125*b1cdbd2cSJim Jagielski { 126*b1cdbd2cSJim Jagielski protected: 127*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 128*b1cdbd2cSJim Jagielski }; 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski /** LOCATE(substr,str) 131*b1cdbd2cSJim Jagielski POSITION(substr IN str) 132*b1cdbd2cSJim Jagielski Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str: 133*b1cdbd2cSJim Jagielski 134*b1cdbd2cSJim Jagielski > SELECT LOCATE('bar', 'foobarbar'); 135*b1cdbd2cSJim Jagielski -> 4 136*b1cdbd2cSJim Jagielski > SELECT LOCATE('xbar', 'foobar'); 137*b1cdbd2cSJim Jagielski -> 0 138*b1cdbd2cSJim Jagielski LOCATE(substr,str,pos) 139*b1cdbd2cSJim Jagielski Returns the position of the first occurrence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str: 140*b1cdbd2cSJim Jagielski 141*b1cdbd2cSJim Jagielski > SELECT LOCATE('bar', 'foobarbar',5); 142*b1cdbd2cSJim Jagielski -> 7 143*b1cdbd2cSJim Jagielski 144*b1cdbd2cSJim Jagielski */ 145*b1cdbd2cSJim Jagielski class OOp_Locate : public ONthOperator 146*b1cdbd2cSJim Jagielski { 147*b1cdbd2cSJim Jagielski protected: 148*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 149*b1cdbd2cSJim Jagielski }; 150*b1cdbd2cSJim Jagielski 151*b1cdbd2cSJim Jagielski /** SUBSTRING(str,pos) 152*b1cdbd2cSJim Jagielski SUBSTRING(str FROM pos) 153*b1cdbd2cSJim Jagielski Returns a substring from string str starting at position pos: 154*b1cdbd2cSJim Jagielski 155*b1cdbd2cSJim Jagielski > SELECT SUBSTRING('Quadratically',5); 156*b1cdbd2cSJim Jagielski -> 'ratically' 157*b1cdbd2cSJim Jagielski > SELECT SUBSTRING('foobarbar' FROM 4); 158*b1cdbd2cSJim Jagielski -> 'barbar' 159*b1cdbd2cSJim Jagielski SUBSTRING(str,pos,len) 160*b1cdbd2cSJim Jagielski SUBSTRING(str FROM pos FOR len) 161*b1cdbd2cSJim Jagielski Returns a substring len characters long from string str, starting at position pos. The variant form that uses FROM is SQL-92 syntax: 162*b1cdbd2cSJim Jagielski 163*b1cdbd2cSJim Jagielski > SELECT SUBSTRING('Quadratically',5,6); 164*b1cdbd2cSJim Jagielski -> 'ratica' 165*b1cdbd2cSJim Jagielski 166*b1cdbd2cSJim Jagielski */ 167*b1cdbd2cSJim Jagielski class OOp_SubString : public ONthOperator 168*b1cdbd2cSJim Jagielski { 169*b1cdbd2cSJim Jagielski protected: 170*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 171*b1cdbd2cSJim Jagielski }; 172*b1cdbd2cSJim Jagielski 173*b1cdbd2cSJim Jagielski /** LTRIM(str) 174*b1cdbd2cSJim Jagielski Returns the string str with leading space characters removed: 175*b1cdbd2cSJim Jagielski 176*b1cdbd2cSJim Jagielski > SELECT LTRIM(' barbar'); 177*b1cdbd2cSJim Jagielski -> 'barbar' 178*b1cdbd2cSJim Jagielski 179*b1cdbd2cSJim Jagielski */ 180*b1cdbd2cSJim Jagielski class OOp_LTrim : public OUnaryOperator 181*b1cdbd2cSJim Jagielski { 182*b1cdbd2cSJim Jagielski protected: 183*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 184*b1cdbd2cSJim Jagielski }; 185*b1cdbd2cSJim Jagielski 186*b1cdbd2cSJim Jagielski /** RTRIM(str) 187*b1cdbd2cSJim Jagielski Returns the string str with trailing space characters removed: 188*b1cdbd2cSJim Jagielski 189*b1cdbd2cSJim Jagielski > SELECT RTRIM('barbar '); 190*b1cdbd2cSJim Jagielski -> 'barbar' 191*b1cdbd2cSJim Jagielski 192*b1cdbd2cSJim Jagielski */ 193*b1cdbd2cSJim Jagielski class OOp_RTrim : public OUnaryOperator 194*b1cdbd2cSJim Jagielski { 195*b1cdbd2cSJim Jagielski protected: 196*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 197*b1cdbd2cSJim Jagielski }; 198*b1cdbd2cSJim Jagielski 199*b1cdbd2cSJim Jagielski /** SPACE(N) 200*b1cdbd2cSJim Jagielski Returns a string consisting of N space characters: 201*b1cdbd2cSJim Jagielski 202*b1cdbd2cSJim Jagielski > SELECT SPACE(6); 203*b1cdbd2cSJim Jagielski -> ' ' 204*b1cdbd2cSJim Jagielski 205*b1cdbd2cSJim Jagielski */ 206*b1cdbd2cSJim Jagielski class OOp_Space : public OUnaryOperator 207*b1cdbd2cSJim Jagielski { 208*b1cdbd2cSJim Jagielski protected: 209*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs) const; 210*b1cdbd2cSJim Jagielski }; 211*b1cdbd2cSJim Jagielski 212*b1cdbd2cSJim Jagielski /** REPLACE(str,from_str,to_str) 213*b1cdbd2cSJim Jagielski Returns the string str with all occurrences of the string from_str replaced by the string to_str: 214*b1cdbd2cSJim Jagielski 215*b1cdbd2cSJim Jagielski > SELECT REPLACE('www.OOo.com', 'w', 'Ww'); 216*b1cdbd2cSJim Jagielski -> 'WwWwWw.OOo.com' 217*b1cdbd2cSJim Jagielski 218*b1cdbd2cSJim Jagielski */ 219*b1cdbd2cSJim Jagielski class OOp_Replace : public ONthOperator 220*b1cdbd2cSJim Jagielski { 221*b1cdbd2cSJim Jagielski protected: 222*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 223*b1cdbd2cSJim Jagielski }; 224*b1cdbd2cSJim Jagielski 225*b1cdbd2cSJim Jagielski /** REPEAT(str,count) 226*b1cdbd2cSJim Jagielski Returns a string consisting of the string str repeated count times. If count <= 0, returns an empty string. Returns NULL if str or count are NULL: 227*b1cdbd2cSJim Jagielski 228*b1cdbd2cSJim Jagielski > SELECT REPEAT('OOo', 3); 229*b1cdbd2cSJim Jagielski -> 'OOoOOoOOo' 230*b1cdbd2cSJim Jagielski 231*b1cdbd2cSJim Jagielski */ 232*b1cdbd2cSJim Jagielski class OOp_Repeat : public OBinaryOperator 233*b1cdbd2cSJim Jagielski { 234*b1cdbd2cSJim Jagielski protected: 235*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const; 236*b1cdbd2cSJim Jagielski }; 237*b1cdbd2cSJim Jagielski 238*b1cdbd2cSJim Jagielski /** INSERT(str,pos,len,newstr) 239*b1cdbd2cSJim Jagielski Returns the string str, with the substring beginning at position pos and len characters long replaced by the string newstr: 240*b1cdbd2cSJim Jagielski 241*b1cdbd2cSJim Jagielski > SELECT INSERT('Quadratic', 3, 4, 'What'); 242*b1cdbd2cSJim Jagielski -> 'QuWhattic' 243*b1cdbd2cSJim Jagielski 244*b1cdbd2cSJim Jagielski */ 245*b1cdbd2cSJim Jagielski class OOp_Insert : public ONthOperator 246*b1cdbd2cSJim Jagielski { 247*b1cdbd2cSJim Jagielski protected: 248*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ::std::vector<ORowSetValue>& lhs) const; 249*b1cdbd2cSJim Jagielski }; 250*b1cdbd2cSJim Jagielski 251*b1cdbd2cSJim Jagielski /** LEFT(str,len) 252*b1cdbd2cSJim Jagielski Returns the leftmost len characters from the string str: 253*b1cdbd2cSJim Jagielski 254*b1cdbd2cSJim Jagielski > SELECT LEFT('foobarbar', 5); 255*b1cdbd2cSJim Jagielski -> 'fooba' 256*b1cdbd2cSJim Jagielski 257*b1cdbd2cSJim Jagielski */ 258*b1cdbd2cSJim Jagielski class OOp_Left : public OBinaryOperator 259*b1cdbd2cSJim Jagielski { 260*b1cdbd2cSJim Jagielski protected: 261*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const; 262*b1cdbd2cSJim Jagielski }; 263*b1cdbd2cSJim Jagielski 264*b1cdbd2cSJim Jagielski /** RIGHT(str,len) 265*b1cdbd2cSJim Jagielski Returns the rightmost len characters from the string str: 266*b1cdbd2cSJim Jagielski 267*b1cdbd2cSJim Jagielski > SELECT RIGHT('foobarbar', 4); 268*b1cdbd2cSJim Jagielski -> 'rbar' 269*b1cdbd2cSJim Jagielski */ 270*b1cdbd2cSJim Jagielski class OOp_Right : public OBinaryOperator 271*b1cdbd2cSJim Jagielski { 272*b1cdbd2cSJim Jagielski protected: 273*b1cdbd2cSJim Jagielski virtual ORowSetValue operate(const ORowSetValue& lhs,const ORowSetValue& rhs) const; 274*b1cdbd2cSJim Jagielski }; 275*b1cdbd2cSJim Jagielski } 276*b1cdbd2cSJim Jagielski } 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski #endif // _CONNECTIVITY_FILE_FCODE_HXX_ 279*b1cdbd2cSJim Jagielski 280