aboutsummaryrefslogtreecommitdiff
path: root/src/func.c
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2020-11-23 14:50:43 +0000
committerdrh <drh@noemail.net>2020-11-23 14:50:43 +0000
commit1335ec7df76cc45f080bfdcfadcf06cf8a9a4b9f (patch)
tree5c21d9a6c1bf3ccd061931daad8d44eaa85bf2d4 /src/func.c
parent6a5e21149ba232b2eb01641dcac306c3fc693005 (diff)
downloadsqlite-1335ec7df76cc45f080bfdcfadcf06cf8a9a4b9f.tar.gz
sqlite-1335ec7df76cc45f080bfdcfadcf06cf8a9a4b9f.zip
Allow "substring()" as an alias for "substr()" for compatibility with other
SQL engines. FossilOrigin-Name: aa2ee5754c9f8378c4d490ca756a6415042904477727f0d86e9c0190b5e8b275
Diffstat (limited to 'src/func.c')
-rw-r--r--src/func.c2
1 files changed, 2 insertions, 0 deletions
diff --git a/src/func.c b/src/func.c
index 48b5f5f19..5d00c94a9 100644
--- a/src/func.c
+++ b/src/func.c
@@ -1995,6 +1995,8 @@ void sqlite3RegisterBuiltinFunctions(void){
FUNCTION(zeroblob, 1, 0, 0, zeroblobFunc ),
FUNCTION(substr, 2, 0, 0, substrFunc ),
FUNCTION(substr, 3, 0, 0, substrFunc ),
+ FUNCTION(substring, 2, 0, 0, substrFunc ),
+ FUNCTION(substring, 3, 0, 0, substrFunc ),
WAGGREGATE(sum, 1,0,0, sumStep, sumFinalize, sumFinalize, sumInverse, 0),
WAGGREGATE(total, 1,0,0, sumStep,totalFinalize,totalFinalize,sumInverse, 0),
WAGGREGATE(avg, 1,0,0, sumStep, avgFinalize, avgFinalize, sumInverse, 0),