Record Case Detail

Notes

This function is in beta test. Please help improve it in the issues here.

Stderr

lemondb: info: auto detect thread num
4 threads
0 LOAD ./db/t1.tbl
1 LOAD ./db/t2.tbl
2 INSERT ( r0 -14 17 2 20 23 19 7 -10 7 29 15 7 -6 12 14 -30 ) FROM t2
3 INSERT ( r1 8 2 -9 3 28 -16 29 -7 11 14 9 4 1 -2 -5 -24 ) FROM t2
4 INSERT ( r2 4 -2 -21 -28 13 4 7 17 -4 -27 -10 -7 6 -28 -28 -4 ) FROM t2
5 INSERT ( r3 -8 -18 -26 -20 23 -24 -27 -20 -18 -14 13 -4 0 -1 14 27 ) FROM t2
6 INSERT ( r4 12 8 15 -22 9 0 5 10 7 21 -28 -3 -12 -1 -27 -12 ) FROM t2
7 INSERT ( r5 30 -21 -17 25 -4 -14 16 17 -12 -12 -4 17 4 27 -3 -27 ) FROM t2
8 INSERT ( r6 1 -10 14 -4 -6 -29 6 6 -21 -6 -25 19 18 2 -26 7 ) FROM t2
9 INSERT ( r7 1 23 -7 7 -16 -1 -30 -30 -26 28 15 24 -27 -23 -9 0 ) FROM t2
10 INSERT ( r8 26 -5 -7 -29 29 27 -20 -14 -12 -29 -5 22 5 25 -7 20 ) FROM t2
11 INSERT ( r9 -19 18 -2 -25 17 -20 5 -18 6 -7 25 21 18 -30 -26 -14 ) FROM t2
12 INSERT ( rA 14 -30 22 24 -20 14 -6 8 -25 -10 -7 25 -27 -11 -10 -23 ) FROM t2
13 INSERT ( rB -4 4 9 17 29 -23 -5 -25 -17 0 28 -15 -30 19 -14 10 ) FROM t2
14 INSERT ( rC -26 1 27 11 -20 -23 -27 

Your Answer

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
Affected 9 rows.
44
Affected 65535 rows.
45
ANSWER = ( 163150 ) 
46
Affected 1 rows.
47
Affected 1 rows.
48
( r10 -846 329 -394 -394 -846 12 -846 )
49
( r0 -267 -622 -927 -622 -267 )
( r1 500 -193 506 -193 500 )
( r100 -195 468 131 468 -195 )
( r1001 -704 -38 -796 -38 -704 )
( r1003 -586 -578 -696 -578 -586 )
( r1007 576 -423 -179 -423 576 )
( r100B -822 599 858 599 -822 )
( r100E 492 404 490 404 492 )
( r1015 292 386 -645 386 292 )
( r1018 -509 -502 -474 -502 -509 )
( r1019 65 -164 -605 -164 65 )
( r101A -231 777 -643 777 -231 )
( r101E -408 876 273 876 -408 )
( r1022 877 -850 403 -850 877 )
( r1023 -664 929 464 929 -664 )
( r1025 -111 -67 -501 -67 -111 )
( r1028 216 -817 -807 -817 216 )
( r1029 -258 -80 -145 -80 -258 )
( r102C -92 974 -448 974 -92 )
( r102F 670 -97 203 -97 670 )
( r1030 -965 -724 -725 -724 -965 )
( r1031 -294 -98 -371 -98 -294 )
( r1034 -480 642 652 642 -480 )
( r1036 894 

JOJ Answer

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
Affected 9 rows.
44
Affected 65535 rows.
45
ANSWER = ( 163150 )
46
Affected 1 rows.
47
Affected 1 rows.
48
( r10 -846 329 -394 -394 -846 12 -846 )
49
( r0 -267 -622 -927 -622 -267 )
( r1 500 -193 506 -193 500 )
( r100 -195 468 131 468 -195 )
( r1001 -704 -38 -796 -38 -704 )
( r1003 -586 -578 -696 -578 -586 )
( r1007 576 -423 -179 -423 576 )
( r100B -822 599 858 599 -822 )
( r100E 492 404 490 404 492 )
( r1015 292 386 -645 386 292 )
( r1018 -509 -502 -474 -502 -509 )
( r1019 65 -164 -605 -164 65 )
( r101A -231 777 -643 777 -231 )
( r101E -408 876 273 876 -408 )
( r1022 877 -850 403 -850 877 )
( r1023 -664 929 464 929 -664 )
( r1025 -111 -67 -501 -67 -111 )
( r1028 216 -817 -807 -817 216 )
( r1029 -258 -80 -145 -80 -258 )
( r102C -92 974 -448 974 -92 )
( r102F 670 -97 203 -97 670 )
( r1030 -965 -724 -725 -724 -965 )
( r1031 -294 -98 -371 -98 -294 )
( r1034 -480 642 652 642 -480 )
( r1036 894 5