Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Enhance the rtree auxiliary column documentation to point out that constraints such as NOT NULL on auxiliary columns are silently ignored. SQLite ticket https://www.sqlite.org/src/info/8bf76328ac940d52 |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
c3ab325994a8f495f7cfc4f7fe3fc0be |
| User & Date: | drh 2019-12-06 02:35:27 |
Context
|
2019-12-06
| ||
| 13:08 | Enhance the rtree documentation with more detail about the rules for column names and the affinity of columns in the rtree virtual table. (check-in: 8199b59a39 user: drh tags: trunk) | |
| 02:35 | Enhance the rtree auxiliary column documentation to point out that constraints such as NOT NULL on auxiliary columns are silently ignored. SQLite ticket https://www.sqlite.org/src/info/8bf76328ac940d52 (check-in: c3ab325994 user: drh tags: trunk) | |
|
2019-11-23
| ||
| 16:36 | Fix the CLI documentation to always use ".headers" instead of sometimes using the abbreviated ".header". (check-in: a2762f0319 user: drh tags: trunk) | |
Changes
Changes to pages/rtree.in.
| ︙ | ︙ | |||
365 366 367 368 369 370 371 372 373 374 375 376 377 378 |
^(<codeblock>
SELECT objname FROM demo_index2
WHERE contained_in(boundary, :boundary)
AND minX>=-81.0 AND maxX<=-79.6
AND minY>=35.0 AND maxY>=36.2;
</codeblock>)^
<tcl>hd_fragment {intrtree} {integer-valued r-trees}</tcl>
<h1>Integer-Valued R-Trees</h1>
<p>
The default virtual table ("rtree") normally stores coordinates as
single-precision (4-byte) floating point numbers. If integer coordinates
are desired, declare the table using "rtree_i32" instead:
| > > > > > > > > | 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 |
^(<codeblock>
SELECT objname FROM demo_index2
WHERE contained_in(boundary, :boundary)
AND minX>=-81.0 AND maxX<=-79.6
AND minY>=35.0 AND maxY>=36.2;
</codeblock>)^
<h3>Limitations</h3>
<p>
Constraints on auxiliary columns such as NOT NULL, UNIQUE, REFERENCES, or CHECK
are silently ignored in the current implementation. However, future versions
of SQLite might start enforcing one or more of those constraint types. Avoid using
constraints on auxiliary columns to prevent future compatibility problems.
<tcl>hd_fragment {intrtree} {integer-valued r-trees}</tcl>
<h1>Integer-Valued R-Trees</h1>
<p>
The default virtual table ("rtree") normally stores coordinates as
single-precision (4-byte) floating point numbers. If integer coordinates
are desired, declare the table using "rtree_i32" instead:
|
| ︙ | ︙ |