SQLite

All files named ”test/substr.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/substr.test

2020-11-23
14:50
[a673e3763e] part of check-in [aa2ee5754c] Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines. (check-in: [aa2ee5754c] user: drh branch: trunk, size: 4433)
2009-02-03
13:10
[18f57c4ca8] part of check-in [cd2e7f6c0f] 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) (check-in: [cd2e7f6c0f] user: drh branch: trunk, size: 4476)
2009-02-02
16:32
[c23b841733] part of check-in [5fc125d362] Update the SUBSTR function so that works consistently when the 2nd parameter is 0. Ticket #3628. (CVS 6230) (check-in: [5fc125d362] user: drh branch: trunk, size: 4316)
2009-02-01
19:42
[d08879fe39] part of check-in [779fce82b7] Fix SUBSTR() so that it returns NULL if any argument is NULL. Ticket #3626. (CVS 6228) (check-in: [779fce82b7] user: drh branch: trunk, size: 4316)
19:23
[ab7e08b417] part of check-in [2217339bad] Fix the SUBSTR() function so that when the 3rd argument is negative, it counts backwards from the selected start point. Ticket #3625. (CVS 6227) (check-in: [2217339bad] user: drh branch: trunk, size: 3849)
2007-10-12
19:11
[4be572ac01] part of check-in [4a807d48ea] Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579. (CVS 4486) (check-in: [4a807d48ea] user: drh branch: trunk, size: 3592)
2007-09-12
17:01
[d36c864a23] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 3116)
2007-05-15
01:13
Added: [9f26cfca74] part of check-in [75d573080d] The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) (check-in: [75d573080d] user: drh branch: trunk, size: 3062)