7 Commits

Author	SHA1	Message	Date
drh	ac2685b071	Fix new test cases added by [c77ff6089de242d8] so that they work ... on all configurations. FossilOrigin-Name: 78d3370d36fb8872de1ed853f3a479273b54d2cff9fdfe83db963f4da9c7f999	2026-09-19 10:58:12 +00:00
drh	d92acf1afe	Follow-up to check-in [2cb349e5b02aa549] to help indexes on negative ... DEFAULT integer values get stored more efficiently. FossilOrigin-Name: c77ff6089de242d8cb7487ea36b094e403c9ed1a48a8ee713d64a0b87b334369	2026-08-29 20:27:09 +00:00
drh	7b83f65a33	The OP_Affinity opcode with argument E should not try to preserve IntReal ... but should cast the value to a pure Real. [bugs:/info/7f7431180a3b08d1|Bug 2026-08-13T08:12:13Z]. FossilOrigin-Name: 5a4e6920afce4a5b63f8ad4e183506a5dd738dd191027395b710a2904eb7f296	2026-08-13 16:10:04 +00:00
dan	e3b1c3868b	Fix a problem with applying integer affinity to a MEM_IntReal value. Forum post [forum:/forumpost/d270125fae|forum post d270125fae]. ... FossilOrigin-Name: e58bba93717cd6ff950c6f9e077b4327b59b1956dd5f6668be3de9509584b8fe	2023-01-05 13:35:23 +00:00
drh	337cc3992a	Fix the OP_Affinity operator so that when applying REAL affinity, it ... only sets MEM_IntReal if the integer value will fit in 6 bytes or less. Fix for ticket [ba2f4585cf495231] FossilOrigin-Name: 2b221bb15fd2b9f6a426e5eb439f7dbabbe3c4cab010c49b87dae3bb1f16c081	2019-07-29 06:06:53 +00:00
dan	be81262400	Always store a REAL value in a column with REAL affinity if the integer equivalent would require 8 bytes of storage. Fix for [3c27b97e3]. ... FossilOrigin-Name: 14c00b1016ba53ab2dc177c59a27b6b9209202973685f0f274112d296ba7dfcb	2019-05-17 15:59:11 +00:00
drh	0c8f40389e	Add the SQLITE_TESTCTRL_RESULT_INTREAL test-control and use it to create ... the intreal() SQL function in testfixture. Write a few simple tests to prove this all works. TH3 will hold most of the INTREAL tests, probably. FossilOrigin-Name: c9838731325e0ca73bd8784c10c74ae043fed7861e6de269fd90e29fa4a19955	2019-05-03 21:17:28 +00:00