Lines Matching refs:row
214 final XRow row = execute(xRowRes, "upper('test'),UCASE('test') "); in upper() local
215 assure("upper('test') failed!", row.getString(1).equals("TEST")); in upper()
216 assure("ucase('test') failed!", row.getString(2).equals("TEST")); in upper()
221 final XRow row = execute(xRowRes, "lower('TEST'),LCASE('TEST') "); in lower() local
222 assure("lower('TEST') failed!", row.getString(1).equals("test")); in lower()
223 assure("lcase('TEST') failed!", row.getString(2).equals("test")); in lower()
232 final XRow row = execute(xRowRes, "ASCII('2') "); in acsii() local
233 assure("acsii('2') failed!", row.getInt(1) == 50); in acsii()
238 …final XRow row = execute(xRowRes, "char_length('test'),character_length('test'),OCTET_LENGTH('test… in char_length() local
239 assure("char_length('test') failed!", row.getInt(1) == 4); in char_length()
240 assure("character_length('test') failed!", row.getInt(2) == 4); in char_length()
241 assure("OCTET_LENGTH('test') failed!", row.getInt(3) == 4); in char_length()
246 final XRow row = execute(xRowRes, "CONCAT('Hello',' ','World') "); in concat() local
247 assure("CONCAT('Hello',' ',,'World') failed!", row.getString(1).equals("Hello World")); in concat()
252 final XRow row = execute(xRowRes, "LOCATE('bar', 'foobarbar') "); in locate() local
253 assure("LOCATE('bar', 'foobarbar') failed!", row.getInt(1) == 4); in locate()
258 final XRow row = execute(xRowRes, "SUBSTRING('Quadratically',5) "); in substring() local
259 assure("SUBSTRING('Quadratically',5) failed!", row.getString(1).equals("ratically")); in substring()
264 final XRow row = execute(xRowRes, "LTRIM(' barbar') "); in ltrim() local
265 assure("LTRIM(' barbar') failed!", row.getString(1).equals("barbar")); in ltrim()
270 final XRow row = execute(xRowRes, "RTRIM('barbar ') "); in rtrim() local
271 assure("RTRIM('barbar ') failed!", row.getString(1).equals("barbar")); in rtrim()
276 final XRow row = execute(xRowRes, "space(6) "); in space() local
277 assure("space(6) failed!", row.getString(1).equals(" ")); in space()
282 final XRow row = execute(xRowRes, "REPLACE('www.OOo.com', 'w', 'Ww') "); in replace() local
283 … assure("REPLACE('www.OOo.com', 'w', 'Ww') failed!", row.getString(1).equals("WwWwWw.OOo.com")); in replace()
288 final XRow row = execute(xRowRes, "REPEAT('OOo', 3) "); in repeat() local
289 assure("REPEAT('OOo', 3) failed!", row.getString(1).equals("OOoOOoOOo")); in repeat()
294 final XRow row = execute(xRowRes, "INSERT('Quadratic', 3, 4, 'What') "); in insert() local
295 assure("INSERT('Quadratic', 3, 4, 'What') failed!", row.getString(1).equals("QuWhattic")); in insert()
300 final XRow row = execute(xRowRes, "LEFT('foobarbar', 5) "); in left() local
301 assure("LEFT('foobarbar', 5) failed!", row.getString(1).equals("fooba")); in left()
306 final XRow row = execute(xRowRes, "RIGHT('foobarbar', 4) "); in right() local
307 assure("RIGHT('foobarbar', 4) failed!", row.getString(1).equals("rbar")); in right()
312 final XRow row = execute(xRowRes, "CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) "); in chartest() local
313 …assure("CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) failed!", row.getString(1).equals("test"… in chartest()