321 lines
5.2 KiB
Markdown
321 lines
5.2 KiB
Markdown
## Summary
|
|
<!--Explain briefly what goes wrong and explain why you believe this is a bug and not the intended behavior of SQLite (if it is not a crash).-->**No review yet**
|
|
|
|
## Minimized query
|
|
|
|
```sql
|
|
.changes on
|
|
PRAGMA reverse_unordered_selects = ON;
|
|
PRAGMA temp_store = '2';
|
|
PRAGMA application_id = 10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000;
|
|
.progress 1
|
|
PRAGMA encoding=UTF16le;
|
|
CREATE TABLE tkt3376(a COLLATE nocase PRIMARY KEY);
|
|
INSERT INTO tkt3376 VALUES('abc');
|
|
INSERT INTO tkt3376 VALUES('ABX');
|
|
SELECT DISTINCT a FROM tkt3376;
|
|
|
|
```
|
|
|
|
## Actual output
|
|
|
|
```sql
|
|
changes: 0 total_changes: 0
|
|
changes: 0 total_changes: 0
|
|
changes: 0 total_changes: 0
|
|
Progress 1
|
|
Progress 2
|
|
Progress 3
|
|
changes: 0 total_changes: 0
|
|
Progress 4
|
|
Progress 5
|
|
Progress 6
|
|
Progress 7
|
|
Progress 8
|
|
Progress 9
|
|
Progress 10
|
|
Progress 11
|
|
Progress 12
|
|
Progress 13
|
|
Progress 14
|
|
Progress 15
|
|
Progress 16
|
|
Progress 17
|
|
Progress 18
|
|
Progress 19
|
|
Progress 20
|
|
Progress 21
|
|
Progress 22
|
|
Progress 23
|
|
Progress 24
|
|
Progress 25
|
|
Progress 26
|
|
Progress 27
|
|
Progress 28
|
|
Progress 29
|
|
Progress 30
|
|
Progress 31
|
|
Progress 32
|
|
Progress 33
|
|
Progress 34
|
|
Progress 35
|
|
Progress 36
|
|
Progress 37
|
|
Progress 38
|
|
Progress 39
|
|
Progress 40
|
|
Progress 41
|
|
Progress 42
|
|
Progress 43
|
|
Progress 44
|
|
Progress 45
|
|
Progress 46
|
|
Progress 47
|
|
Progress 48
|
|
Progress 49
|
|
Progress 50
|
|
Progress 51
|
|
Progress 52
|
|
Progress 53
|
|
Progress 54
|
|
Progress 55
|
|
Progress 56
|
|
Progress 57
|
|
Progress 58
|
|
Progress 59
|
|
Progress 60
|
|
Progress 61
|
|
Progress 62
|
|
Progress 63
|
|
Progress 64
|
|
Progress 65
|
|
Progress 66
|
|
Progress 67
|
|
Progress 68
|
|
Progress 69
|
|
Progress 70
|
|
Progress 71
|
|
Progress 72
|
|
Progress 73
|
|
Progress 74
|
|
Progress 75
|
|
Progress 76
|
|
Progress 77
|
|
Progress 78
|
|
Progress 79
|
|
Progress 80
|
|
Progress 81
|
|
Progress 82
|
|
changes: 0 total_changes: 0
|
|
Progress 83
|
|
Progress 84
|
|
Progress 85
|
|
Progress 86
|
|
Progress 87
|
|
Progress 88
|
|
Progress 89
|
|
Progress 90
|
|
Progress 91
|
|
Progress 92
|
|
Progress 93
|
|
Progress 94
|
|
Progress 95
|
|
Progress 96
|
|
Progress 97
|
|
Progress 98
|
|
changes: 1 total_changes: 1
|
|
Progress 99
|
|
Progress 100
|
|
Progress 101
|
|
Progress 102
|
|
Progress 103
|
|
Progress 104
|
|
Progress 105
|
|
Progress 106
|
|
Progress 107
|
|
Progress 108
|
|
Progress 109
|
|
Progress 110
|
|
Progress 111
|
|
Progress 112
|
|
Progress 113
|
|
Progress 114
|
|
changes: 1 total_changes: 2
|
|
Progress 115
|
|
Progress 116
|
|
Progress 117
|
|
Progress 118
|
|
Progress 119
|
|
Progress 120
|
|
Progress 121
|
|
Progress 122
|
|
Progress 123
|
|
Progress 124
|
|
abc
|
|
Progress 125
|
|
Progress 126
|
|
Progress 127
|
|
Progress 128
|
|
Progress 129
|
|
ABX
|
|
Progress 130
|
|
Progress 131
|
|
changes: 1 total_changes: 2
|
|
```
|
|
|
|
## Expectation
|
|
|
|
```sql
|
|
changes: 0 total_changes: 0
|
|
changes: 0 total_changes: 0
|
|
changes: 0 total_changes: 0
|
|
Progress 1
|
|
Progress 2
|
|
Progress 3
|
|
Progress 4
|
|
changes: 0 total_changes: 0
|
|
Progress 5
|
|
Progress 6
|
|
Progress 7
|
|
Progress 8
|
|
Progress 9
|
|
Progress 10
|
|
Progress 11
|
|
Progress 12
|
|
Progress 13
|
|
Progress 14
|
|
Progress 15
|
|
Progress 16
|
|
Progress 17
|
|
Progress 18
|
|
Progress 19
|
|
Progress 20
|
|
Progress 21
|
|
Progress 22
|
|
Progress 23
|
|
Progress 24
|
|
Progress 25
|
|
Progress 26
|
|
Progress 27
|
|
Progress 28
|
|
Progress 29
|
|
Progress 30
|
|
Progress 31
|
|
Progress 32
|
|
Progress 33
|
|
Progress 34
|
|
Progress 35
|
|
Progress 36
|
|
Progress 37
|
|
Progress 38
|
|
Progress 39
|
|
Progress 40
|
|
Progress 41
|
|
Progress 42
|
|
Progress 43
|
|
Progress 44
|
|
Progress 45
|
|
Progress 46
|
|
Progress 47
|
|
Progress 48
|
|
Progress 49
|
|
Progress 50
|
|
Progress 51
|
|
Progress 52
|
|
Progress 53
|
|
Progress 54
|
|
Progress 55
|
|
Progress 56
|
|
Progress 57
|
|
Progress 58
|
|
Progress 59
|
|
Progress 60
|
|
Progress 61
|
|
Progress 62
|
|
Progress 63
|
|
Progress 64
|
|
Progress 65
|
|
Progress 66
|
|
Progress 67
|
|
Progress 68
|
|
Progress 69
|
|
Progress 70
|
|
Progress 71
|
|
Progress 72
|
|
Progress 73
|
|
Progress 74
|
|
Progress 75
|
|
Progress 76
|
|
Progress 77
|
|
Progress 78
|
|
Progress 79
|
|
Progress 80
|
|
Progress 81
|
|
Progress 82
|
|
Progress 83
|
|
Progress 84
|
|
Progress 85
|
|
changes: 0 total_changes: 0
|
|
Progress 86
|
|
Progress 87
|
|
Progress 88
|
|
Progress 89
|
|
Progress 90
|
|
Progress 91
|
|
Progress 92
|
|
Progress 93
|
|
Progress 94
|
|
Progress 95
|
|
Progress 96
|
|
Progress 97
|
|
Progress 98
|
|
Progress 99
|
|
Progress 100
|
|
Progress 101
|
|
changes: 1 total_changes: 1
|
|
Progress 102
|
|
Progress 103
|
|
Progress 104
|
|
Progress 105
|
|
Progress 106
|
|
Progress 107
|
|
Progress 108
|
|
Progress 109
|
|
Progress 110
|
|
Progress 111
|
|
Progress 112
|
|
Progress 113
|
|
Progress 114
|
|
Progress 115
|
|
Progress 116
|
|
Progress 117
|
|
changes: 1 total_changes: 2
|
|
Progress 118
|
|
Progress 119
|
|
Progress 120
|
|
Progress 121
|
|
Progress 122
|
|
Progress 123
|
|
Progress 124
|
|
Progress 125
|
|
Progress 126
|
|
Progress 127
|
|
abc
|
|
Progress 128
|
|
Progress 129
|
|
Progress 130
|
|
Progress 131
|
|
Progress 132
|
|
ABX
|
|
Progress 133
|
|
Progress 134
|
|
changes: 1 total_changes: 2
|
|
```
|
|
|
|
## Flag
|
|
|
|
```
|
|
|
|
```
|
|
|