Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2019-06-11 13:40:01|
|15:54||Clarify the semantics of a CAST to NUMERIC. Ticket https://www.sqlite.org/src/tktview/afdc5a29dc (check-in: 7a51b32537 user: drh tags: trunk)|
|13:40||Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 (check-in: e0f700bb6c user: drh tags: trunk)|
|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 (check-in: 722f0828b3 user: drh tags: trunk)|
Changes to pages/datatype3.in.
522 523 524 525 526 527 528
<p>^All of the result in the example are the same if the comparisons are commuted - if expressions of the form "a<40" are rewritten as "40>a". <h1>Operators</h1>
| | | > > > > > > > > > | > > > > > > >
522 523 524 525 526 527 528 548 549 550 552 553 554 555 556 557 558
<p>^All of the result in the example are the same if the comparisons are commuted - if expressions of the form "a<40" are rewritten as "40>a". <h1>Operators</h1> ^A NULL operand on a mathematical operator yields a NULL result. ^(An operand on a mathematical operator that does not look in any way numeric and is not NULL is converted to 0 or 0.0.)^ </p> <h1>Sorting, Grouping and Compound SELECTs</h1> <p>^When query results are sorted by an ORDER BY clause, values with storage class NULL come first, followed by INTEGER and REAL values interspersed in numeric order, followed by TEXT values in collating