ast-project/part1/results/2/bug_4108fe01-dfb6-4f58-a26e-79e913ea2ad0_logic.md

Summary

**No review yet**

Minimized query

CREATE TABLE T (
  a INTEGER,
  b TEXT,
  c REAL
);
INSERT INTO T VALUES (-10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000,'a',1.25), (2,'b',-3.5), (3,'c',9e999);
WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0;
PRAGMA analysis_limit;
-- PERCENT_RANK()

PRAGMA full_column_names = YES;
PRAGMA query_only = 7698233414002707256;
.mode
CREATE TABLE T1 (
  A VARCHAR(10) PRIMARY KEY,
  B VARCHAR(15) UNIQUE,
  C BIGINT
);
CREATE TABLE T2 (
  X VARCHAR(20) PRIMARY KEY,
  A VARCHAR(10),
  FOREIGN KEY (A) REFERENCES T1(A)
);
INSERT INTO T1 VALUES ('a', 'p', 9999999999999);
INSERT INTO T1 VALUES ('b', 'q', -9999999999999);
INSERT INTO T2 VALUES ('m', 'a');
INSERT INTO T2 VALUES ('n', 'b');
SELECT T2.X, T1.C FROM T2 INNER JOIN T1 ON T2.A = T1.A WHERE T1.C > -1000000000000;
DELETE FROM T2 WHERE A > (SELECT AVG(A) FROM T2) RETURNING *;
REINDEX T2;
CREATE  INDEX IF NOT EXISTS idx_T2_3616 ON T2(lower(X)) WHERE X > 0;
INSERT INTO T1 VALUES (NULL, NULL, NULL);
CREATE UNIQUE  INDEX IF NOT EXISTS idx_T2_745 ON T2((X + 1)) WHERE X > 0;
SELECT * FROM T1	NATURAL JOIN T1;
SELECT * FROM T1;
ANALYZE T1;
CREATE TEMPORARY  VIEW IF NOT EXISTS v_T1_7264 AS SELECT C FROM T1;
CREATE  VIEW IF NOT EXISTS v_T2_7482 AS SELECT X FROM T2;
INSERT INTO T2 VALUES (NULL, NULL);
CREATE TEMP  VIEW IF NOT /**/ EXISTS v_T1_8172 AS SELECT A FROM T1;
INSERT INTO T1 VALUES (NULL, NULL, NULL);
INSERT INTO T1 DEFAULT VALUES;
WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<89) SELECT * FROM cnt;
ALTER TABLE T RENAME TO T_r2383;

Actual output

-Inf|a|1.25
3|c|Inf
0
current output mode: list
m|9999999999999
m|a
n|b
a|p|9999999999999
b|q|-9999999999999
a|p|9999999999999
b|q|-9999999999999
||
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89

Expectation

-Inf|a|1.25
3|c|Inf
0
current output mode: list --escape ascii
m|9999999999999
m|a
n|b
a|p|9999999999999
b|q|-9999999999999
a|p|9999999999999
b|q|-9999999999999
||
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89

Flag