Function alasqlparser has 2658 lines of code (exceeds 25 allowed). Consider refactoring.

Open

var alasqlparser = (function(){
var o=function(k,v,o,l){for(o=o||{},l=k.length;l--;o[k[l]]=v);return o},$V0=[2,13],$V1=[1,104],$V2=[1,102],$V3=[1,103],$V4=[1,6],$V5=[1,42],$V6=[1,79],$V7=[1,76],$V8=[1,94],$V9=[1,93],$Va=[1,69],$Vb=[1,101],$Vc=[1,85],$Vd=[1,64],$Ve=[1,71],$Vf=[1,84],$Vg=[1,66],$Vh=[1,70],$Vi=[1,68],$Vj=[1,61],$Vk=[1,74],$Vl=[1,62],$Vm=[1,67],$Vn=[1,83],$Vo=[1,77],$Vp=[1,86],$Vq=[1,87],$Vr=[1,81],$Vs=[1,82],$Vt=[1,80],$Vu=[1,88],$Vv=[1,89],$Vw=[1,90],$Vx=[1,91],$Vy=[1,92],$Vz=[1,98],$VA=[1,65],$VB=[1,78],$VC=[1,72],$VD=[1,96],$VE=[1,97],$VF=[1,63],$VG=[1,73],$VH=[1,108],$VI=[1,107],$VJ=[10,308,604,765],$VK=[10,308,312,604,765],$VL=[1,115],$VM=[1,116],$VN=[1,117],$VO=[1,118],$VP=[1,119],$VQ=[130,355,412],$VR=[1,127],$VS=[1,126],$VT=[1,134],$VU=[1,164],$VV=[1,175],$VW=[1,178],$VX=[1,173],$VY=[1,181],$VZ=[1,185],$V_=[1,160],$V$=[1,182],$V01=[1,169],$V11=[1,171],$V21=[1,174],$V31=[1,183],$V41=[1,199],$V51=[1,200],$V61=[1,166],$V71=[1,193],$V81=[1,188],$V91=[1,189],$Va1=[1,194],$Vb1=[1,195],$Vc1=[1,196],$Vd1=[1,197],$Ve1=[1,198],$Vf1=[1,201],$Vg1=[1,202],$Vh1=[1,176],$Vi1=[1,177],$Vj1=[1,179],$Vk1=[1,180],$Vl1=[1,186],$Vm1=[1,192],$Vn1=[1,184],$Vo1=[1,187],$Vp1=[1,172],$Vq1=[1,170],$Vr1=[1,191],$Vs1=[1,203],$Vt1=[2,4,5],$Vu1=[2,474],$Vv1=[1,206],$Vw1=[1,211],$Vx1=[1,220],$Vy1=[1,216],$Vz1=[10,72,78,93,98,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VA1=[2,4,5,10,72,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,183,185,187,198,244,245,284,285,286,287,288,289,290,308,312,422,426,604,765],$VB1=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VC1=[1,249],$VD1=[1,256],$VE1=[1,265],$VF1=[1,270],$VG1=[1,269],$VH1=[2,4,5,10,72,77,78,93,98,107,118,128,131,132,137,143,145,149,152,154,156,162,168,169,179,180,181,183,198,232,244,245,249,251,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,308,312,314,319,422,426,604,765],$VI1=[2,162],$VJ1=[1,281],$VK1=[10,74,78,308,312,507,604,765],$VL1=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,193,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,304,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,346,358,370,371,372,375,376,388,391,398,402,403,404,405,406,407,408,410,411,419,420,422,426,428,435,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,516,517,518,519,604,765],$VM1=[2,4,5,10,53,72,89,124,146,156,189,270,271,292,308,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$VN1=[1,562],$VO1=[1,564],$VP1=[2,506],$VQ1=[1,569],$VR1=[1,580],$VS1=[1,583],$VT1=[1,584],$VU1=[10,78,89,132,137,146,189,298,308,312,472,604,765],$VV1=[10,74,308,312,604,765],$VW1=[2,570],$VX1=[1,602],$VY1=[2,4,5,156],$VZ1=[1,640],$V_1=[1,612],$V$1=[1,646],$V02=[1,647],$V12=[1,620],$V22=[1,631],$V32=[1,618],$V42=[1,626],$V52=[1,619],$V62=[1,627],$V72=[1,629],$V82=[1,621],$V92=[1,622],$Va2=[1,641],$Vb2=[1,638],$Vc2=[1,639],$Vd2=[1,615],$Ve2=[1,617],$Vf2=[1,609],$Vg2=[1,610],$Vh2=[1,611],$Vi2=[1,613],$Vj2=[1,614],$Vk2=[1,616],$Vl2=[1,623],$Vm2=[1,624],$Vn2=[1,628],$Vo2=[1,630],$Vp2=[1,632],$Vq2=[1,633],$Vr2=[1,634],$Vs2=[1,635],$Vt2=[1,636],$Vu2=[1,642],$Vv2=[1,643],$Vw2=[1,644],$Vx2=[1,645],$Vy2=[2,290],$Vz2=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,358,370,371,375,376,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VA2=[2,362],$VB2=[1,668],$VC2=[1,678],$VD2=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VE2=[1,694],$VF2=[1,703],$VG2=[1,702],$VH2=[2,4,5,10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VI2=[10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VJ2=[2,202],$VK2=[1,725],$VL2=[10,72,78,93,98,118,128,162,168,169,183,232,249,251,308,312,604,765],$VM2=[2,163],$VN2=[1,728],$VO2=[2,4,5,112],$VP2=[1,741],$VQ2=[1,760],$VR2=[1,740],$VS2=[1,739],$VT2=[1,734],$VU2=[1,735],$VV2=[1,737],$VW2=[1,738],$VX2=[1,742],$VY2=[1,743],$VZ2=[1,744],$V_2=[1,745],$V$2=[1,746],$V03=[1,747],$V13=[1,748],$V23=[1,749],$V33=[1,750],$V43=[1,751],$V53=[1,752],$V63=[1,753],$V73=[1,754],$V83=[1,755],$V93=[1,756],$Va3=[1,757],$Vb3=[1,759],$Vc3=[1,761],$Vd3=[1,762],$Ve3=[1,763],$Vf3=[1,764],$Vg3=[1,765],$Vh3=[1,766],$Vi3=[1,767],$Vj3=[1,770],$Vk3=[1,771],$Vl3=[1,772],$Vm3=[1,773],$Vn3=[1,774],$Vo3=[1,775],$Vp3=[1,776],$Vq3=[1,777],$Vr3=[1,778],$Vs3=[1,779],$Vt3=[1,780],$Vu3=[1,781],$Vv3=[74,89,189],$Vw3=[10,74,78,154,187,230,299,308,312,345,358,370,371,375,376,604,765],$Vx3=[1,798],$Vy3=[10,74,78,302,308,312,604,765],$Vz3=[1,799],$VA3=[1,805],$VB3=[1,806],$VC3=[1,810],$VD3=[10,74,78,308,312,604,765],$VE3=[2,4,5,77,131,132,137,143,145,149,152,154,156,179,180,181,244,245,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,314,319,422,426],$VF3=[10,72,78,93,98,107,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VG3=[2,4,5,10,72,77,78,93,98,107,118,128,131,132,137,143,145,149,152,154,156,162,164,168,169,179,180,181,183,185,187,195,198,232,244,245,249,251,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,308,312,314,319,422,426,604,765],$VH3=[2,4,5,132,298],$VI3=[1,844],$VJ3=[10,74,76,78,308,312,604,765],$VK3=[2,741],$VL3=[10,74,76,78,132,139,141,145,152,308,312,422,426,604,765],$VM3=[2,1164],$VN3=[10,74,76,78,139,141,145,152,308,312,422,426,604,765],$VO3=[10,74,76,78,139,141,145,308,312,422,426,604,765],$VP3=[10,74,78,139,141,308,312,604,765],$VQ3=[10,78,89,132,146,189,298,308,312,472,604,765],$VR3=[337,340,341],$VS3=[2,767],$VT3=[1,869],$VU3=[1,870],$VV3=[1,871],$VW3=[1,872],$VX3=[1,881],$VY3=[1,880],$VZ3=[164,166,336],$V_3=[2,447],$V$3=[1,936],$V04=[2,4,5,77,131,156,292,293,294,295],$V14=[1,951],$V24=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$V34=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$V44=[2,378],$V54=[1,958],$V64=[308,310,312],$V74=[74,302],$V84=[74,302,428],$V94=[1,965],$Va4=[2,4,5,10,53,72,74,76,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$Vb4=[74,428],$Vc4=[1,978],$Vd4=[1,977],$Ve4=[1,984],$Vf4=[10,72,78,93,98,118,128,162,168,169,232,249,251,308,312,604,765],$Vg4=[1,1010],$Vh4=[10,72,78,308,312,604,765],$Vi4=[1,1016],$Vj4=[1,1017],$Vk4=[1,1018],$Vl4=[2,4,5,10,72,74,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,198,244,245,284,285,286,287,288,289,290,308,312,422,426,604,765],$Vm4=[1,1068],$Vn4=[1,1067],$Vo4=[1,1081],$Vp4=[1,1080],$Vq4=[1,1088],$Vr4=[10,72,74,78,93,98,107,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$Vs4=[1,1119],$Vt4=[10,78,89,146,189,308,312,472,604,765],$Vu4=[1,1139],$Vv4=[1,1138],$Vw4=[1,1137],$Vx4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,358,370,371,375,376,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$Vy4=[1,1153],$Vz4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VA4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,317,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VB4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VC4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VD4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,316,322,323,324,325,326,327,328,332,333,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VE4=[2,409],$VF4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,107,118,122,128,129,130,131,132,134,135,137,143,145,146,148,149,150,152,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,316,332,333,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VG4=[2,288],$VH4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VI4=[10,78,308,312,604,765],$VJ4=[1,1189],$VK4=[10,77,78,143,145,152,181,304,308,312,422,426,604,765],$VL4=[10,74,78,308,310,312,466,604,765],$VM4=[1,1200],$VN4=[10,72,78,118,128,162,168,169,232,249,251,308,312,604,765],$VO4=[10,72,74,78,93,98,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VP4=[2,4,5,72,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VQ4=[2,4,5,72,74,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VR4=[2,1088],$VS4=[2,4,5,72,74,76,77,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VT4=[1,1252],$VU4=[10,74,78,128,308,310,312,466,604,765],$VV4=[115,116,124],$VW4=[2,587],$VX4=[1,1280],$VY4=[76,139],$VZ4=[2,727],$V_4=[1,1297],$V$4=[1,1298],$V05=[2,4,5,10,53,72,76,89,124,146,156,189,230,270,271,292,308,312,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$V15=[2,333],$V25=[1,1322],$V35=[1,1336],$V45=[1,1338],$V55=[2,490],$V65=[74,78],$V75=[10,308,310,312,466,604,765],$V85=[10,72,78,118,162,168,169,232,249,251,308,312,604,765],$V95=[1,1354],$Va5=[1,1358],$Vb5=[1,1359],$Vc5=[1,1361],$Vd5=[1,1362],$Ve5=[1,1363],$Vf5=[1,1364],$Vg5=[1,1365],$Vh5=[1,1366],$Vi5=[1,1367],$Vj5=[1,1368],$Vk5=[10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,232,249,251,308,312,604,765],$Vl5=[1,1393],$Vm5=[10,72,78,118,162,168,169,249,251,308,312,604,765],$Vn5=[10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,232,249,251,308,312,604,765],$Vo5=[1,1490],$Vp5=[1,1492],$Vq5=[2,4,5,77,143,145,152,156,181,292,293,294,295,304,422,426],$Vr5=[1,1506],$Vs5=[10,72,74,78,162,168,169,249,251,308,312,604,765],$Vt5=[1,1524],$Vu5=[1,1526],$Vv5=[1,1527],$Vw5=[1,1523],$Vx5=[1,1522],$Vy5=[1,1521],$Vz5=[1,1528],$VA5=[1,1518],$VB5=[1,1519],$VC5=[1,1520],$VD5=[1,1545],$VE5=[2,4,5,10,53,72,89,124,146,156,189,270,271,292,308,312,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$VF5=[1,1556],$VG5=[1,1564],$VH5=[1,1563],$VI5=[10,72,78,162,168,169,249,251,308,312,604,765],$VJ5=[10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VK5=[2,4,5,10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VL5=[1,1623],$VM5=[1,1625],$VN5=[1,1622],$VO5=[1,1624],$VP5=[187,193,370,371,372,375],$VQ5=[2,518],$VR5=[1,1630],$VS5=[1,1649],$VT5=[10,72,78,162,168,169,308,312,604,765],$VU5=[1,1659],$VV5=[1,1660],$VW5=[1,1661],$VX5=[1,1682],$VY5=[4,10,247,308,312,345,358,604,765],$VZ5=[1,1730],$V_5=[10,72,74,78,118,162,168,169,239,249,251,308,312,604,765],$V$5=[2,4,5,77],$V06=[1,1824],$V16=[1,1836],$V26=[1,1855],$V36=[10,72,78,162,168,169,308,312,417,604,765],$V46=[10,74,78,230,308,312,604,765];
var parser = {trace: function trace () { },
yy: {},
symbols_: {"error":2,"Literal":3,"LITERAL":4,"BRALITERAL":5,"NonReserved":6,"LiteralWithSpaces":7,"main":8,"Statements":9,"EOF":10,"Statements_group0":11,"AStatement":12,"ExplainStatement":13,"EXPLAIN":14,"QUERY":15,"PLAN":16,"Statement":17,"AlterTable":18,"AttachDatabase":19,"Call":20,"CreateDatabase":21,"CreateIndex":22,"CreateGraph":23,"CreateTable":24,"CreateView":25,"CreateEdge":26,"CreateVertex":27,"Declare":28,"Delete":29,"DetachDatabase":30,"DropDatabase":31,"DropIndex":32,"DropTable":33,"DropView":34,"If":35,"Insert":36,"Merge":37,"Reindex":38,"RenameTable":39,"Select":40,"ShowCreateTable":41,"ShowColumns":42,"ShowDatabases":43,"ShowIndex":44,"ShowTables":45,"TruncateTable":46,"WithSelect":47,"CreateTrigger":48,"DropTrigger":49,"BeginTransaction":50,"CommitTransaction":51,"RollbackTransaction":52,"EndTransaction":53,"UseDatabase":54,"Update":55,"JavaScript":56,"Source":57,"Assert":58,"While":59,"Continue":60,"Break":61,"BeginEnd":62,"Print":63,"Require":64,"SetVariable":65,"ExpressionStatement":66,"AddRule":67,"Query":68,"Echo":69,"CreateFunction":70,"CreateAggregate":71,"WITH":72,"WithTablesList":73,"COMMA":74,"WithTable":75,"AS":76,"LPAR":77,"RPAR":78,"SelectClause":79,"Select_option0":80,"IntoClause":81,"FromClause":82,"Select_option1":83,"WhereClause":84,"GroupClause":85,"OrderClause":86,"LimitClause":87,"UnionClause":88,"SEARCH":89,"Select_repetition0":90,"Select_option2":91,"PivotClause":92,"PIVOT":93,"Expression":94,"FOR":95,"PivotClause_option0":96,"PivotClause_option1":97,"UNPIVOT":98,"IN":99,"ColumnsList":100,"PivotClause_option2":101,"PivotClause2":102,"AsList":103,"AsLiteral":104,"AsPart":105,"RemoveClause":106,"REMOVE":107,"RemoveClause_option0":108,"RemoveColumnsList":109,"RemoveColumn":110,"Column":111,"LIKE":112,"StringValue":113,"ArrowDot":114,"ARROW":115,"DOT":116,"SearchSelector":117,"ORDER":118,"BY":119,"OrderExpressionsList":120,"SearchSelector_option0":121,"DOTDOT":122,"CARET":123,"EQ":124,"SearchSelector_repetition_plus0":125,"SearchSelector_repetition_plus1":126,"SearchSelector_option1":127,"WHERE":128,"OF":129,"CLASS":130,"NUMBER":131,"STRING":132,"SLASH":133,"VERTEX":134,"EDGE":135,"EXCLAMATION":136,"SHARP":137,"MODULO":138,"GT":139,"LT":140,"GTGT":141,"LTLT":142,"DOLLAR":143,"Json":144,"AT":145,"SET":146,"SetColumnsList":147,"TO":148,"VALUE":149,"ROW":150,"ExprList":151,"COLON":152,"PlusStar":153,"NOT":154,"SearchSelector_repetition2":155,"IF":156,"SearchSelector_repetition3":157,"Aggregator":158,"SearchSelector_repetition4":159,"SearchSelector_group0":160,"SearchSelector_repetition5":161,"UNION":162,"SearchSelectorList":163,"ALL":164,"SearchSelector_repetition6":165,"ANY":166,"SearchSelector_repetition7":167,"INTERSECT":168,"EXCEPT":169,"AND":170,"OR":171,"PATH":172,"RETURN":173,"ResultColumns":174,"REPEAT":175,"SearchSelector_repetition8":176,"SearchSelectorList_repetition0":177,"SearchSelectorList_repetition1":178,"PLUS":179,"STAR":180,"QUESTION":181,"SearchFrom":182,"FROM":183,"SelectModifier":184,"DISTINCT":185,"TopClause":186,"UNIQUE":187,"SelectClause_option0":188,"SELECT":189,"COLUMN":190,"MATRIX":191,"TEXTSTRING":192,"INDEX":193,"RECORDSET":194,"TOP":195,"NumValue":196,"TopClause_option0":197,"INTO":198,"Table":199,"FuncValue":200,"ParamValue":201,"VarValue":202,"FromTablesList":203,"JoinTablesList":204,"ApplyClause":205,"CROSS":206,"APPLY":207,"OUTER":208,"FromTable":209,"FromTable_option0":210,"FromTable_option1":211,"INDEXED":212,"INSERTED":213,"FromString":214,"JoinTable":215,"JoinMode":216,"JoinTableAs":217,"OnClause":218,"JoinTableAs_option0":219,"JoinTableAs_option1":220,"JoinModeMode":221,"NATURAL":222,"JOIN":223,"INNER":224,"LEFT":225,"RIGHT":226,"FULL":227,"SEMI":228,"ANTI":229,"ON":230,"USING":231,"GROUP":232,"GroupExpressionsList":233,"HavingClause":234,"GroupExpression":235,"GROUPING":236,"ROLLUP":237,"CUBE":238,"HAVING":239,"CORRESPONDING":240,"OrderExpression":241,"NullsOrder":242,"NULLS":243,"FIRST":244,"LAST":245,"DIRECTION":246,"COLLATE":247,"NOCASE":248,"LIMIT":249,"OffsetClause":250,"OFFSET":251,"LimitClause_option0":252,"FETCH":253,"LimitClause_option1":254,"LimitClause_option2":255,"LimitClause_option3":256,"ResultColumn":257,"Star":258,"AggrValue":259,"Op":260,"LogicValue":261,"NullValue":262,"ExistsValue":263,"CaseValue":264,"CastClause":265,"ArrayValue":266,"NewClause":267,"Expression_group0":268,"CURRENT_TIMESTAMP":269,"JAVASCRIPT":270,"CREATE":271,"FUNCTION":272,"AGGREGATE":273,"NEW":274,"CAST":275,"ColumnType":276,"CONVERT":277,"PrimitiveValue":278,"OverClause":279,"OVER":280,"OverPartitionClause":281,"OverOrderByClause":282,"PARTITION":283,"SUM":284,"COUNT":285,"MIN":286,"MAX":287,"AVG":288,"AGGR":289,"ARRAY":290,"FuncValue_option0":291,"REPLACE":292,"DATEADD":293,"DATEDIFF":294,"INTERVAL":295,"TRUE":296,"FALSE":297,"NSTRING":298,"NULL":299,"EXISTS":300,"ARRAYLBRA":301,"RBRA":302,"ParamValue_group0":303,"BRAQUESTION":304,"CASE":305,"WhensList":306,"ElseClause":307,"END":308,"When":309,"WHEN":310,"THEN":311,"ELSE":312,"REGEXP":313,"TILDA":314,"GLOB":315,"ESCAPE":316,"NOT_LIKE":317,"BARBAR":318,"MINUS":319,"AMPERSAND":320,"BAR":321,"GE":322,"LE":323,"EQEQ":324,"EQEQEQ":325,"NE":326,"NEEQEQ":327,"NEEQEQEQ":328,"CondOp":329,"AllSome":330,"ColFunc":331,"BETWEEN":332,"NOT_BETWEEN":333,"IS":334,"DOUBLECOLON":335,"SOME":336,"UPDATE":337,"SetColumn":338,"SetColumn_group0":339,"DELETE":340,"INSERT":341,"Into":342,"Values":343,"ValuesListsList":344,"DEFAULT":345,"VALUES":346,"ValuesList":347,"Value":348,"DateValue":349,"TemporaryClause":350,"TableClass":351,"IfNotExists":352,"CreateTableDefClause":353,"CreateTableOptionsClause":354,"TABLE":355,"CreateTableOptions":356,"CreateTableOption":357,"IDENTITY":358,"TEMP":359,"ColumnDefsList":360,"ConstraintsList":361,"Constraint":362,"ConstraintName":363,"PrimaryKey":364,"ForeignKey":365,"UniqueKey":366,"IndexKey":367,"Check":368,"CONSTRAINT":369,"CHECK":370,"PRIMARY":371,"KEY":372,"PrimaryKey_option0":373,"ColsList":374,"FOREIGN":375,"REFERENCES":376,"ForeignKey_option0":377,"OnForeignKeyClause":378,"ParColsList":379,"OnDeleteClause":380,"OnUpdateClause":381,"NO":382,"ACTION":383,"UniqueKey_option0":384,"UniqueKey_option1":385,"ColumnDef":386,"ColumnConstraintsClause":387,"ColumnConstraints":388,"SingularColumnType":389,"NumberMax":390,"ENUM":391,"MAXNUM":392,"ColumnConstraintsList":393,"ColumnConstraint":394,"ParLiteral":395,"ColumnConstraint_option0":396,"ColumnConstraint_option1":397,"DROP":398,"DropTable_group0":399,"IfExists":400,"TablesList":401,"ALTER":402,"RENAME":403,"ADD":404,"MODIFY":405,"ATTACH":406,"DATABASE":407,"DETACH":408,"AsClause":409,"USE":410,"SHOW":411,"VIEW":412,"CreateView_option0":413,"CreateView_option1":414,"SubqueryRestriction":415,"READ":416,"ONLY":417,"OPTION":418,"SOURCE":419,"ASSERT":420,"JsonObject":421,"ATLBRA":422,"JsonArray":423,"JsonValue":424,"JsonPrimitiveValue":425,"LCUR":426,"JsonPropertiesList":427,"RCUR":428,"JsonElementsList":429,"JsonProperty":430,"OnOff":431,"SetPropsList":432,"AtDollar":433,"SetProp":434,"OFF":435,"COMMIT":436,"TRANSACTION":437,"ROLLBACK":438,"BEGIN":439,"ElseStatement":440,"WHILE":441,"CONTINUE":442,"BREAK":443,"PRINT":444,"REQUIRE":445,"StringValuesList":446,"PluginsList":447,"Plugin":448,"ECHO":449,"DECLARE":450,"DeclaresList":451,"DeclareItem":452,"TRUNCATE":453,"MERGE":454,"MergeInto":455,"MergeUsing":456,"MergeOn":457,"MergeMatchedList":458,"OutputClause":459,"MergeMatched":460,"MergeNotMatched":461,"MATCHED":462,"MergeMatchedAction":463,"MergeNotMatchedAction":464,"TARGET":465,"OUTPUT":466,"CreateVertex_option0":467,"CreateVertex_option1":468,"CreateVertex_option2":469,"CreateVertexSet":470,"SharpValue":471,"CONTENT":472,"CreateEdge_option0":473,"GRAPH":474,"GraphList":475,"GraphVertexEdge":476,"GraphElement":477,"GraphVertexEdge_option0":478,"GraphVertexEdge_option1":479,"GraphElementVar":480,"GraphVertexEdge_option2":481,"GraphVertexEdge_option3":482,"GraphVertexEdge_option4":483,"GraphVar":484,"GraphAsClause":485,"GraphAtClause":486,"GraphElement2":487,"GraphElement2_option0":488,"GraphElement2_option1":489,"GraphElement2_option2":490,"GraphElement2_option3":491,"GraphElement_option0":492,"GraphElement_option1":493,"GraphElement_option2":494,"SharpLiteral":495,"GraphElement_option3":496,"GraphElement_option4":497,"GraphElement_option5":498,"ColonLiteral":499,"DeleteVertex":500,"DeleteVertex_option0":501,"DeleteEdge":502,"DeleteEdge_option0":503,"DeleteEdge_option1":504,"DeleteEdge_option2":505,"Term":506,"COLONDASH":507,"TermsList":508,"QUESTIONDASH":509,"CALL":510,"TRIGGER":511,"BeforeAfter":512,"InsertDeleteUpdate":513,"CreateTrigger_option0":514,"CreateTrigger_option1":515,"BEFORE":516,"AFTER":517,"INSTEAD":518,"REINDEX":519,"A":520,"ABSENT":521,"ABSOLUTE":522,"ACCORDING":523,"ADA":524,"ADMIN":525,"ALWAYS":526,"ASC":527,"ASSERTION":528,"ASSIGNMENT":529,"ATTRIBUTE":530,"ATTRIBUTES":531,"BASE64":532,"BERNOULLI":533,"BLOCKED":534,"BOM":535,"BREADTH":536,"C":537,"CASCADE":538,"CATALOG":539,"CATALOG_NAME":540,"CHAIN":541,"CHARACTERISTICS":542,"CHARACTERS":543,"CHARACTER_SET_CATALOG":544,"CHARACTER_SET_NAME":545,"CHARACTER_SET_SCHEMA":546,"CLASS_ORIGIN":547,"COBOL":548,"COLLATION":549,"COLLATION_CATALOG":550,"COLLATION_NAME":551,"COLLATION_SCHEMA":552,"COLUMNS":553,"COLUMN_NAME":554,"COMMAND_FUNCTION":555,"COMMAND_FUNCTION_CODE":556,"COMMITTED":557,"CONDITION_NUMBER":558,"CONNECTION":559,"CONNECTION_NAME":560,"CONSTRAINTS":561,"CONSTRAINT_CATALOG":562,"CONSTRAINT_NAME":563,"CONSTRAINT_SCHEMA":564,"CONSTRUCTOR":565,"CONTROL":566,"CURSOR_NAME":567,"DATA":568,"DATETIME_INTERVAL_CODE":569,"DATETIME_INTERVAL_PRECISION":570,"DB":571,"DEFAULTS":572,"DEFERRABLE":573,"DEFERRED":574,"DEFINED":575,"DEFINER":576,"DEGREE":577,"DEPTH":578,"DERIVED":579,"DESC":580,"DESCRIPTOR":581,"DIAGNOSTICS":582,"DISPATCH":583,"DOCUMENT":584,"DOMAIN":585,"DYNAMIC_FUNCTION":586,"DYNAMIC_FUNCTION_CODE":587,"EMPTY":588,"ENCODING":589,"ENFORCED":590,"EXCLUDE":591,"EXCLUDING":592,"EXPRESSION":593,"FILE":594,"FINAL":595,"FLAG":596,"FOLLOWING":597,"FORTRAN":598,"FOUND":599,"FS":600,"G":601,"GENERAL":602,"GENERATED":603,"GO":604,"GOTO":605,"GRANTED":606,"HEX":607,"HIERARCHY":608,"ID":609,"IGNORE":610,"IMMEDIATE":611,"IMMEDIATELY":612,"IMPLEMENTATION":613,"INCLUDING":614,"INCREMENT":615,"INDENT":616,"INITIALLY":617,"INPUT":618,"INSTANCE":619,"INSTANTIABLE":620,"INTEGRITY":621,"INVOKER":622,"ISOLATION":623,"K":624,"KEY_MEMBER":625,"KEY_TYPE":626,"LENGTH":627,"LEVEL":628,"LIBRARY":629,"LINK":630,"LOCATION":631,"LOCATOR":632,"M":633,"MAP":634,"MAPPING":635,"MAXVALUE":636,"MESSAGE_LENGTH":637,"MESSAGE_OCTET_LENGTH":638,"MESSAGE_TEXT":639,"MINVALUE":640,"MORE":641,"MUMPS":642,"NAME":643,"NAMES":644,"NAMESPACE":645,"NESTING":646,"NEXT":647,"NFC":648,"NFD":649,"NFKC":650,"NFKD":651,"NIL":652,"NORMALIZED":653,"NULLABLE":654,"OBJECT":655,"OCTETS":656,"OPTIONS":657,"ORDERING":658,"ORDINALITY":659,"OTHERS":660,"OVERRIDING":661,"P":662,"PAD":663,"PARAMETER_MODE":664,"PARAMETER_NAME":665,"PARAMETER_ORDINAL_POSITION":666,"PARAMETER_SPECIFIC_CATALOG":667,"PARAMETER_SPECIFIC_NAME":668,"PARAMETER_SPECIFIC_SCHEMA":669,"PARTIAL":670,"PASCAL":671,"PASSING":672,"PASSTHROUGH":673,"PERMISSION":674,"PLACING":675,"PLI":676,"PRECEDING":677,"PRESERVE":678,"PRIOR":679,"PRIVILEGES":680,"PUBLIC":681,"RECOVERY":682,"RELATIVE":683,"REPEATABLE":684,"REQUIRING":685,"RESPECT":686,"RESTART":687,"RESTORE":688,"RESTRICT":689,"RETURNED_CARDINALITY":690,"RETURNED_LENGTH":691,"RETURNED_OCTET_LENGTH":692,"RETURNED_SQLSTATE":693,"RETURNING":694,"ROLE":695,"ROUTINE":696,"ROUTINE_CATALOG":697,"ROUTINE_NAME":698,"ROUTINE_SCHEMA":699,"ROW_COUNT":700,"SCALE":701,"SCHEMA":702,"SCHEMA_NAME":703,"SCOPE_CATALOG":704,"SCOPE_NAME":705,"SCOPE_SCHEMA":706,"SECTION":707,"SECURITY":708,"SELECTIVE":709,"SELF":710,"SEQUENCE":711,"SERIALIZABLE":712,"SERVER":713,"SERVER_NAME":714,"SESSION":715,"SETS":716,"SIMPLE":717,"SIZE":718,"SPACE":719,"SPECIFIC_NAME":720,"STANDALONE":721,"STATE":722,"STATEMENT":723,"STRIP":724,"STRUCTURE":725,"STYLE":726,"SUBCLASS_ORIGIN":727,"T":728,"TABLE_NAME":729,"TEMPORARY":730,"TIES":731,"TOKEN":732,"TOP_LEVEL_COUNT":733,"TRANSACTIONS_COMMITTED":734,"TRANSACTIONS_ROLLED_BACK":735,"TRANSACTION_ACTIVE":736,"TRANSFORM":737,"TRANSFORMS":738,"TRIGGER_CATALOG":739,"TRIGGER_NAME":740,"TRIGGER_SCHEMA":741,"TYPE":742,"UNBOUNDED":743,"UNCOMMITTED":744,"UNDER":745,"UNLINK":746,"UNNAMED":747,"UNTYPED":748,"URI":749,"USAGE":750,"USER_DEFINED_TYPE_CATALOG":751,"USER_DEFINED_TYPE_CODE":752,"USER_DEFINED_TYPE_NAME":753,"USER_DEFINED_TYPE_SCHEMA":754,"VALID":755,"VERSION":756,"WHITESPACE":757,"WORK":758,"WRAPPER":759,"WRITE":760,"XMLDECLARATION":761,"XMLSCHEMA":762,"YES":763,"ZONE":764,"SEMICOLON":765,"PERCENT":766,"ROWS":767,"FuncValue_option0_group0":768,"$accept":0,"$end":1},

Function doSearch has a Cognitive Complexity of 440 (exceeds 5 allowed). Consider refactoring.

Open

function doSearch(databaseid, params, cb) {
    var res;
    var stope = {};
    var fromdata;
    var selectors = cloneDeep(this.selectors);

• Read up
  Read up

Function alasqlparser has a Cognitive Complexity of 420 (exceeds 5 allowed). Consider refactoring.

Open

var alasqlparser = (function(){
var o=function(k,v,o,l){for(o=o||{},l=k.length;l--;o[k[l]]=v);return o},$V0=[2,13],$V1=[1,104],$V2=[1,102],$V3=[1,103],$V4=[1,6],$V5=[1,42],$V6=[1,79],$V7=[1,76],$V8=[1,94],$V9=[1,93],$Va=[1,69],$Vb=[1,101],$Vc=[1,85],$Vd=[1,64],$Ve=[1,71],$Vf=[1,84],$Vg=[1,66],$Vh=[1,70],$Vi=[1,68],$Vj=[1,61],$Vk=[1,74],$Vl=[1,62],$Vm=[1,67],$Vn=[1,83],$Vo=[1,77],$Vp=[1,86],$Vq=[1,87],$Vr=[1,81],$Vs=[1,82],$Vt=[1,80],$Vu=[1,88],$Vv=[1,89],$Vw=[1,90],$Vx=[1,91],$Vy=[1,92],$Vz=[1,98],$VA=[1,65],$VB=[1,78],$VC=[1,72],$VD=[1,96],$VE=[1,97],$VF=[1,63],$VG=[1,73],$VH=[1,108],$VI=[1,107],$VJ=[10,308,604,765],$VK=[10,308,312,604,765],$VL=[1,115],$VM=[1,116],$VN=[1,117],$VO=[1,118],$VP=[1,119],$VQ=[130,355,412],$VR=[1,127],$VS=[1,126],$VT=[1,134],$VU=[1,164],$VV=[1,175],$VW=[1,178],$VX=[1,173],$VY=[1,181],$VZ=[1,185],$V_=[1,160],$V$=[1,182],$V01=[1,169],$V11=[1,171],$V21=[1,174],$V31=[1,183],$V41=[1,199],$V51=[1,200],$V61=[1,166],$V71=[1,193],$V81=[1,188],$V91=[1,189],$Va1=[1,194],$Vb1=[1,195],$Vc1=[1,196],$Vd1=[1,197],$Ve1=[1,198],$Vf1=[1,201],$Vg1=[1,202],$Vh1=[1,176],$Vi1=[1,177],$Vj1=[1,179],$Vk1=[1,180],$Vl1=[1,186],$Vm1=[1,192],$Vn1=[1,184],$Vo1=[1,187],$Vp1=[1,172],$Vq1=[1,170],$Vr1=[1,191],$Vs1=[1,203],$Vt1=[2,4,5],$Vu1=[2,474],$Vv1=[1,206],$Vw1=[1,211],$Vx1=[1,220],$Vy1=[1,216],$Vz1=[10,72,78,93,98,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VA1=[2,4,5,10,72,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,183,185,187,198,244,245,284,285,286,287,288,289,290,308,312,422,426,604,765],$VB1=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VC1=[1,249],$VD1=[1,256],$VE1=[1,265],$VF1=[1,270],$VG1=[1,269],$VH1=[2,4,5,10,72,77,78,93,98,107,118,128,131,132,137,143,145,149,152,154,156,162,168,169,179,180,181,183,198,232,244,245,249,251,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,308,312,314,319,422,426,604,765],$VI1=[2,162],$VJ1=[1,281],$VK1=[10,74,78,308,312,507,604,765],$VL1=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,193,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,304,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,346,358,370,371,372,375,376,388,391,398,402,403,404,405,406,407,408,410,411,419,420,422,426,428,435,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,516,517,518,519,604,765],$VM1=[2,4,5,10,53,72,89,124,146,156,189,270,271,292,308,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$VN1=[1,562],$VO1=[1,564],$VP1=[2,506],$VQ1=[1,569],$VR1=[1,580],$VS1=[1,583],$VT1=[1,584],$VU1=[10,78,89,132,137,146,189,298,308,312,472,604,765],$VV1=[10,74,308,312,604,765],$VW1=[2,570],$VX1=[1,602],$VY1=[2,4,5,156],$VZ1=[1,640],$V_1=[1,612],$V$1=[1,646],$V02=[1,647],$V12=[1,620],$V22=[1,631],$V32=[1,618],$V42=[1,626],$V52=[1,619],$V62=[1,627],$V72=[1,629],$V82=[1,621],$V92=[1,622],$Va2=[1,641],$Vb2=[1,638],$Vc2=[1,639],$Vd2=[1,615],$Ve2=[1,617],$Vf2=[1,609],$Vg2=[1,610],$Vh2=[1,611],$Vi2=[1,613],$Vj2=[1,614],$Vk2=[1,616],$Vl2=[1,623],$Vm2=[1,624],$Vn2=[1,628],$Vo2=[1,630],$Vp2=[1,632],$Vq2=[1,633],$Vr2=[1,634],$Vs2=[1,635],$Vt2=[1,636],$Vu2=[1,642],$Vv2=[1,643],$Vw2=[1,644],$Vx2=[1,645],$Vy2=[2,290],$Vz2=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,358,370,371,375,376,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VA2=[2,362],$VB2=[1,668],$VC2=[1,678],$VD2=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,231,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VE2=[1,694],$VF2=[1,703],$VG2=[1,702],$VH2=[2,4,5,10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VI2=[10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VJ2=[2,202],$VK2=[1,725],$VL2=[10,72,78,93,98,118,128,162,168,169,183,232,249,251,308,312,604,765],$VM2=[2,163],$VN2=[1,728],$VO2=[2,4,5,112],$VP2=[1,741],$VQ2=[1,760],$VR2=[1,740],$VS2=[1,739],$VT2=[1,734],$VU2=[1,735],$VV2=[1,737],$VW2=[1,738],$VX2=[1,742],$VY2=[1,743],$VZ2=[1,744],$V_2=[1,745],$V$2=[1,746],$V03=[1,747],$V13=[1,748],$V23=[1,749],$V33=[1,750],$V43=[1,751],$V53=[1,752],$V63=[1,753],$V73=[1,754],$V83=[1,755],$V93=[1,756],$Va3=[1,757],$Vb3=[1,759],$Vc3=[1,761],$Vd3=[1,762],$Ve3=[1,763],$Vf3=[1,764],$Vg3=[1,765],$Vh3=[1,766],$Vi3=[1,767],$Vj3=[1,770],$Vk3=[1,771],$Vl3=[1,772],$Vm3=[1,773],$Vn3=[1,774],$Vo3=[1,775],$Vp3=[1,776],$Vq3=[1,777],$Vr3=[1,778],$Vs3=[1,779],$Vt3=[1,780],$Vu3=[1,781],$Vv3=[74,89,189],$Vw3=[10,74,78,154,187,230,299,308,312,345,358,370,371,375,376,604,765],$Vx3=[1,798],$Vy3=[10,74,78,302,308,312,604,765],$Vz3=[1,799],$VA3=[1,805],$VB3=[1,806],$VC3=[1,810],$VD3=[10,74,78,308,312,604,765],$VE3=[2,4,5,77,131,132,137,143,145,149,152,154,156,179,180,181,244,245,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,314,319,422,426],$VF3=[10,72,78,93,98,107,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VG3=[2,4,5,10,72,77,78,93,98,107,118,128,131,132,137,143,145,149,152,154,156,162,164,168,169,179,180,181,183,185,187,195,198,232,244,245,249,251,269,270,274,275,277,284,285,286,287,288,289,290,292,293,294,295,296,297,298,299,300,301,304,305,308,312,314,319,422,426,604,765],$VH3=[2,4,5,132,298],$VI3=[1,844],$VJ3=[10,74,76,78,308,312,604,765],$VK3=[2,741],$VL3=[10,74,76,78,132,139,141,145,152,308,312,422,426,604,765],$VM3=[2,1164],$VN3=[10,74,76,78,139,141,145,152,308,312,422,426,604,765],$VO3=[10,74,76,78,139,141,145,308,312,422,426,604,765],$VP3=[10,74,78,139,141,308,312,604,765],$VQ3=[10,78,89,132,146,189,298,308,312,472,604,765],$VR3=[337,340,341],$VS3=[2,767],$VT3=[1,869],$VU3=[1,870],$VV3=[1,871],$VW3=[1,872],$VX3=[1,881],$VY3=[1,880],$VZ3=[164,166,336],$V_3=[2,447],$V$3=[1,936],$V04=[2,4,5,77,131,156,292,293,294,295],$V14=[1,951],$V24=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$V34=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$V44=[2,378],$V54=[1,958],$V64=[308,310,312],$V74=[74,302],$V84=[74,302,428],$V94=[1,965],$Va4=[2,4,5,10,53,72,74,76,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$Vb4=[74,428],$Vc4=[1,978],$Vd4=[1,977],$Ve4=[1,984],$Vf4=[10,72,78,93,98,118,128,162,168,169,232,249,251,308,312,604,765],$Vg4=[1,1010],$Vh4=[10,72,78,308,312,604,765],$Vi4=[1,1016],$Vj4=[1,1017],$Vk4=[1,1018],$Vl4=[2,4,5,10,72,74,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,198,244,245,284,285,286,287,288,289,290,308,312,422,426,604,765],$Vm4=[1,1068],$Vn4=[1,1067],$Vo4=[1,1081],$Vp4=[1,1080],$Vq4=[1,1088],$Vr4=[10,72,74,78,93,98,107,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$Vs4=[1,1119],$Vt4=[10,78,89,146,189,308,312,472,604,765],$Vu4=[1,1139],$Vv4=[1,1138],$Vw4=[1,1137],$Vx4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,230,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,299,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,345,358,370,371,375,376,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$Vy4=[1,1153],$Vz4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VA4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,317,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VB4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,133,134,135,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VC4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,118,122,124,128,129,130,131,132,134,135,137,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,315,316,317,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VD4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,118,122,124,128,129,130,131,132,134,135,137,139,140,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,316,322,323,324,325,326,327,328,332,333,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VE4=[2,409],$VF4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,107,118,122,128,129,130,131,132,134,135,137,143,145,146,148,149,150,152,156,162,164,166,168,169,170,171,172,173,175,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,316,332,333,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VG4=[2,288],$VH4=[2,4,5,10,53,72,74,76,77,78,89,93,95,98,99,107,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,179,180,181,183,185,187,189,198,206,208,222,223,224,225,226,227,228,229,232,239,244,245,246,247,249,251,270,271,284,285,286,287,288,289,290,292,298,302,308,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,332,333,334,335,337,340,341,398,402,403,406,408,410,411,419,420,422,426,428,436,438,439,441,442,443,444,445,449,450,453,454,466,472,507,509,510,519,604,765],$VI4=[10,78,308,312,604,765],$VJ4=[1,1189],$VK4=[10,77,78,143,145,152,181,304,308,312,422,426,604,765],$VL4=[10,74,78,308,310,312,466,604,765],$VM4=[1,1200],$VN4=[10,72,78,118,128,162,168,169,232,249,251,308,312,604,765],$VO4=[10,72,74,78,93,98,118,128,162,168,169,183,198,232,249,251,308,312,604,765],$VP4=[2,4,5,72,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VQ4=[2,4,5,72,74,76,77,78,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VR4=[2,1088],$VS4=[2,4,5,72,74,76,77,112,115,116,118,122,123,124,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,145,146,148,149,150,152,154,156,162,164,166,168,169,170,171,172,173,175,185,187,244,245,284,285,286,287,288,289,290,422,426],$VT4=[1,1252],$VU4=[10,74,78,128,308,310,312,466,604,765],$VV4=[115,116,124],$VW4=[2,587],$VX4=[1,1280],$VY4=[76,139],$VZ4=[2,727],$V_4=[1,1297],$V$4=[1,1298],$V05=[2,4,5,10,53,72,76,89,124,146,156,189,230,270,271,292,308,312,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$V15=[2,333],$V25=[1,1322],$V35=[1,1336],$V45=[1,1338],$V55=[2,490],$V65=[74,78],$V75=[10,308,310,312,466,604,765],$V85=[10,72,78,118,162,168,169,232,249,251,308,312,604,765],$V95=[1,1354],$Va5=[1,1358],$Vb5=[1,1359],$Vc5=[1,1361],$Vd5=[1,1362],$Ve5=[1,1363],$Vf5=[1,1364],$Vg5=[1,1365],$Vh5=[1,1366],$Vi5=[1,1367],$Vj5=[1,1368],$Vk5=[10,72,74,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,232,249,251,308,312,604,765],$Vl5=[1,1393],$Vm5=[10,72,78,118,162,168,169,249,251,308,312,604,765],$Vn5=[10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,232,249,251,308,312,604,765],$Vo5=[1,1490],$Vp5=[1,1492],$Vq5=[2,4,5,77,143,145,152,156,181,292,293,294,295,304,422,426],$Vr5=[1,1506],$Vs5=[10,72,74,78,162,168,169,249,251,308,312,604,765],$Vt5=[1,1524],$Vu5=[1,1526],$Vv5=[1,1527],$Vw5=[1,1523],$Vx5=[1,1522],$Vy5=[1,1521],$Vz5=[1,1528],$VA5=[1,1518],$VB5=[1,1519],$VC5=[1,1520],$VD5=[1,1545],$VE5=[2,4,5,10,53,72,89,124,146,156,189,270,271,292,308,312,337,340,341,398,402,403,406,408,410,411,419,420,436,438,439,441,442,443,444,445,449,450,453,454,507,509,510,519,604,765],$VF5=[1,1556],$VG5=[1,1564],$VH5=[1,1563],$VI5=[10,72,78,162,168,169,249,251,308,312,604,765],$VJ5=[10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VK5=[2,4,5,10,72,78,93,98,118,128,162,168,169,206,208,222,223,224,225,226,227,228,229,230,231,232,249,251,308,312,604,765],$VL5=[1,1623],$VM5=[1,1625],$VN5=[1,1622],$VO5=[1,1624],$VP5=[187,193,370,371,372,375],$VQ5=[2,518],$VR5=[1,1630],$VS5=[1,1649],$VT5=[10,72,78,162,168,169,308,312,604,765],$VU5=[1,1659],$VV5=[1,1660],$VW5=[1,1661],$VX5=[1,1682],$VY5=[4,10,247,308,312,345,358,604,765],$VZ5=[1,1730],$V_5=[10,72,74,78,118,162,168,169,239,249,251,308,312,604,765],$V$5=[2,4,5,77],$V06=[1,1824],$V16=[1,1836],$V26=[1,1855],$V36=[10,72,78,162,168,169,308,312,417,604,765],$V46=[10,74,78,230,308,312,604,765];
var parser = {trace: function trace () { },
yy: {},
symbols_: {"error":2,"Literal":3,"LITERAL":4,"BRALITERAL":5,"NonReserved":6,"LiteralWithSpaces":7,"main":8,"Statements":9,"EOF":10,"Statements_group0":11,"AStatement":12,"ExplainStatement":13,"EXPLAIN":14,"QUERY":15,"PLAN":16,"Statement":17,"AlterTable":18,"AttachDatabase":19,"Call":20,"CreateDatabase":21,"CreateIndex":22,"CreateGraph":23,"CreateTable":24,"CreateView":25,"CreateEdge":26,"CreateVertex":27,"Declare":28,"Delete":29,"DetachDatabase":30,"DropDatabase":31,"DropIndex":32,"DropTable":33,"DropView":34,"If":35,"Insert":36,"Merge":37,"Reindex":38,"RenameTable":39,"Select":40,"ShowCreateTable":41,"ShowColumns":42,"ShowDatabases":43,"ShowIndex":44,"ShowTables":45,"TruncateTable":46,"WithSelect":47,"CreateTrigger":48,"DropTrigger":49,"BeginTransaction":50,"CommitTransaction":51,"RollbackTransaction":52,"EndTransaction":53,"UseDatabase":54,"Update":55,"JavaScript":56,"Source":57,"Assert":58,"While":59,"Continue":60,"Break":61,"BeginEnd":62,"Print":63,"Require":64,"SetVariable":65,"ExpressionStatement":66,"AddRule":67,"Query":68,"Echo":69,"CreateFunction":70,"CreateAggregate":71,"WITH":72,"WithTablesList":73,"COMMA":74,"WithTable":75,"AS":76,"LPAR":77,"RPAR":78,"SelectClause":79,"Select_option0":80,"IntoClause":81,"FromClause":82,"Select_option1":83,"WhereClause":84,"GroupClause":85,"OrderClause":86,"LimitClause":87,"UnionClause":88,"SEARCH":89,"Select_repetition0":90,"Select_option2":91,"PivotClause":92,"PIVOT":93,"Expression":94,"FOR":95,"PivotClause_option0":96,"PivotClause_option1":97,"UNPIVOT":98,"IN":99,"ColumnsList":100,"PivotClause_option2":101,"PivotClause2":102,"AsList":103,"AsLiteral":104,"AsPart":105,"RemoveClause":106,"REMOVE":107,"RemoveClause_option0":108,"RemoveColumnsList":109,"RemoveColumn":110,"Column":111,"LIKE":112,"StringValue":113,"ArrowDot":114,"ARROW":115,"DOT":116,"SearchSelector":117,"ORDER":118,"BY":119,"OrderExpressionsList":120,"SearchSelector_option0":121,"DOTDOT":122,"CARET":123,"EQ":124,"SearchSelector_repetition_plus0":125,"SearchSelector_repetition_plus1":126,"SearchSelector_option1":127,"WHERE":128,"OF":129,"CLASS":130,"NUMBER":131,"STRING":132,"SLASH":133,"VERTEX":134,"EDGE":135,"EXCLAMATION":136,"SHARP":137,"MODULO":138,"GT":139,"LT":140,"GTGT":141,"LTLT":142,"DOLLAR":143,"Json":144,"AT":145,"SET":146,"SetColumnsList":147,"TO":148,"VALUE":149,"ROW":150,"ExprList":151,"COLON":152,"PlusStar":153,"NOT":154,"SearchSelector_repetition2":155,"IF":156,"SearchSelector_repetition3":157,"Aggregator":158,"SearchSelector_repetition4":159,"SearchSelector_group0":160,"SearchSelector_repetition5":161,"UNION":162,"SearchSelectorList":163,"ALL":164,"SearchSelector_repetition6":165,"ANY":166,"SearchSelector_repetition7":167,"INTERSECT":168,"EXCEPT":169,"AND":170,"OR":171,"PATH":172,"RETURN":173,"ResultColumns":174,"REPEAT":175,"SearchSelector_repetition8":176,"SearchSelectorList_repetition0":177,"SearchSelectorList_repetition1":178,"PLUS":179,"STAR":180,"QUESTION":181,"SearchFrom":182,"FROM":183,"SelectModifier":184,"DISTINCT":185,"TopClause":186,"UNIQUE":187,"SelectClause_option0":188,"SELECT":189,"COLUMN":190,"MATRIX":191,"TEXTSTRING":192,"INDEX":193,"RECORDSET":194,"TOP":195,"NumValue":196,"TopClause_option0":197,"INTO":198,"Table":199,"FuncValue":200,"ParamValue":201,"VarValue":202,"FromTablesList":203,"JoinTablesList":204,"ApplyClause":205,"CROSS":206,"APPLY":207,"OUTER":208,"FromTable":209,"FromTable_option0":210,"FromTable_option1":211,"INDEXED":212,"INSERTED":213,"FromString":214,"JoinTable":215,"JoinMode":216,"JoinTableAs":217,"OnClause":218,"JoinTableAs_option0":219,"JoinTableAs_option1":220,"JoinModeMode":221,"NATURAL":222,"JOIN":223,"INNER":224,"LEFT":225,"RIGHT":226,"FULL":227,"SEMI":228,"ANTI":229,"ON":230,"USING":231,"GROUP":232,"GroupExpressionsList":233,"HavingClause":234,"GroupExpression":235,"GROUPING":236,"ROLLUP":237,"CUBE":238,"HAVING":239,"CORRESPONDING":240,"OrderExpression":241,"NullsOrder":242,"NULLS":243,"FIRST":244,"LAST":245,"DIRECTION":246,"COLLATE":247,"NOCASE":248,"LIMIT":249,"OffsetClause":250,"OFFSET":251,"LimitClause_option0":252,"FETCH":253,"LimitClause_option1":254,"LimitClause_option2":255,"LimitClause_option3":256,"ResultColumn":257,"Star":258,"AggrValue":259,"Op":260,"LogicValue":261,"NullValue":262,"ExistsValue":263,"CaseValue":264,"CastClause":265,"ArrayValue":266,"NewClause":267,"Expression_group0":268,"CURRENT_TIMESTAMP":269,"JAVASCRIPT":270,"CREATE":271,"FUNCTION":272,"AGGREGATE":273,"NEW":274,"CAST":275,"ColumnType":276,"CONVERT":277,"PrimitiveValue":278,"OverClause":279,"OVER":280,"OverPartitionClause":281,"OverOrderByClause":282,"PARTITION":283,"SUM":284,"COUNT":285,"MIN":286,"MAX":287,"AVG":288,"AGGR":289,"ARRAY":290,"FuncValue_option0":291,"REPLACE":292,"DATEADD":293,"DATEDIFF":294,"INTERVAL":295,"TRUE":296,"FALSE":297,"NSTRING":298,"NULL":299,"EXISTS":300,"ARRAYLBRA":301,"RBRA":302,"ParamValue_group0":303,"BRAQUESTION":304,"CASE":305,"WhensList":306,"ElseClause":307,"END":308,"When":309,"WHEN":310,"THEN":311,"ELSE":312,"REGEXP":313,"TILDA":314,"GLOB":315,"ESCAPE":316,"NOT_LIKE":317,"BARBAR":318,"MINUS":319,"AMPERSAND":320,"BAR":321,"GE":322,"LE":323,"EQEQ":324,"EQEQEQ":325,"NE":326,"NEEQEQ":327,"NEEQEQEQ":328,"CondOp":329,"AllSome":330,"ColFunc":331,"BETWEEN":332,"NOT_BETWEEN":333,"IS":334,"DOUBLECOLON":335,"SOME":336,"UPDATE":337,"SetColumn":338,"SetColumn_group0":339,"DELETE":340,"INSERT":341,"Into":342,"Values":343,"ValuesListsList":344,"DEFAULT":345,"VALUES":346,"ValuesList":347,"Value":348,"DateValue":349,"TemporaryClause":350,"TableClass":351,"IfNotExists":352,"CreateTableDefClause":353,"CreateTableOptionsClause":354,"TABLE":355,"CreateTableOptions":356,"CreateTableOption":357,"IDENTITY":358,"TEMP":359,"ColumnDefsList":360,"ConstraintsList":361,"Constraint":362,"ConstraintName":363,"PrimaryKey":364,"ForeignKey":365,"UniqueKey":366,"IndexKey":367,"Check":368,"CONSTRAINT":369,"CHECK":370,"PRIMARY":371,"KEY":372,"PrimaryKey_option0":373,"ColsList":374,"FOREIGN":375,"REFERENCES":376,"ForeignKey_option0":377,"OnForeignKeyClause":378,"ParColsList":379,"OnDeleteClause":380,"OnUpdateClause":381,"NO":382,"ACTION":383,"UniqueKey_option0":384,"UniqueKey_option1":385,"ColumnDef":386,"ColumnConstraintsClause":387,"ColumnConstraints":388,"SingularColumnType":389,"NumberMax":390,"ENUM":391,"MAXNUM":392,"ColumnConstraintsList":393,"ColumnConstraint":394,"ParLiteral":395,"ColumnConstraint_option0":396,"ColumnConstraint_option1":397,"DROP":398,"DropTable_group0":399,"IfExists":400,"TablesList":401,"ALTER":402,"RENAME":403,"ADD":404,"MODIFY":405,"ATTACH":406,"DATABASE":407,"DETACH":408,"AsClause":409,"USE":410,"SHOW":411,"VIEW":412,"CreateView_option0":413,"CreateView_option1":414,"SubqueryRestriction":415,"READ":416,"ONLY":417,"OPTION":418,"SOURCE":419,"ASSERT":420,"JsonObject":421,"ATLBRA":422,"JsonArray":423,"JsonValue":424,"JsonPrimitiveValue":425,"LCUR":426,"JsonPropertiesList":427,"RCUR":428,"JsonElementsList":429,"JsonProperty":430,"OnOff":431,"SetPropsList":432,"AtDollar":433,"SetProp":434,"OFF":435,"COMMIT":436,"TRANSACTION":437,"ROLLBACK":438,"BEGIN":439,"ElseStatement":440,"WHILE":441,"CONTINUE":442,"BREAK":443,"PRINT":444,"REQUIRE":445,"StringValuesList":446,"PluginsList":447,"Plugin":448,"ECHO":449,"DECLARE":450,"DeclaresList":451,"DeclareItem":452,"TRUNCATE":453,"MERGE":454,"MergeInto":455,"MergeUsing":456,"MergeOn":457,"MergeMatchedList":458,"OutputClause":459,"MergeMatched":460,"MergeNotMatched":461,"MATCHED":462,"MergeMatchedAction":463,"MergeNotMatchedAction":464,"TARGET":465,"OUTPUT":466,"CreateVertex_option0":467,"CreateVertex_option1":468,"CreateVertex_option2":469,"CreateVertexSet":470,"SharpValue":471,"CONTENT":472,"CreateEdge_option0":473,"GRAPH":474,"GraphList":475,"GraphVertexEdge":476,"GraphElement":477,"GraphVertexEdge_option0":478,"GraphVertexEdge_option1":479,"GraphElementVar":480,"GraphVertexEdge_option2":481,"GraphVertexEdge_option3":482,"GraphVertexEdge_option4":483,"GraphVar":484,"GraphAsClause":485,"GraphAtClause":486,"GraphElement2":487,"GraphElement2_option0":488,"GraphElement2_option1":489,"GraphElement2_option2":490,"GraphElement2_option3":491,"GraphElement_option0":492,"GraphElement_option1":493,"GraphElement_option2":494,"SharpLiteral":495,"GraphElement_option3":496,"GraphElement_option4":497,"GraphElement_option5":498,"ColonLiteral":499,"DeleteVertex":500,"DeleteVertex_option0":501,"DeleteEdge":502,"DeleteEdge_option0":503,"DeleteEdge_option1":504,"DeleteEdge_option2":505,"Term":506,"COLONDASH":507,"TermsList":508,"QUESTIONDASH":509,"CALL":510,"TRIGGER":511,"BeforeAfter":512,"InsertDeleteUpdate":513,"CreateTrigger_option0":514,"CreateTrigger_option1":515,"BEFORE":516,"AFTER":517,"INSTEAD":518,"REINDEX":519,"A":520,"ABSENT":521,"ABSOLUTE":522,"ACCORDING":523,"ADA":524,"ADMIN":525,"ALWAYS":526,"ASC":527,"ASSERTION":528,"ASSIGNMENT":529,"ATTRIBUTE":530,"ATTRIBUTES":531,"BASE64":532,"BERNOULLI":533,"BLOCKED":534,"BOM":535,"BREADTH":536,"C":537,"CASCADE":538,"CATALOG":539,"CATALOG_NAME":540,"CHAIN":541,"CHARACTERISTICS":542,"CHARACTERS":543,"CHARACTER_SET_CATALOG":544,"CHARACTER_SET_NAME":545,"CHARACTER_SET_SCHEMA":546,"CLASS_ORIGIN":547,"COBOL":548,"COLLATION":549,"COLLATION_CATALOG":550,"COLLATION_NAME":551,"COLLATION_SCHEMA":552,"COLUMNS":553,"COLUMN_NAME":554,"COMMAND_FUNCTION":555,"COMMAND_FUNCTION_CODE":556,"COMMITTED":557,"CONDITION_NUMBER":558,"CONNECTION":559,"CONNECTION_NAME":560,"CONSTRAINTS":561,"CONSTRAINT_CATALOG":562,"CONSTRAINT_NAME":563,"CONSTRAINT_SCHEMA":564,"CONSTRUCTOR":565,"CONTROL":566,"CURSOR_NAME":567,"DATA":568,"DATETIME_INTERVAL_CODE":569,"DATETIME_INTERVAL_PRECISION":570,"DB":571,"DEFAULTS":572,"DEFERRABLE":573,"DEFERRED":574,"DEFINED":575,"DEFINER":576,"DEGREE":577,"DEPTH":578,"DERIVED":579,"DESC":580,"DESCRIPTOR":581,"DIAGNOSTICS":582,"DISPATCH":583,"DOCUMENT":584,"DOMAIN":585,"DYNAMIC_FUNCTION":586,"DYNAMIC_FUNCTION_CODE":587,"EMPTY":588,"ENCODING":589,"ENFORCED":590,"EXCLUDE":591,"EXCLUDING":592,"EXPRESSION":593,"FILE":594,"FINAL":595,"FLAG":596,"FOLLOWING":597,"FORTRAN":598,"FOUND":599,"FS":600,"G":601,"GENERAL":602,"GENERATED":603,"GO":604,"GOTO":605,"GRANTED":606,"HEX":607,"HIERARCHY":608,"ID":609,"IGNORE":610,"IMMEDIATE":611,"IMMEDIATELY":612,"IMPLEMENTATION":613,"INCLUDING":614,"INCREMENT":615,"INDENT":616,"INITIALLY":617,"INPUT":618,"INSTANCE":619,"INSTANTIABLE":620,"INTEGRITY":621,"INVOKER":622,"ISOLATION":623,"K":624,"KEY_MEMBER":625,"KEY_TYPE":626,"LENGTH":627,"LEVEL":628,"LIBRARY":629,"LINK":630,"LOCATION":631,"LOCATOR":632,"M":633,"MAP":634,"MAPPING":635,"MAXVALUE":636,"MESSAGE_LENGTH":637,"MESSAGE_OCTET_LENGTH":638,"MESSAGE_TEXT":639,"MINVALUE":640,"MORE":641,"MUMPS":642,"NAME":643,"NAMES":644,"NAMESPACE":645,"NESTING":646,"NEXT":647,"NFC":648,"NFD":649,"NFKC":650,"NFKD":651,"NIL":652,"NORMALIZED":653,"NULLABLE":654,"OBJECT":655,"OCTETS":656,"OPTIONS":657,"ORDERING":658,"ORDINALITY":659,"OTHERS":660,"OVERRIDING":661,"P":662,"PAD":663,"PARAMETER_MODE":664,"PARAMETER_NAME":665,"PARAMETER_ORDINAL_POSITION":666,"PARAMETER_SPECIFIC_CATALOG":667,"PARAMETER_SPECIFIC_NAME":668,"PARAMETER_SPECIFIC_SCHEMA":669,"PARTIAL":670,"PASCAL":671,"PASSING":672,"PASSTHROUGH":673,"PERMISSION":674,"PLACING":675,"PLI":676,"PRECEDING":677,"PRESERVE":678,"PRIOR":679,"PRIVILEGES":680,"PUBLIC":681,"RECOVERY":682,"RELATIVE":683,"REPEATABLE":684,"REQUIRING":685,"RESPECT":686,"RESTART":687,"RESTORE":688,"RESTRICT":689,"RETURNED_CARDINALITY":690,"RETURNED_LENGTH":691,"RETURNED_OCTET_LENGTH":692,"RETURNED_SQLSTATE":693,"RETURNING":694,"ROLE":695,"ROUTINE":696,"ROUTINE_CATALOG":697,"ROUTINE_NAME":698,"ROUTINE_SCHEMA":699,"ROW_COUNT":700,"SCALE":701,"SCHEMA":702,"SCHEMA_NAME":703,"SCOPE_CATALOG":704,"SCOPE_NAME":705,"SCOPE_SCHEMA":706,"SECTION":707,"SECURITY":708,"SELECTIVE":709,"SELF":710,"SEQUENCE":711,"SERIALIZABLE":712,"SERVER":713,"SERVER_NAME":714,"SESSION":715,"SETS":716,"SIMPLE":717,"SIZE":718,"SPACE":719,"SPECIFIC_NAME":720,"STANDALONE":721,"STATE":722,"STATEMENT":723,"STRIP":724,"STRUCTURE":725,"STYLE":726,"SUBCLASS_ORIGIN":727,"T":728,"TABLE_NAME":729,"TEMPORARY":730,"TIES":731,"TOKEN":732,"TOP_LEVEL_COUNT":733,"TRANSACTIONS_COMMITTED":734,"TRANSACTIONS_ROLLED_BACK":735,"TRANSACTION_ACTIVE":736,"TRANSFORM":737,"TRANSFORMS":738,"TRIGGER_CATALOG":739,"TRIGGER_NAME":740,"TRIGGER_SCHEMA":741,"TYPE":742,"UNBOUNDED":743,"UNCOMMITTED":744,"UNDER":745,"UNLINK":746,"UNNAMED":747,"UNTYPED":748,"URI":749,"USAGE":750,"USER_DEFINED_TYPE_CATALOG":751,"USER_DEFINED_TYPE_CODE":752,"USER_DEFINED_TYPE_NAME":753,"USER_DEFINED_TYPE_SCHEMA":754,"VALID":755,"VERSION":756,"WHITESPACE":757,"WORK":758,"WRAPPER":759,"WRITE":760,"XMLDECLARATION":761,"XMLSCHEMA":762,"YES":763,"ZONE":764,"SEMICOLON":765,"PERCENT":766,"ROWS":767,"FuncValue_option0_group0":768,"$accept":0,"$end":1},

• Read up
  Read up

Function anonymous has 1618 lines of code (exceeds 25 allowed). Consider refactoring.

Open

performAction: function anonymous(yytext, yyleng, yylineno, yy, yystate /* action[1] */, $$ /* vstack */, _$ /* lstack */) {
/* this == yyval */

var $0 = $$.length - 1;
switch (yystate) {

File alasqlparser.js has 2676 lines of code (exceeds 250 allowed). Consider refactoring.

Open

/* parser generated by jison 0.4.18 */
/*
  Returns a Parser object of the following structure:

  Parser: {

Function lexer has 827 lines of code (exceeds 25 allowed). Consider refactoring.

Open

var lexer = (function(){
var lexer = ({

EOF:1,

Function execute has a Cognitive Complexity of 201 (exceeds 5 allowed). Consider refactoring.

Open

yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
    //    var self = this;
    var db = alasql.databases[this.table.databaseid || databaseid];

    var tableid = this.table.tableid;

• Read up
  Read up

Function doSearch has 559 lines of code (exceeds 25 allowed). Consider refactoring.

Open

function doSearch(databaseid, params, cb) {
    var res;
    var stope = {};
    var fromdata;
    var selectors = cloneDeep(this.selectors);

Function anonymous has 552 lines of code (exceeds 25 allowed). Consider refactoring.

Open

performAction: function anonymous(yy,yy_,$avoiding_name_collisions,YY_START) {
var YYSTATE=YY_START;
switch($avoiding_name_collisions) {
case 0:return 270
break;

Function queryfn3 has a Cognitive Complexity of 133 (exceeds 5 allowed). Consider refactoring.

Open

function queryfn3(query) {
    var scope = query.scope,
        jlen;

    // Preindexation of data sources

• Read up
  Read up

File 35search.js has 985 lines of code (exceeds 250 allowed). Consider refactoring.

Open

/* global alasql */
/* global yy */
/*
//
// SEARCH for Alasql.js

Function execute has 464 lines of code (exceeds 25 allowed). Consider refactoring.

Open

yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
    //    var self = this;
    var db = alasql.databases[this.table.databaseid || databaseid];

    var tableid = this.table.tableid;

Function preIndex has a Cognitive Complexity of 114 (exceeds 5 allowed). Consider refactoring.

Open

var preIndex = function (query) {
    //    console.log(query);
    // Loop over all sources
    // Todo: make this loop smaller and more graspable
    for (var k = 0, klen = query.sources.length; k < klen; k++) {

• Read up
  Read up

Function processSelector has 458 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    function processSelector(selectors, sidx, value) {
        //        var val;
        /*/*        if(sidx == 0) {
            if(selectors.length > 0 && selectors[0].srchid == 'SHARP') {
                val = alasql.databases[alasql.useid].objects[selectors[0].args[0]];

Function doJoin has a Cognitive Complexity of 112 (exceeds 5 allowed). Consider refactoring.

Open

function doJoin(query, scope, h) {
    //    console.log('doJoin', arguments);
    //    console.log(query.sources.length);
    // Check, if this is a last join?
    if (h >= query.sources.length) {

• Read up
  Read up

Function ZipWriter has 447 lines of code (exceeds 25 allowed). Consider refactoring.

Open

alasql.ZipWriter = function () {
    /**
        @type {object} Entries for ZIP file
    */
    var entries = [];

File 15utility.js has 824 lines of code (exceeds 250 allowed). Consider refactoring.

Open

/*jshint unused:false*/
/*
    Utilities for Alasql.js

    @todo Review the list of utilities

File 50expression.js has 785 lines of code (exceeds 250 allowed). Consider refactoring.

Open

/*
//
// Expressions for Alasql.js
// Date: 03.11.2014
// (c) 2014, Andrey Gershun

Consider simplifying this complex logical expression.

Open

    if (utils.isNode) {
        //*not-for-browser/*
        utils.global.Promise = require('es6-promise').Promise;
        //*/
    } else {

Function compileJoins has 314 lines of code (exceeds 25 allowed). Consider refactoring.

Open

yy.Select.prototype.compileJoins = function (query) {
    //    console.log(this);
    //    debugger;
    var self = this;