diff options
| author | drh <> | 2024-10-08 10:10:42 +0000 |
|---|---|---|
| committer | drh <> | 2024-10-08 10:10:42 +0000 |
| commit | eaefd9ccc8cc73ecb17bdfceabcaff4d5285e837 (patch) | |
| tree | 9301f1ec78df6f944ca0b424b8f12233cfdb5b4f /src/func.c | |
| parent | 2813eb3c9e64a706fdec47b3075ab33f1013d2af (diff) | |
| parent | 7998b889e884b5752ac3c11da443022343ba1b8a (diff) | |
| download | sqlite-eaefd9ccc8cc73ecb17bdfceabcaff4d5285e837.tar.gz sqlite-eaefd9ccc8cc73ecb17bdfceabcaff4d5285e837.zip | |
Allow expressions with subtypes to be read from indexes unless they are
being used as direct or indirect parameters to SQLITE_SUBTYPE functions.
FossilOrigin-Name: 39a56a23fec24dd713905457b6d4ed7c148f88e325a26c376f1e6daf147c69c8
Diffstat (limited to 'src/func.c')
| -rw-r--r-- | src/func.c | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/func.c b/src/func.c index b17ffa52c..2de16b8aa 100644 --- a/src/func.c +++ b/src/func.c @@ -2706,7 +2706,8 @@ void sqlite3RegisterBuiltinFunctions(void){ WAGGREGATE(max, 1, 1, 1, minmaxStep, minMaxFinalize, minMaxValue, 0, SQLITE_FUNC_MINMAX|SQLITE_FUNC_ANYORDER ), FUNCTION2(typeof, 1, 0, 0, typeofFunc, SQLITE_FUNC_TYPEOF), - FUNCTION2(subtype, 1, 0, 0, subtypeFunc, SQLITE_FUNC_TYPEOF), + FUNCTION2(subtype, 1, 0, 0, subtypeFunc, + SQLITE_FUNC_TYPEOF|SQLITE_SUBTYPE), FUNCTION2(length, 1, 0, 0, lengthFunc, SQLITE_FUNC_LENGTH), FUNCTION2(octet_length, 1, 0, 0, bytelengthFunc,SQLITE_FUNC_BYTELEN), FUNCTION(instr, 2, 0, 0, instrFunc ), @@ -2812,7 +2813,7 @@ void sqlite3RegisterBuiltinFunctions(void){ MFUNCTION(sqrt, 1, sqrt, math1Func ), MFUNCTION(radians, 1, degToRad, math1Func ), MFUNCTION(degrees, 1, radToDeg, math1Func ), - FUNCTION(pi, 0, 0, 0, piFunc ), + MFUNCTION(pi, 0, 0, piFunc ), #endif /* SQLITE_ENABLE_MATH_FUNCTIONS */ FUNCTION(sign, 1, 0, 0, signFunc ), INLINE_FUNC(coalesce, -1, INLINEFUNC_coalesce, 0 ), |