Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for pages/datatype3.in
|
2022-04-12
| ||
| 00:22 | [f7b103ca24] part of check-in [bbba322a09] In datatypes explainer, note that "Determination of Column Affinity" section does not apply to STRICT tables. (check-in: [bbba322a09] user: larrybr branch: trunk, size: 31578) | |
|
2022-01-28
| ||
| 13:33 | [42d623b51c] part of check-in [b3ef2f0956] Resolve English parsing ambiguity in Affinity of Expressions (check-in: [b3ef2f0956] user: larrybr branch: trunk, size: 31541) | |
|
2022-01-20
| ||
| 23:31 | [bfc9c5b65b] part of check-in [921013da18] Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: [921013da18] user: drh branch: branch-3.37, size: 31494) | |
| 21:38 | [338ba417a7] part of check-in [96d1781d44] Grammar improvements where noted by https://sqlite.org/forum/forumpost/6712173dd2 (check-in: [96d1781d44] user: larrybr branch: trunk, size: 31541) | |
|
2022-01-08
| ||
| 05:17 | [62a495b836] part of check-in [fb1f0bd41b] In storage class/datatype explication, link the record format as available further detail. (check-in: [fb1f0bd41b] user: larrybr branch: mistake, size: 31540) | |
| 05:02 | [da69f1ec3b] part of check-in [bac82353db] Update integer encoding details for file format 4 Edit: Move this check-in accidentally sets the execute bit on all files. Moving it to a branch. (check-in: [bac82353db] user: larrybr branch: mistake, size: 31496) | |
|
2021-09-08
| ||
| 19:01 | [a6bed8150d] part of check-in [1d20e141ec] Another typo fix - this time in datatype3.html. (check-in: [1d20e141ec] user: drh branch: trunk, size: 31493) | |
|
2021-08-24
| ||
| 19:00 | [36176f64ce] part of check-in [d574ce1f35] More improvements to datatype documentation. (check-in: [d574ce1f35] user: drh branch: trunk, size: 31572) | |
| 14:31 | [f1280bd828] part of check-in [de16ee6a9e] First draft of a document defending flexible typing against its critics. (check-in: [de16ee6a9e] user: drh branch: trunk, size: 31577) | |
|
2021-08-20
| ||
| 15:27 | [9f6ed0efa0] part of check-in [0b842e6e48] First bits of documentation about STRICT tables. (check-in: [0b842e6e48] user: drh branch: strict-tables, size: 31421) | |
|
2021-06-02
| ||
| 14:34 | [84185262eb] part of check-in [3de5232216] Amplify the warning about mixing affinities in a compound SELECT by giving that paragraph its own heading and by adding a link to the recent bug report that was caused by this indeterminacy. (check-in: [3de5232216] user: drh branch: branch-3.35, size: 31073) | |
| 14:18 | [1e2b689d0f] part of check-in [9653e63b4c] Add a #fragment anchor to the paragraph on compound view affinities. (check-in: [9653e63b4c] user: dan branch: branch-3.35, size: 30856) | |
|
2020-10-04
| ||
| 00:24 | [422b8c12be] part of check-in [b19a0e3fa8] Clarifications on the behavior of the NUMERIC affinity and on the affinity of result columns in compound SELECT statements. (check-in: [b19a0e3fa8] user: drh branch: trunk, size: 30788) | |
|
2020-05-20
| ||
| 16:59 | [a17d837432] part of check-in [568e2f047e] An extra sentence of clarification on explicit collating sequences on an IN operator. (check-in: [568e2f047e] user: drh branch: trunk, size: 30077) | |
|
2020-03-06
| ||
| 00:13 | [b8d0625735] part of check-in [e751b0c91a] Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. (check-in: [e751b0c91a] user: drh branch: trunk, size: 29925) | |
|
2020-02-22
| ||
| 21:35 | [bc16277082] part of check-in [ea9656e7d7] Fix a typo in datatype3.html. (check-in: [ea9656e7d7] user: drh branch: trunk, size: 29745) | |
|
2020-01-08
| ||
| 11:12 | [2e6e579bc5] part of check-in [ba755cbcaa] Further clarification that collating functions only work on string values. (check-in: [ba755cbcaa] user: drh branch: branch-3.30, size: 29744) | |
|
2019-10-14
| ||
| 00:26 | [c65c05b0ab] part of check-in [3a3335a61e] Further clarification of automatic affinity conversion rules. (check-in: [3a3335a61e] user: drh branch: trunk, size: 29567) | |
| 00:20 | [56bbfab7fd] part of check-in [9840457b31] Clarification of the automatic conversion rules for inserting TEXT into a NUMERIC column. (check-in: [9840457b31] user: drh branch: trunk, size: 29210) | |
|
2019-08-29
| ||
| 17:19 | [6a6f0aedf4] part of check-in [a7856e4125] Add a description of NULLS FIRST and NULLS LAST. Add a note about the addition of sqlite3_drop_modules(). (check-in: [a7856e4125] user: drh branch: trunk, size: 28844) | |
|
2019-08-05
| ||
| 12:54 | [1a976e451e] part of check-in [07b7749da8] 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 (check-in: [07b7749da8] user: drh branch: trunk, size: 28886) | |
|
2019-06-12
| ||
| 20:31 | [c5c23cf259] part of check-in [9f887f15e5] 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. (check-in: [9f887f15e5] user: drh branch: trunk, size: 28798) | |
|
2019-06-11
| ||
| 13:40 | [65bc4245f1] part of check-in [e0f700bb6c] Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 (check-in: [e0f700bb6c] user: drh branch: trunk, size: 28776) | |
| 02:59 | [9d0133cfcf] part of check-in [722f0828b3] 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 (check-in: [722f0828b3] user: drh branch: trunk, size: 27707) | |
| 02:51 | [9ef3cf1087] part of check-in [5395fed295] State that the COLLATE operator does not change affinity. (check-in: [5395fed295] user: drh branch: mistake, size: 27665) | |
|
2019-04-08
| ||
| 18:06 | [67ba148bbf] part of check-in [a5590f5f81] Fix a minor error in the datatype documentation. (check-in: [a5590f5f81] user: drh branch: trunk, size: 27624) | |
|
2017-01-18
| ||
| 02:41 | [8546dd862c] part of check-in [513684f098] Clarification of affinity, especially in regard to views and subqueries. (check-in: [513684f098] user: drh branch: trunk, size: 27627) | |
|
2017-01-12
| ||
| 20:25 | [bc4282442f] part of check-in [524ba450fb] Proposed enhancement to the definition of column affinity so that it covers columns belonging to subqueries and VIEWs. (check-in: [524ba450fb] user: drh branch: trunk, size: 25778) | |
|
2016-12-29
| ||
| 18:39 | [d80bf38958] part of check-in [aa485be4f2] Update the cpu-usage graph and the change log. Minor wording improvements in the datatype documentation. (check-in: [aa485be4f2] user: drh branch: trunk, size: 25251) | |
|
2016-11-22
| ||
| 15:24 | [2a46811a54] part of check-in [8a4f72ebf1] Discussion of bare columns in aggregate queries. (check-in: [8a4f72ebf1] user: drh branch: trunk, size: 25279) | |
|
2016-07-12
| ||
| 20:54 | [021dd87ffd] part of check-in [24cd5438cc] 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. (check-in: [24cd5438cc] user: drh branch: trunk, size: 25241) | |
|
2016-04-26
| ||
| 17:59 | [67a48600f5] part of check-in [bd775e82aa] Add automatically generated tables of contents to rbu.html, cli.html and datatype3.html. (check-in: [bd775e82aa] user: dan branch: trunk, size: 25239) | |
|
2015-07-27
| ||
| 19:57 | [fd66f70a51] part of check-in [d7cc0cb1e0] Fix typos in documentation found by requirements coverage testing. (check-in: [d7cc0cb1e0] user: drh branch: trunk, size: 25310) | |
|
2015-06-02
| ||
| 17:24 | [04a4423753] part of check-in [9ba9e670e1] Clarify the comparison affinity documentation. Change the name of NONE affinity to BLOB. Update the Makefile so that it works with Ubuntu 14.04LTS. (check-in: [9ba9e670e1] user: drh branch: trunk, size: 25326) | |
|
2014-06-26
| ||
| 21:05 | [f2de80308e] part of check-in [e89c80cd7d] 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. (check-in: [e89c80cd7d] user: drh branch: trunk, size: 24993) | |
|
2013-04-17
| ||
| 12:58 | [90f5c84ede] part of check-in [6da9f893bc] Add a documentation page describing how to write run-time loadable extensions. (check-in: [6da9f893bc] user: drh branch: trunk, size: 24788) | |
|
2013-03-22
| ||
| 23:39 | [1e74f7746f] part of check-in [349d556c0a] Fix a typo. (check-in: [349d556c0a] user: drh branch: trunk, size: 24766) | |
|
2010-09-14
| ||
| 19:10 | [8320ed1131] part of check-in [a43ee1e871] Adding additional comparison operators to the list in datatype3.html. (check-in: [a43ee1e871] user: drh branch: trunk, size: 24765) | |
| 13:25 | [5db41846d2] part of check-in [838bd2b455] Add <> to the list of comparison operators in datatype3.html. (check-in: [838bd2b455] user: drh branch: trunk, size: 24729) | |
|
2010-09-02
| ||
| 04:20 | [f9c497525f] part of check-in [db66d3a1d4] More typo fixes. (check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 24723) | |
|
2010-08-28
| ||
| 05:48 | [f9534ba9d1] part of check-in [78fe166463] Fix documentation typos. (check-in: [78fe166463] user: shaneh branch: trunk, size: 24727) | |
|
2010-08-26
| ||
| 19:07 | [952a072a29] part of check-in [6c20f79cbc] Changes to CAST expression documentation to make for more testable statements. (check-in: [6c20f79cbc] user: dan branch: trunk, size: 24728) | |
|
2010-08-13
| ||
| 17:44 | [bdaf073235] part of check-in [17093bc7d6] Enhancements to the description of how the COLLATE operator works. (check-in: [17093bc7d6] user: drh branch: trunk, size: 24674) | |
|
2010-08-09
| ||
| 15:45 | [dd18a23abc] part of check-in [d9e242f92a] Fix a bunch of documentation typos reported on the mailing list. (check-in: [d9e242f92a] user: drh branch: trunk, size: 24004) | |
| 14:30 | [0418b08d7c] part of check-in [9fec2f9dda] Fix a typo in the datatype3.html document. (check-in: [9fec2f9dda] user: drh branch: trunk, size: 24003) | |
|
2010-02-11
| ||
| 15:55 | [ffcad01d27] part of check-in [d9afa1a3d7] Fix typo in the datatype3.html document. (check-in: [d9afa1a3d7] user: drh branch: trunk, size: 24003) | |
|
2010-01-01
| ||
| 14:46 | [340940899d] part of check-in [490c97c96c] Updates to the datatype3.html document to fix issues found while writing tests against that document. (check-in: [490c97c96c] user: drh branch: trunk, size: 24002) | |
|
2009-12-31
| ||
| 18:30 | [59c24a45f5] part of check-in [6fe30b1e8d] Fix incorrect documentation concerning affinity of UNION, INTERSECT, and EXCEPT. (check-in: [6fe30b1e8d] user: drh branch: trunk, size: 23164) | |
| 14:47 | [460eb247aa] part of check-in [e62a74f31a] Clarifications on affinity handling in the datatype3.html document. (check-in: [e62a74f31a] user: drh branch: trunk, size: 23478) | |
|
2009-12-30
| ||
| 18:17 | [63f3c0d0c6] part of check-in [5c8750d0ff] 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. (check-in: [5c8750d0ff] user: drh branch: trunk, size: 23759) | |
| 15:32 | [93a6b160f6] part of check-in [3da8351ec8] Fix some typos in datatype3.html. (check-in: [3da8351ec8] user: dan branch: trunk, size: 23568) | |
|
2009-12-25
| ||
| 02:53 | [d461aa6e03] part of check-in [4737512960] Additional refinements to the datatype3.html document. (check-in: [4737512960] user: drh branch: trunk, size: 23503) | |
|
2009-12-24
| ||
| 21:37 | [551b64a240] part of check-in [e357f599e3] Update and clarify the documentation on datatypes and on CAST expressions. (check-in: [e357f599e3] user: drh branch: trunk, size: 23496) | |
| 16:02 | [6872ec243a] part of check-in [75e2505670] Clarifications to the datatype3.html document. (check-in: [75e2505670] user: drh branch: trunk, size: 18890) | |
|
2009-12-14
| ||
| 23:00 | [294b7cd3f0] part of check-in [e18ce3ebd0] Identify requirements in the autoinc.html and datatype3.html documents. Make corrections in datatype3.html for accuracy and for clearer presentation. (check-in: [e18ce3ebd0] user: drh branch: trunk, size: 17986) | |
|
2009-11-02
| ||
| 15:50 | [35c0cb06fa] part of check-in [ec4a51db99] Added the website keyword index. (check-in: [ec4a51db99] user: drh branch: trunk, size: 19791) | |
|
2009-06-08
| ||
| 04:45 | [4168bee88d] part of check-in [0b44acac20] Update datatype3.html to mention that CAST expressions have an affinity. (check-in: [0b44acac20] user: dan branch: trunk, size: 19673) | |
|
2009-03-18
| ||
| 14:19 | [054633f070] part of check-in [cfa4627882] Fix typos in documentation. This is the fix for ticket [9ed3b9626c9462e11a557621152f3e2d4eead482] (check-in: [cfa4627882] user: drh branch: trunk, size: 19010) | |
|
2008-12-15
| ||
| 22:49 | [3d3ff640f3] part of check-in [47171588ec] Attempt to do a better job of explaining INTEGER PRIMARY KEY. (check-in: [47171588ec] user: drh branch: trunk, size: 19011) | |
| 18:30 | [6742c4b4b0] part of check-in [a3dc852796] Enhanced documentation for INTEGER PRIMARY KEY. (check-in: [a3dc852796] user: drh branch: trunk, size: 17743) | |
|
2008-06-25
| ||
| 08:36 | [4e49d39186] part of check-in [391102d17f] Fixed #1020. (check-in: [391102d17f] user: mihailim branch: trunk, size: 17814) | |
|
2008-04-27
| ||
| 17:51 | [074603963b] part of check-in [f060763119] Updates to the SQL language documentation with many added hyperlink targets. (check-in: [f060763119] user: drh branch: trunk, size: 17802) | |
|
2007-11-12
| ||
| 15:32 | Added: [adc47b58e9] part of check-in [275febef8f] Complete reorganization of the documentation sources. (check-in: [275febef8f] user: drh branch: trunk, size: 17462) | |