admin/ast-project
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
ast-project/part1/results/3/bug_49c92f71-23a7-4541-9ec4-fcdbb16a4e2c_logic.md
T
admin fd930e15cb ---
2026-06-24 13:47:14 +02:00

666 lines
8.9 KiB
Markdown
Raw Permalink Blame History

## 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
PRAGMA table_xinfo(users);
PRAGMA writable_schema = RESET;
.progress 1.7976931348623157e+308
PRAGMA cache_size;
PRAGMA schema_version = 6.283185307179586;
PRAGMA temp_store = '1';
.width
CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INT, d INT);
INSERT INTO t1 VALUES (1, 'Wernher', 10, 100);
INSERT INTO t1 VALUES (2, 'von', 20, 200);
INSERT INTO t1 VALUES (3, 'Braun', 30, 300);
CREATE INDEX t1bc ON t1(b, c);
PRAGMA writable_schema = ON;
.imposter t1bc t2
SELECT * FROM t2;
SELECT b, c FROM t1 ORDER BY b, c;
.quit
ALTER TABLE t1 RENAME TO t1_r4605;
ALTER TABLE t1 DROP COLUMN a;
CREATE TRIGGER IF NOT EXISTS trg_t1_259 AFTER INSERT ON t1 FOR EACH ROW BEGIN SELECT RAISE(FAIL, 'no'); END;
INSERT INTO t1 SELECT * FROM t1;
UPDATE t1 SET b = '' WHERE b BETWEEN 0 AND 100;
INSERT INTO t1 VALUES ('x', NULL, 1, 1) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c;
CREATE TEMP VIEW IF NOT EXISTS v_t1_3309 AS SELECT d FROM t1;
```
## Actual output
```sql
Progress 1
Progress 2
Progress 3
Progress 4
Progress 5
Progress 6
Progress 7
Progress 8
Progress 9
Progress 10
Progress 11
-2000
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
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
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
Progress 118
Progress 119
Progress 120
Progress 121
Progress 122
Progress 123
Progress 124
Progress 125
Progress 126
Progress 127
Progress 128
Progress 129
Progress 130
Progress 131
Progress 132
Progress 133
Progress 134
Progress 135
Progress 136
Progress 137
Progress 138
Progress 139
Progress 140
Progress 141
Progress 142
Progress 143
Progress 144
Progress 145
Progress 146
Progress 147
Progress 148
Progress 149
Progress 150
Progress 151
Progress 152
Progress 153
Progress 154
Progress 155
Progress 156
Progress 157
Progress 158
Progress 159
Progress 160
Progress 161
Progress 162
Progress 163
Progress 164
Progress 165
Progress 166
Progress 167
Progress 168
Progress 169
Progress 170
Progress 171
Progress 172
Progress 173
Progress 174
Progress 175
Progress 176
Progress 177
Progress 178
Progress 179
Progress 180
Progress 181
Progress 182
Progress 183
Progress 184
Progress 185
Progress 186
Progress 187
Progress 188
Progress 189
Progress 190
Progress 191
Progress 192
Progress 193
Progress 194
Progress 195
Progress 196
Progress 197
Progress 198
Progress 199
Progress 200
Progress 201
Progress 202
Progress 203
Progress 204
Progress 205
Progress 206
Progress 207
Progress 208
Progress 209
Progress 210
Progress 211
Progress 212
Progress 213
Progress 214
Progress 215
Progress 216
Progress 217
Progress 218
Progress 219
Progress 220
Progress 221
Progress 222
Progress 223
Progress 224
Progress 225
Progress 226
Progress 227
Progress 228
Progress 229
Progress 230
Progress 231
Progress 232
Progress 233
Progress 234
Progress 235
Progress 236
Progress 237
Progress 238
Progress 239
Progress 240
Progress 241
Progress 242
Progress 243
Progress 244
Progress 245
Progress 246
Progress 247
Progress 248
Progress 249
Progress 250
Progress 251
Progress 252
Progress 253
Progress 254
Progress 255
CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
WARNING: writing to an imposter table will corrupt the "t1bc" index!
Progress 256
Progress 257
Progress 258
Progress 259
Progress 260
Progress 261
Progress 262
Progress 263
Progress 264
Braun|30|3
Progress 265
Progress 266
Progress 267
Progress 268
Progress 269
Wernher|10|1
Progress 270
Progress 271
Progress 272
Progress 273
Progress 274
von|20|2
Progress 275
Progress 276
Progress 277
Progress 278
Progress 279
Progress 280
Progress 281
Progress 282
Progress 283
Progress 284
Progress 285
Braun|30
Progress 286
Progress 287
Progress 288
Progress 289
Wernher|10
Progress 290
Progress 291
Progress 292
Progress 293
von|20
Progress 294
Progress 295
```
## Expectation
```sql
Progress 1
Progress 2
Progress 3
Progress 4
Progress 5
Progress 6
Progress 7
Progress 8
Progress 9
Progress 10
Progress 11
Progress 12
-2000
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
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
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
Progress 118
Progress 119
Progress 120
Progress 121
Progress 122
Progress 123
Progress 124
Progress 125
Progress 126
Progress 127
Progress 128
Progress 129
Progress 130
Progress 131
Progress 132
Progress 133
Progress 134
Progress 135
Progress 136
Progress 137
Progress 138
Progress 139
Progress 140
Progress 141
Progress 142
Progress 143
Progress 144
Progress 145
Progress 146
Progress 147
Progress 148
Progress 149
Progress 150
Progress 151
Progress 152
Progress 153
Progress 154
Progress 155
Progress 156
Progress 157
Progress 158
Progress 159
Progress 160
Progress 161
Progress 162
Progress 163
Progress 164
Progress 165
Progress 166
Progress 167
Progress 168
Progress 169
Progress 170
Progress 171
Progress 172
Progress 173
Progress 174
Progress 175
Progress 176
Progress 177
Progress 178
Progress 179
Progress 180
Progress 181
Progress 182
Progress 183
Progress 184
Progress 185
Progress 186
Progress 187
Progress 188
Progress 189
Progress 190
Progress 191
Progress 192
Progress 193
Progress 194
Progress 195
Progress 196
Progress 197
Progress 198
Progress 199
Progress 200
Progress 201
Progress 202
Progress 203
Progress 204
Progress 205
Progress 206
Progress 207
Progress 208
Progress 209
Progress 210
Progress 211
Progress 212
Progress 213
Progress 214
Progress 215
Progress 216
Progress 217
Progress 218
Progress 219
Progress 220
Progress 221
Progress 222
Progress 223
Progress 224
Progress 225
Progress 226
Progress 227
Progress 228
Progress 229
Progress 230
Progress 231
Progress 232
Progress 233
Progress 234
Progress 235
Progress 236
Progress 237
Progress 238
Progress 239
Progress 240
Progress 241
Progress 242
Progress 243
Progress 244
Progress 245
Progress 246
Progress 247
Progress 248
Progress 249
Progress 250
Progress 251
Progress 252
Progress 253
Progress 254
Progress 255
Progress 256
Progress 257
Progress 258
Progress 259
CREATE TABLE "t2"("b","c","_ROWID_",PRIMARY KEY("b","c","_ROWID_"))WITHOUT ROWID;
Progress 260
Progress 261
Progress 262
Progress 263
Progress 264
Progress 265
Progress 266
Progress 267
Progress 268
Braun|30|3
Progress 269
Progress 270
Progress 271
Progress 272
Progress 273
Wernher|10|1
Progress 274
Progress 275
Progress 276
Progress 277
Progress 278
von|20|2
Progress 279
Progress 280
Progress 281
Progress 282
Progress 283
Progress 284
Progress 285
Progress 286
Progress 287
Progress 288
Progress 289
Braun|30
Progress 290
Progress 291
Progress 292
Progress 293
Wernher|10
Progress 294
Progress 295
Progress 296
Progress 297
von|20
Progress 298
Progress 299
```
## Flag
```
```
Reference in New Issue View Git Blame Copy Permalink