/ 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
[a673e376] part of check-in [aa2ee575] Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines. (check-in: [aa2ee575] user: drh branch: trunk, size: 4433)
2009-02-03
13:10
[18f57c4c] part of check-in [cd2e7f6c] 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: [cd2e7f6c] user: drh branch: trunk, size: 4476)
2009-02-02
16:32
[c23b8417] part of check-in [5fc125d3] Update the SUBSTR function so that works consistently when the 2nd parameter is 0. Ticket #3628. (CVS 6230) (check-in: [5fc125d3] user: drh branch: trunk, size: 4316)
2009-02-01
19:42
[d08879fe] part of check-in [779fce82] Fix SUBSTR() so that it returns NULL if any argument is NULL. Ticket #3626. (CVS 6228) (check-in: [779fce82] user: drh branch: trunk, size: 4316)
19:23
[ab7e08b4] part of check-in [2217339b] 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: [2217339b] user: drh branch: trunk, size: 3849)
2007-10-12
19:11
[4be572ac] part of check-in [4a807d48] Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579. (CVS 4486) (check-in: [4a807d48] user: drh branch: trunk, size: 3592)
2007-09-12
17:01
[d36c864a] part of check-in [c8405b15] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15] user: danielk1977 branch: trunk, size: 3116)
2007-05-15
01:13
Added: [9f26cfca] part of check-in [75d57308] The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) (check-in: [75d57308] user: drh branch: trunk, size: 3062)