Documentation Source Text

File History
Login

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

History of pages/datatype3.in

2019-08-05
12:54
Update the documentation on the affinity of the columns of VIEWs and subqueries that are generated from expressions to match the actual implementation of 10 years standing - namely such columns have BLOB affinity, not no affinity. Ticket https://www.sqlite.org/src/info/d52a29a9e6bc55c5 file: [1a976e451e] check-in: [07b7749da8] user: drh branch: trunk, size: 28886
2019-06-12
20:31
Fix the description of how collation is computed to indicate that the collation is not blocked by a CAST operator. Fix for ticket https://www.sqlite.org/src/info/b148fa61059fb6c2. file: [c5c23cf259] check-in: [9f887f15e5] user: drh branch: trunk, size: 28798
2019-06-11
13:40
Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 file: [65bc4245f1] check-in: [e0f700bb6c] user: drh branch: trunk, size: 28776
02:59
Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb file: [9d0133cfcf] check-in: [722f0828b3] user: drh branch: trunk, size: 27707
02:51
State that the COLLATE operator does not change affinity. file: [9ef3cf1087] check-in: [5395fed295] user: drh branch: mistake, size: 27665
2019-04-08
18:06
Fix a minor error in the datatype documentation. file: [67ba148bbf] check-in: [a5590f5f81] user: drh branch: trunk, size: 27624
2017-01-18
02:41
Clarification of affinity, especially in regard to views and subqueries. file: [8546dd862c] check-in: [513684f098] user: drh branch: trunk, size: 27627
2017-01-12
20:25
Proposed enhancement to the definition of column affinity so that it covers columns belonging to subqueries and VIEWs. file: [bc4282442f] check-in: [524ba450fb] user: drh branch: trunk, size: 25778
2016-12-29
18:39
Update the cpu-usage graph and the change log. Minor wording improvements in the datatype documentation. file: [d80bf38958] check-in: [aa485be4f2] user: drh branch: trunk, size: 25251
2016-11-22
15:24
Discussion of bare columns in aggregate queries. file: [2a46811a54] check-in: [8a4f72ebf1] user: drh branch: trunk, size: 25279
2016-07-12
20:54
Updates to reflect changes in 3.14.0. The "expr" syntax diagram is changed to show the ability to put table-valued functions on the RHS of an IN operator. Related text changes. Update the change log. file: [021dd87ffd] check-in: [24cd5438cc] user: drh branch: trunk, size: 25241
2016-04-26
17:59
Add automatically generated tables of contents to rbu.html, cli.html and datatype3.html. file: [67a48600f5] check-in: [bd775e82aa] user: dan branch: trunk, size: 25239
2015-07-27
19:57
Fix typos in documentation found by requirements coverage testing. file: [fd66f70a51] check-in: [d7cc0cb1e0] user: drh branch: trunk, size: 25310
2015-06-02
17:24
Clarify the comparison affinity documentation. Change the name of NONE affinity to BLOB. Update the Makefile so that it works with Ubuntu 14.04LTS. file: [04a4423753] check-in: [9ba9e670e1] user: drh branch: trunk, size: 25326
2014-06-26
21:05
Fix a typo in datatype3.html and add a new bullet to clarify the affinity for the RHS of an IN or NOT IN operator. file: [f2de80308e] check-in: [e89c80cd7d] user: drh branch: trunk, size: 24993
2013-04-17
12:58
Add a documentation page describing how to write run-time loadable extensions. file: [90f5c84ede] check-in: [6da9f893bc] user: drh branch: trunk, size: 24788
2013-03-22
23:39
Fix a typo. file: [1e74f7746f] check-in: [349d556c0a] user: drh branch: trunk, size: 24766
2010-09-14
19:10
Adding additional comparison operators to the list in datatype3.html. file: [8320ed1131] check-in: [a43ee1e871] user: drh branch: trunk, size: 24765
13:25
Add <> to the list of comparison operators in datatype3.html. file: [5db41846d2] check-in: [838bd2b455] user: drh branch: trunk, size: 24729
2010-09-02
04:20
More typo fixes. file: [f9c497525f] check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 24723
2010-08-28
05:48
Fix documentation typos. file: [f9534ba9d1] check-in: [78fe166463] user: shaneh branch: trunk, size: 24727
2010-08-26
19:07
Changes to CAST expression documentation to make for more testable statements. file: [952a072a29] check-in: [6c20f79cbc] user: dan branch: trunk, size: 24728
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. file: [bdaf073235] check-in: [17093bc7d6] user: drh branch: trunk, size: 24674
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [dd18a23abc] check-in: [d9e242f92a] user: drh branch: trunk, size: 24004
14:30
Fix a typo in the datatype3.html document. file: [0418b08d7c] check-in: [9fec2f9dda] user: drh branch: trunk, size: 24003
2010-02-11
15:55
Fix typo in the datatype3.html document. file: [ffcad01d27] check-in: [d9afa1a3d7] user: drh branch: trunk, size: 24003
2010-01-01
14:46
Updates to the datatype3.html document to fix issues found while writing tests against that document. file: [340940899d] check-in: [490c97c96c] user: drh branch: trunk, size: 24002
2009-12-31
18:30
Fix incorrect documentation concerning affinity of UNION, INTERSECT, and EXCEPT. file: [59c24a45f5] check-in: [6fe30b1e8d] user: drh branch: trunk, size: 23164
14:47
Clarifications on affinity handling in the datatype3.html document. file: [460eb247aa] check-in: [e62a74f31a] user: drh branch: trunk, size: 23478
2009-12-30
18:17
The FLOATING POINT datatype has INTEGER affinity due to the "INT" at the end of "POINT". Make this clear in the datatype3.html documentation file. file: [63f3c0d0c6] check-in: [5c8750d0ff] user: drh branch: trunk, size: 23759
15:32
Fix some typos in datatype3.html. file: [93a6b160f6] check-in: [3da8351ec8] user: dan branch: trunk, size: 23568
2009-12-25
02:53
Additional refinements to the datatype3.html document. file: [d461aa6e03] check-in: [4737512960] user: drh branch: trunk, size: 23503
2009-12-24
21:37
Update and clarify the documentation on datatypes and on CAST expressions. file: [551b64a240] check-in: [e357f599e3] user: drh branch: trunk, size: 23496
16:02
Clarifications to the datatype3.html document. file: [6872ec243a] check-in: [75e2505670] user: drh branch: trunk, size: 18890
2009-12-14
23:00
Identify requirements in the autoinc.html and datatype3.html documents. Make corrections in datatype3.html for accuracy and for clearer presentation. file: [294b7cd3f0] check-in: [e18ce3ebd0] user: drh branch: trunk, size: 17986
2009-11-02
15:50
Added the website keyword index. file: [35c0cb06fa] check-in: [ec4a51db99] user: drh branch: trunk, size: 19791
2009-06-08
04:45
Update datatype3.html to mention that CAST expressions have an affinity. file: [4168bee88d] check-in: [0b44acac20] user: dan branch: trunk, size: 19673
2009-03-18
14:19
Fix typos in documentation. This is the fix for ticket [9ed3b9626c9462e11a557621152f3e2d4eead482] file: [054633f070] check-in: [cfa4627882] user: drh branch: trunk, size: 19010
2008-12-15
22:49
Attempt to do a better job of explaining INTEGER PRIMARY KEY. file: [3d3ff640f3] check-in: [47171588ec] user: drh branch: trunk, size: 19011
18:30
Enhanced documentation for INTEGER PRIMARY KEY. file: [6742c4b4b0] check-in: [a3dc852796] user: drh branch: trunk, size: 17743
2008-06-25
08:36
Fixed #1020. file: [4e49d39186] check-in: [391102d17f] user: mihailim branch: trunk, size: 17814
2008-04-27
17:51
Updates to the SQL language documentation with many added hyperlink targets. file: [074603963b] check-in: [f060763119] user: drh branch: trunk, size: 17802
2007-11-12
15:32
Complete reorganization of the documentation sources. file: [adc47b58e9] check-in: [275febef8f] user: drh branch: trunk, size: 17462 Added