drh
93d6a90fe9
Adjustments to the substr() function so that it can accommodate
...
ridiculous values for the second argument.
[bugs:/info/2026-09-20T18:42:27Z|Bug 2026-09-20T18:42:27Z]
FossilOrigin-Name: aadf42e021fc55d457836c7cda68f3d22dcaae72a7bbc105c3c727b3eb5c4657
2026-09-20 20:17:58 +00:00
drh
1335ec7df7
Allow "substring()" as an alias for "substr()" for compatibility with other
...
SQL engines.
FossilOrigin-Name: aa2ee5754c9f8378c4d490ca756a6415042904477727f0d86e9c0190b5e8b275
2020-11-23 14:50:43 +00:00
drh
478000cf5c
Check-in (6230) introduced a bugs in SUBSTR() which was caught by the fuzz
...
tester. Fixed by this check-in. Related to ticket #3628 . (CVS 6234)
FossilOrigin-Name: cd2e7f6c0fe4c0c648f8ca21388ab0769164f5ef
2009-02-03 13:10:54 +00:00
drh
65595cd60b
Update the SUBSTR function so that works consistently when the
...
2nd parameter is 0. Ticket #3628 . (CVS 6230)
FossilOrigin-Name: 5fc125d362df4b8525c7e1ab34a14f505756af24
2009-02-02 16:32:55 +00:00
drh
8198d25442
Fix SUBSTR() so that it returns NULL if any argument is NULL.
...
Ticket #3626 . (CVS 6228)
FossilOrigin-Name: 779fce82b7a89b972da488ce8bd35e23ca120c04
2009-02-01 19:42:37 +00:00
drh
4e79c59454
Fix the SUBSTR() function so that when the 3rd argument is negative,
...
it counts backwards from the selected start point. Ticket #3625 . (CVS 6227)
FossilOrigin-Name: 2217339badf1e84edbed1309c39b9f8dfd7646ff
2009-02-01 19:23:32 +00:00
drh
64f31519b7
Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579 . (CVS 4486)
...
FossilOrigin-Name: 4a807d48ea9923c1e3df4a5ad503710e62ae29f8
2007-10-12 19:11:55 +00:00
danielk1977
4152e677b8
Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423)
...
FossilOrigin-Name: c8405b15c074c94dab5e33272cf1471f458d11df
2007-09-12 17:01:45 +00:00
drh
f764e6fc3d
The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997)
...
FossilOrigin-Name: 75d573080d03ee48fe88710f70c6875ff9cae19c
2007-05-15 01:13:47 +00:00
