diff options
| author | unknown <venu@myvenu.com> | 2003-07-11 18:55:03 -0700 |
|---|---|---|
| committer | unknown <venu@myvenu.com> | 2003-07-11 18:55:03 -0700 |
| commit | a5ce6a49dd0dc782e225d24735b1af40ed8e3b18 (patch) | |
| tree | 46157d23bd0e0599894062a2dffc90255e304899 /sql/lex.h | |
| parent | 531a5d76bf5c38589df89985fa43b6a0d215b28e (diff) | |
| download | mariadb-git-a5ce6a49dd0dc782e225d24735b1af40ed8e3b18.tar.gz | |
Add the support of 'SUBSTR' function compatible with Oracle and SAPDB (SCRUM #872)
sql/lex.h:
Add SUBSTR aliased to SUBSTRING
sql/item_strfunc.cc:
Implement SUBSTR negative offset
mysql-test/t/func_str.test:
New tests for SUBSTR
mysql-test/r/func_str.result:
Updated SUBSTR results
Diffstat (limited to 'sql/lex.h')
| -rw-r--r-- | sql/lex.h | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/lex.h b/sql/lex.h index a148baad07f..c2860f4551a 100644 --- a/sql/lex.h +++ b/sql/lex.h @@ -627,6 +627,7 @@ static SYMBOL sql_functions[] = { { "STD", SYM(STD_SYM),0,0}, { "STDDEV", SYM(STD_SYM),0,0}, { "STRCMP", SYM(FUNC_ARG2),0,CREATE_FUNC(create_func_strcmp)}, + { "SUBSTR", SYM(SUBSTRING),0,0}, { "SUBSTRING", SYM(SUBSTRING),0,0}, { "SUBSTRING_INDEX", SYM(SUBSTRING_INDEX),0,0}, { "SUBTIME", SYM(FUNC_ARG2),0,CREATE_FUNC(create_func_subtime)}, |