SQLite Forum

Possible doc typos for upcoming release

Possible doc typos for upcoming release

(1) By Donald Griggs (dfgriggs) on 2022-01-12 17:01:27 [link]


I've bolded 3 words that may need attention.   

The 'auto' modifier can be used to work with date/time values even in cases where it is not __know__ if the 
julian day number __of__ unix timestamp formats are in use. The 'auto' modifier will automatically 
select the appropriate format. However, there is a region of ambiguity. 
Unix timestamps for the first 63 days of 1970 will be interpreted as julian day numbers. 
The 'auto' modifier is very useful __is__ the dataset is guaranteed to not contain any 
dates within that region, but should be avoided for applications that might make use of dates in the opening months of 1970.

Thanks as always for the work y'all do.

(2) By Donald Griggs (dfgriggs) on 2022-01-12 18:17:49 in reply to 1 [link]

More possible typos.


An argument with SQL type TEXT __it__ is normally converted into a quoted JSON string 
even if the input text is well-formed JSON.

4.10. The json_type() function

The json_type(X) function returns the "type" of the outermost element of X. 
The json_type(X,P) function returns the "type" of the element in X that is selected by path P. 
The "type" returned by json_type() is one of the following __an__ SQL text values: 'null', 'true', 'false', 'integer', 'real', 'text', 'array', or 'object'. 

[*__The words "array" and "object" are capitalized in section 4.8.  Maybe intentional?__*]

4.8. The json_patch() function
The json_patch(T,P) SQL function runs the RFC-7396 MergePatch algorithm to apply patch P against input T. The patched copy of T is returned.

MergePatch can add, modify, or delete elements of a JSON Object, and so for JSON Objects, the json_patch() routine is a generalized replacement for json_set() and json_remove(). However, MergePatch treats JSON Array objects as atomic. MergePatch cannot append to an Array nor modify individual elements of an Array. It can only insert, replace, or delete the whole Array as a single unit. Hence, json_patch() is not as useful when dealing with JSON that includes Arrays, especially Arrays with lots of substructure.

(3) By Larry Brasfield (larrybr) on 2022-01-12 20:51:26 in reply to 2

Your spelling/grammar pickups have been remedied. Thanks.

Regarding capitalized names: The terms Object and Array are from the JSON spec, and refer to a specific concept rather than carrying only their ordinary meaning. I don't know if they are properly proper nouns in the strictest grammatical sense, but they are close enough that we can borrow the capitalization convention for them. (We strive for clarity rather than worrying about the grammar police! (I to not imply that you are one of those.;-) )