Notes
This function is in beta test. Please help improve it in the issues
here.
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