xwb1989 / sqlparser

SQL Parser implemented in Go
Apache License 2.0
1.47k stars 238 forks source link

syntax error at position 1262 #75

Closed jibin8 closed 1 year ago

jibin8 commented 1 year ago

delete from simu_scene_record where origin_scene_record_id in (104628,104508,104024,66876,103924,66571,65701,103544,103364,66786,104380,104040,66331,66276,66396,103556,103624,103396,65371,65846,104212,103856,103272,103308,103564,65661,67031,66616,103464,104392,66391,67016,66481,65466,66796,103244,65526,104084,66636,66536,65906,66156,67046,66246,65671,66486,66761,104340,66411,104444,103404,103824,104080,104476,104424,104348,104528,104012,103744,104136,103220,103888,104256,104352,67036,66776,66126,65326,66706,66716,65316,66171,103664,65616,103440,103952,104516,103612,66381,65941,104384,66256,65806,65461,103796,66861,66196,65776,66691,103484,103196,103496,66931,104488,104468,103616,103848,66136,103212,66681,103804,65746,103696,103772,104096,65586,65926,103840,66326,104428,103208,103476,104588,66371,103532,103884,104072,103792,65801,66911,103292,103328,103428,66081,104100,65901,103568,103676,104596,104504,65311,103224,66721,104416,66856,103304,65996,103900,104520,104076,104356,65826,103372,104280,103516,103688,104180,66221,65861,65936,66336,66106,103636,65606,67006,66516,65686,103768,66101,104524,66881,65726,103932,65896,65426,104552,103632,65821,103716,66211,104148,66091,66586,103264,65541,65741,104300,104208,66306,103320,104184,104132,104248,,104152,103236,66301,104612,66146,104548,104600,104368,103660,65381,103412,65551,104196,103740,103500,104556,67076,65436,66346,66316,65836,65341,66321,104620,103948,65391,66311,66466,103288,65811,66226,66981,103216,65761,65641,66821,65976,103880,66161,65656,66901,103748,65721,103408,65536,103776,103548,66351,66771,104484,65456,104540,66031,65511,65891,65921,66626,65571,66556,66251,103472,103232,65481,66526,65566,66611,65411,65991,66216,66826,66116,65736,65626,66361,66036,65506,65401,66591,66976,104564,66651,66201,65516,104332,66406,66271,66816,65951,66121,104060,103260,65651,66066,67061,66001,66646,66281,66601,65841,67021,66701,66811,104200,67066,66926,66176,66461,104288,66291,103436,65716,104500,66731,66441,65986,66806,104140,65531,104032,103628,66666,66386,65576,65486,103448,66886,66096,66471,66656,65886,65756,65971,66476,104104,65816,65441,66676,66841,65496,66951,67086,65521,66236,103420,66641,66756,66296,66606,104088,66056,66596,65831,65961,103868,66696,104464,66531,103784,103736,103188,66026,65786,66286,65696,65406,66866,66521,103376,66551,67196,67316,67136,67166,67221,106168,67306,67301,67351,67121,67216,67176,67181,67156,67276,67096,67201,67346,67246,67361,67321,67371,67311,67206,106216,106148,67131,67251,67111,67386,67391,67226,67211,67171,67271,67366,106344,106308,67261,106220,67241,67161,67256,67116,106264,106268,67396,67296,67331,67231,67141,106340,67281,106192,106296,67186,67286,67236,67326,67151,67106,106396,67416,67401,67411,67506,67496,67476,67421,67471,67451,67491,67516,67486,67466,67461,67436,67456,67521,67501,67481,67431,67426,67511,99666,99638,99646,99662,99650,99642,99658,106504,99654,67656,67536,67591,67636,67626,67531,67566,67671,67651,67586,67601,67526,67646,67576,67561,67641,67571,67681,67596,67666,67696,67611,67616,67556,67541,67581,67631,67606,67546,67621,67686,67691,67661,67676,67856,67746,67796,67891,106712,67881,67781,67711,67726,67736,106808,106780,106768,106820,67721,106840,106816,106692,106784,67751,67846,67836,67731,67886,106764,67791,67816,67761,67821,67896,106740,67701,67756,67766,67786,67841,67771,67866,67801,67851,67921,67936,67916,106884,67931,67906,67956,67926,67941,67911,67946,106956,99678,99670,99674,99694,99706,99746,99710,99690,99686,99722,99726,99682,99742,99750,99702,99738,99714,99730,99826,99810,99818,99782,99822,99798,99754,99762,99790,99794,99770,99774,99766,99806,99758,99814,99906,99878,99886,99890,107084,99914,99874,99838,99882,99902,99898,99846,99858,99870,99866,99850,99910,99918,99830,99894,99854,99926,99842,7594,7608,7603,7581,7592,7599,7582,107236,7593,7604,7607,7589,7580,7596,7585,7602,7577,107276,7600,107184,107252,67996,67961,67986,68151,68076,68011,68051,68036,68116,68131,68101,68021,68096,68016,107372,68061,68046,68106,68026,68126,68056,68071,68041,107432,68111,68081,68121,68086,68136,68091,107452,7614,7613,7612,7609,7610,7635,7630,7633,7616,7632,7624,7628,7622,7634,7626,7625,7627,7621,7620,7615,7617,7618,7631,7619,7629,7651,7656,7642,7641,7650,7649,7644,107588,7655,7657,7647,7652,7636,7653,7646,7648,7640,7637,7658,7659,7661,7666,7667,107656,107668,7663,29814,29774,29799,29819,29829,29809,29834,29844,29789,29824,29804,29794,29764,29779,29759,29839,29784,29769,29859,29904,29894,29889,29854,29864,29884,29869,29914,29909,29899,29874,29929,29924,29934,29919,29939,29969,30014,30009,30019,29964,29984,29989,30024,29959,29994,29949,30004,29999,29979,29974,30049,30039,30044,30034,93049,108052,93054,93069,93044,93074,93094,93119,93129,108184,93164,93134,93144,93139,93154,93149,93174,93104,93169,93089,93099,93114,93159,93199,93189,93179,93184,93194,96720,96712,96716,96724,96752,96736,96732,96740,96744,96748,96764,96820,96772,96784,108316,96800,96776,96804,96780,108312,96816,96792,96768,96788,96760,96756,108336,96828,108344,96848,96856,96864,96824,96836,96868,96852,96860,96844,96912,96928,96940,96920,96896,96876,96936,96884,96892,96888,96872,96932,96916,96908,96944,96880,96924,96900,97032,96960,96992,97036,96952,96964,97012,97024,97060,96980,96988,97000,97004,97052,97072,96968,97040,97008,97068,97044,96956,97020,96972,97064,97028,97016,96984,97056,97048,96996,97152,97140,97092,97172,97080,97144,97184,97100,97148,97096,97120,97108,97132,108684,97168,108588,97084,97176,97116,97112,97104,97136,97076,97124,98390,98346,98414,98374,98410,98366,98342,98426,98370,98382,98418,98350,98406,98362,98402,98386,98378,98398,98358,98354,98546,98446,98486,98630,98582,98550,98534,98538,98530,98490,98570,98542,98626,98610,98482,98514,98606,98438,98566,98494,98434,98442,98458,98586,98594,98470,98614,98526,98578,98602,108872,98510,98558,98478,98474,98598,98506,98562,108868,98574,98450,108816,98622,98554,108812,98430,98498,98590,98502,98634,98702,98694,98650,98670,98638,98646,98658,98678,98686,98690,98642,98654,98682,98698,98706,98666,98674,98662,98710,98750,98766,98798,98726,98794,98758,98790,98806,98802,98774,98742,98722,98746,98730,98782,98734,98770,98754,98810,98762,98714,98738,98778,98786,98830,98882,98814,98818,98822,98942,98850,98898,98926,98846,98870,98954,98854,98906,98934,98918,98866,98862,98914,98890,98886,98858,98970,98938,98902,98878,98950,98842,98826,98834,98874,98962,98838,98922,98910,98966,98930,98894,98946,98958,99022,99026,99018,98998,99046,98978,99010,99042,99030,99006,98982,99054,99058,99002,98974,99074,99066,99038,99062,98986,99070,98994,99050,99014,99034,98990,99094,99138,99130,99134,99090,99086,99190,99098,99202,99170,99198,99078,99158,99178,99206,99114,99146,99182,99162,99102,99186,99150,99174,99154,99126,99106,99166,99118,99142,99122,99110,99082,99194,99286,99250,99378,99354,99402,99298,99318,99326,99338,99334,99362,99366,99234,99262,99358,99254,99382,99214,99290,99270,99310,99274,99222,99342,99266,99374,99350,99390,99210,99386,99242,99322,99278,99394,99230,99306,99294,99314,99398,99226,99258,99346,99218,99330,99282,99370,99302,99246,99238,99450,99534,99442,99462,99506,99458,99434,99538,99474,99422,99454,99430,99406,99494,99446,99498,99426,99530,99490,99466,99526,99546,99522,99410,99486,99550,99470,99510,99478,99542,99514,99438,99502,99482,99518,99418,99414,99570,99602,99618,99566,99578,99630,99554,99562,99598,99610,99614,99622,99626,99586,99558,99606,99590,99582,99574,99594,444898,444902,446580,446584) and type in (NULL, 24);

error: syntax error at position 1262 But when I reduce the id in the origin_scene_record_id condition by a few, it works