SQLite Forum

Timeline
Login

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

31 events by user LY1598773890 occurring around 2021-04-08 01:10:34.

2021-05-12
22:55 Reply: Inconsistent results in the WHERE clause artifact: 2aa3f5495c user: LY1598773890
18:40 Post: Inconsistent results in the WHERE clause artifact: 8988341615 user: LY1598773890
2021-05-08
18:41 Reply: Inconsistent behavior when using nth_value and COUNT artifact: 4b48b381c4 user: LY1598773890
2021-05-07
21:45 Edit: (Deleted) artifact: 47fd432578 user: LY1598773890
21:45 Edit: (Deleted) artifact: 55dcbf7b03 user: LY1598773890
21:43 Edit reply: Inconsistent behavior when using nth_value and COUNT artifact: cc037ef242 user: LY1598773890
21:41 Post: Inconsistent Error messages between SELECT and SELECT COUNT statements artifact: 504a0910b0 user: LY1598773890
21:40 Reply: Inconsistent behavior when using nth_value and COUNT artifact: 21f8d0453e user: LY1598773890
21:33 Reply: Question about Aggregate Function COUNT and Window Function nth_value artifact: 4da6783ff6 user: LY1598773890
20:55 Post: (Deleted) artifact: 87c09adc9b user: LY1598773890
02:23 Reply: Question about Aggregate Function COUNT and Window Function nth_value artifact: 3a0b6b4901 user: LY1598773890
02:19 Post: Inconsistent behavior when using nth_value and COUNT artifact: 99d452c4a8 user: LY1598773890
2021-05-06
19:13 Reply: Question about Aggregate Function COUNT and Window Function nth_value artifact: 5d3d400d49 user: LY1598773890
01:52 Post: Question about Aggregate Function COUNT and Window Function nth_value artifact: 540fdfef77 user: LY1598773890
2021-05-04
16:45 Reply: Possible inconsistent result when use EXISTS ( SELECT...) expression in a WHERE clause artifact: bd8de0d188 user: LY1598773890
04:06 Edit: Possible inconsistent result when use EXISTS ( SELECT...) expression in a WHERE clause artifact: 8692d94725 user: LY1598773890
04:01 Post: Possible inconsistent result when use EXISTS ( SELECT...) expression in a WHERE clause artifact: 98c67a446c user: LY1598773890
2021-04-29
14:35 Reply: Confusion of some subquery results artifact: 5809a32028 user: LY1598773890
04:35 Edit: Confusion of some subquery results artifact: 6a3ec138e9 user: LY1598773890
04:31 Edit: Confusion of some subquery results artifact: 9ec1361d32 user: LY1598773890
04:29 Post: Confusion of some subquery results artifact: 2dc279d40b user: LY1598773890
2021-04-17
21:02 Reply: Inconsistant output when likely/unlikely and join keyword is applied artifact: 8115ae02c6 user: LY1598773890
2021-04-15
17:08 Post: Inconsistant output when likely/unlikely and join keyword is applied artifact: c38462ab5e user: LY1598773890
2021-04-08
01:12 Edit reply: Query triggers Segmentation Fault artifact: ba2189d29e user: LY1598773890
01:10 Reply: Query triggers Segmentation Fault artifact: 5412f98c86 user: LY1598773890
2021-04-07
21:20 Post: Query triggers Segmentation Fault artifact: 174ffb6948 user: LY1598773890
02:10 Reply: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: 3f93e95e08 user: LY1598773890
2021-04-06
22:56 Post: Extra values outputted, with Partial Index and DISTINCT constraints applied artifact: 66954e9ece user: LY1598773890
2021-04-05
16:17 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 691f0047be user: LY1598773890
05:08 Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: 19bee66ece user: LY1598773890
04:55 Post: COUNT statement returns inconsistent values when used with UNION ALL artifact: 8ea1937ce2 user: LY1598773890