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
1 LOAD 2 LOAD 3 INSERT 4 INSERT 5 INSERT 6 INSERT 7 INSERT 8 INSERT 9 INSERT 10 INSERT 11 INSERT 12 INSERT 13 INSERT 14 INSERT 15 INSERT 16 INSERT 17 INSERT 18 INSERT 19 INSERT 20 INSERT 21 INSERT 22 INSERT 23 INSERT 24 INSERT 25 INSERT 26 INSERT 27 INSERT 28 INSERT 29 INSERT 30 INSERT 31 INSERT 32 INSERT 33 INSERT 34 INSERT 35 INSERT 36 INSERT 37 INSERT 38 INSERT 39 INSERT 40 INSERT 41 INSERT 42 INSERT 43 DELETE 44 UPDATE 45 SUM 46 UPDATE 47 UPDATE 48 SELECT 49 SELECT 50 COUNT 51 DUPLICATE 52 COUNT 53 DUPLICATE 54 COUNT 55 DUPLICATE 56 COUNT 57 SELECT 58 SWAP 59 SELECT 60 COUNT 61 SUM 62 SUM 63 ADD 64 ADD 65 SUB 66 SUM 67 SUM 68 MIN 69 MIN 70 MAX 71 MAX 72 SUB 73 SUB 74 MIN 75 MIN 76 MAX 77 MAX 78 TRUNCATE 79 INSERT 80 INSERT 81 INSERT 82 INSERT 83 INSERT 84 INSERT 85 INSERT 86 INSERT 87 INSERT 88 INSERT 89 INSERT 90 INSERT 91 INSERT 92 INSERT 93 INSERT 94 INSERT 95 COPYTABLE 96 DROP 97 INSERT 98 INSERT 99 INSERT 100 INSERT 101 INSERT 102 INSERT 103 INSERT 104 COUNT 105 

Hints

Your answer may be identical to the JOJ answer in the first several lines.

However, you will still get Wrong Answer because the complete output may be longer and there might be errors in the future lines.

Please double check your code to solve this problem and try again.

Your Answer

SUM ( c1 c2 c4 cB cC ) FROM t2 
MIN ( c1 c8 cC c4 c6 ) FROM t3 
MIN ( c1 c8 cC c5 c7 ) FROM t2 
MAX ( c1 c8 cC c4 c6 ) FROM t3 
MAX ( c1 c8 cC c5 c7 ) FROM t2 
SUB ( cC cC ) FROM t3 
SUB ( cC cC cC ) FROM t2 
MIN ( c1 c8 cC c4 c6 ) FROM t3 
MIN ( c1 c8 cC c5 c7 ) FROM t2 
MAX ( c1 c8 cC c4 c6 ) FROM t3 
MAX ( c1 c8 cC c5 c7 ) FROM t2 
LOAD ./db/t1.tbl 
DUMP t1 t1_dump.tbl 
DUMP t3 t3_dump.tbl 
DUMP t2 t2_dump.tbl 

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