BUG #46308 【旧版条件】【指定sku】创建策略条件为指定sku，执行，没有过滤到数据，执行日志过滤条件中没有传入指定sku - 技术中心-需求池

重现步骤

[步骤]

1.创建策略，条件指定sku，执行策略

[结果]

1.没有过滤到数据

[期望]

历史记录

2024-03-15 16:46:52, 由 劳世仙 创建。
2024-03-17 22:30:22, 由 张粤利 编辑。
修改了 解决时效，旧值为 "0"，新值为 "-1"。

SELECT
t1.id,
t1.sale_price,
t1.country,
t1.source_name,
t1.customer_id,
t1.source_id,
t1.update_time,
t1.msku,
t1.asin,
t1.sku,
la.listing_price,
t1.business_user_id,
t1.business_user_name,
t1.currency,
lepa.rating_star,
pmihr.inv_age_0_to_90_days,
pmihr.inv_age_91_to_180_days,
pmihr.inv_age_181_to_270_days,
pmihr.inv_age_271_to_365_days,
pmihr.inv_age_365_plus_days,
pmihr.inv_age_90_plus_days,
pmihr.inv_age_180_plus_days,
t1.parent_asin,
t1.listing_method,
t1.publish_time,
t1.seller_id,
t1.marketplace_id,
t1.warehouse,
la.discount_start,
la.discount_end,
t1.delivery_type
FROM
t_amazon_listing_12 t1
LEFT JOIN t_amazon_listing_amount_12 la ON t1.id = la.id
LEFT JOIN plat_manage_inventory_health_report pmihr ON pmihr.order_source_id = t1.source_id
AND pmihr.sku = t1.msku
AND pmihr.asin = t1.asin
LEFT JOIN t_amazon_listing_tag_12 lt ON t1.id = lt.listing_id
LEFT JOIN t_amazon_listing_extra_asin_us lea ON lea.marketplace_id = t1.marketplace_id
AND lea.asin = t1.asin
LEFT JOIN t_amazon_listing_extra_parent_asin_us lepa ON lepa.marketplace_id = t1.marketplace_id
AND lepa.asin = t1.asin
AND lepa.asin_type = 0
WHERE
t1.is_deleted = 0
AND t1.msku IN (
'0044XYH11MTCH6',
'09OK2845T0OJJCK3XRI7',
'0D170ED3197E1VN16NOYLPC',
'1816518BO0X5515',
'1840547VP0G5515',
'1B19N745S2604K509MHATZ4',
'2024IR910BE',
'2110GCI17PK',
'22SGD09R58IPD',
'2EK24KUFW12K11C6H3O4F6IJ',
'31I8KR511218OB',
'3254KWXVXLO11RC7Y2NF1KE',
'3500215BYV06O7MNBQ7W7NEV',
'3I92T19O451101KYSIN',
'424V6IBBJE30BH015EO',
'42I22NLC259U6H11KJ7OZ1SJ8',
'4511I19AFDE7Y',
'45EXCE18W9F90ZL18F659',
'4DZM53J16K5C141AOHAHXG',
'6417210CCL8R3CGY6D',
'7O32EOE1404RH0VD1OR6',
'8N16QK257U22KC21GWGW',
'91308AXN6N422UPUMM9GBC',
'96L7H533315X3',
'A450083M212MK9UJTZ58',
'A5X14SPC2538MPC37EBNSUHA',
'ABO9G8PD23Y213114CZN6',
'C28W1915R3KJ',
'C3187142RK',
'D102K612488P',
'E2CWWIY5GK545213XVE',
'F27Y145439',
'F54YZEFV2317F3BN6NLAESGB',
'G31V2XMTE43V36O5185E',
'GYYK42858R13L63ZIRH',
'H4424JQR00CMN103',
'I25V0F64JNWCU31601TDZDL',
'I5032T09L14Q',
'ID4552L02MU16Y',
'IP02234515Y6',
'K06AR1004QGVR',
'K39I02QMM2D814SUZ',
'KI16043IBC833LGVQYU15JOK',
'M146P02BF0599W2R',
'MMLGU1442D36B0N40Z',
'O46V3161E10GQ',
'PI2651241OE',
'Q2I15WI0429BISZ5ZOCGXHA',
'R55V1384XPYW',
'RY3CL314118W40GEQ',
'TQPJ052IIENNBQ1488Z1Z05J',
'WCV1268XD0160',
'WUV51S116Y57NC4SKXYKF',
'Y505UHP51TR13R',
'Z1006N22GCQ5Z3017IYUYLM'
)
AND t1.asin IS NOT NULL
AND t1.asin != ''
AND t1.seller_id IS NOT NULL
AND t1.marketplace_id IS NOT NULL
AND t1.source_id = 6891
AND t1.country = 'US'
AND la.listing_price BETWEEN '1.0000'
AND '100.0000'

LIMIT 200

2024-03-17 22:31:11, 由 张粤利 编辑。

修改了 解决时效，旧值为 "0"，新值为 "53.73"。
修改了 上线时效，旧值为 "-1"，新值为 "17744584.78"。

select t1.id, t1.sale_price, t1.country, t1.source_name, t1.customer_id, t1.source_id, t1.update_time, t1.msku, t1.asin, t1.sku, la.listing_price, t1.business_user_id, t1.business_user_name, t1.currency, lepa.rating_star, pmihr.inv_age_0_to_90_days, pmihr.inv_age_91_to_180_days, pmihr.inv_age_181_to_270_days, pmihr.inv_age_271_to_365_days, pmihr.inv_age_365_plus_days, pmihr.inv_age_90_plus_days, pmihr.inv_age_180_plus_days, t1.parent_asin, t1.listing_method, t1.publish_time, t1.seller_id, t1.marketplace_id, t1.warehouse, la.discount_start, la.discount_end, t1.delivery_type from t_amazon_listing_${tab} t1 left join t_amazon_listing_amount_${tab} la on t1.id=la.id left join plat_manage_inventory_health_report pmihr on pmihr.order_source_id=t1.source_id and pmihr.sku=t1.msku and pmihr.asin=t1.asin left join t_amazon_listing_tag_${tab} lt on t1.id=lt.listing_id left join t_amazon_listing_extra_asin_${tabCountry} lea on lea.marketplace_id = t1.marketplace_id AND lea.asin = t1.asin left join t_amazon_listing_extra_parent_asin_${tabCountry} lepa on lepa.marketplace_id = t1.marketplace_id AND lepa.asin = t1.asin  AND lepa.asin_type = 0 where

t1.is_deleted=0 and t1.asin is not null and t1.asin !='' and t1.seller_id is not null and t1.marketplace_id is not null <if test="qry.sourceId != null">  and t1.source_id = #{qry.sourceId} </if> <if test="qry.sourceCountryCode != null and qry.sourceCountryCode != ''">  and t1.country = #{qry.sourceCountryCode,jdbcType=VARCHAR} </if> <if test="qry.minSellingPrice != null and qry.maxSellingPrice != null">  and la.listing_price between #{qry.minSellingPrice,jdbcType=DECIMAL} and  #{qry.maxSellingPrice,jdbcType=DECIMAL} </if> <if test="qry.numDaysAvailableMin != null and qry.numDaysAvailableMax != null">  and t1.available_day between #{qry.numDaysAvailableMin,jdbcType=INTEGER} and  #{qry.numDaysAvailableMax,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL1 != null and qry.libraryAgeMaxL1 != null">  and pmihr.inv_age_0_to_90_days between #{qry.libraryAgeMinL1,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL1,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL2 != null and qry.libraryAgeMaxL2 != null">  and pmihr.inv_age_91_to_180_days between #{qry.libraryAgeMinL2,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL2,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL3 != null and qry.libraryAgeMaxL3 != null">  and pmihr.inv_age_181_to_270_days between #{qry.libraryAgeMinL3,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL3,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL4 != null and qry.libraryAgeMaxL4 != null">  and pmihr.inv_age_271_to_365_days between #{qry.libraryAgeMinL4,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL4,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL5 != null and qry.libraryAgeMaxL5 != null">  and pmihr.inv_age_365_plus_days between #{qry.libraryAgeMinL5,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL5,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL6 != null and qry.libraryAgeMaxL6 != null">  and pmihr.inv_age_90_plus_days between #{qry.libraryAgeMinL6,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL6,jdbcType=INTEGER} </if> <if test="qry.libraryAgeMinL7 != null and qry.libraryAgeMaxL7 != null">  and pmihr.inv_age_180_plus_days between #{qry.libraryAgeMinL7,jdbcType=INTEGER} and  #{qry.libraryAgeMaxL7,jdbcType=INTEGER} </if> <if test="qry.dayIssuedMin != null and qry.dayIssuedMax != null">  and TIMESTAMPDIFF(DAY,t1.publish_time,NOW()) between #{qry.dayIssuedMin,jdbcType=INTEGER} and  #{qry.dayIssuedMax,jdbcType=INTEGER} </if> <if test="qry.asinFirstOrderMin != null and qry.asinFirstOrderMax != null">  and TIMESTAMPDIFF(DAY,lea.asin_first_order_time,NOW()) between  #{qry.asinFirstOrderMin,jdbcType=INTEGER}  and #{qry.asinFirstOrderMax,jdbcType=INTEGER} </if> <if test="qry.issuedTimeMin != null and qry.issuedTimeMax != null">  and t1.publish_time between #{qry.issuedTimeMin,jdbcType=TIMESTAMP} and  #{qry.issuedTimeMax,jdbcType=TIMESTAMP} </if> <if test="qry.asinFirstOrderTimeMin != null and qry.asinFirstOrderTimeMax != null">  and lea.asin_first_order_time between #{qry.asinFirstOrderTimeMin,jdbcType=TIMESTAMP} and  #{qry.asinFirstOrderTimeMax,jdbcType=TIMESTAMP} </if> <if test="qry.asinFirstTimeMin != null and qry.asinFirstTimeMax != null">  and lea.asin_first_arrival_time between  #{qry.asinFirstTimeMin,jdbcType=TIMESTAMP}  and #{qry.asinFirstTimeMax,jdbcType=TIMESTAMP} </if> <if test="qry.despatchMode != null">  and t1.delivery_type=#{qry.despatchMode,jdbcType=TINYINT} </if> <if test="qry.listingSoldNumMin != null and qry.listingSoldNumMax != null">  and t1.quality between  #{qry.listingSoldNumMin,jdbcType=INTEGER}  and #{qry.listingSoldNumMax,jdbcType=INTEGER} </if>  <if test="qry.getSkus() != null and qry.getSkus().size()>0">  and t1.sku in  <foreach close=")" collection="qry.getSkus()" item="item" open="(" separator=", ">  #{item,jdbcType=BIGINT}  </foreach> </if> <if test="qry.getOrderSourceSkuList() != null and qry.getOrderSourceSkuList().size()>0">  and t1.msku in  <foreach close=")" collection="qry.getOrderSourceSkuList()" item="item" open="(" separator=", ">  #{item,jdbcType=BIGINT}  </foreach> </if> <if test="qry.getHolidaysIds() != null and qry.getHolidaysIds().size()>0">  AND lt.type = 1 and lt.tag_id in  <foreach close=")" collection="qry.getHolidaysIds()" item="item" open="(" separator=", ">  #{item,jdbcType=BIGINT}  </foreach> </if> <if test="qry.getPublishTypes() != null and qry.getPublishTypes().size()>0">  and t1.listing_method in  <foreach close=")" collection="qry.getPublishTypes()" item="item" open="(" separator=", ">  #{item,jdbcType=BIGINT}  </foreach> </if> <if test="qry.getOrderSourceSkuDenyList() != null and qry.getOrderSourceSkuDenyList().size()>0">  and t1.msku not in  <foreach close=")" collection="qry.getOrderSourceSkuDenyList()" item="item" open="(" separator=", ">  #{item,jdbcType=BIGINT}  </foreach> </if> <if test="qry.getAddAdminIds() != null and qry.getAddAdminIds().size() > 0">  and t1.listing_person in  <foreach close=")" collection="qry.getAddAdminIds()" item="item" open="(" separator=", ">  #{item,jdbcType=INTEGER}  </foreach> </if> <if test="qry.lastMaxId != null and qry.lastMaxId > 0">  and t1.id > #{qry.lastMaxId} </if>

limit #{qry.pageSize}

2024-03-18 10:32:46, 由 张粤利 解决，方案为 非BUG-纯属误判 。
修改了 解决方案，旧值为 ""，新值为 "feiBUG"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2024-03-18 10:32:39"。
修改了 指派给 ，旧值为 "zhangyueli"，新值为 "laoshixian"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "zhangyueli"。
2024-03-18 14:03:33, 由 劳世仙 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "laoshixian"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "laoshixian"。
修改了 关闭日期，旧值为 ""，新值为 "2024-03-18 14:03:33"。

确认为非bug

SELECT
t1.id,
t1.sale_price,
t1.country,
t1.source_name,
t1.customer_id,
t1.source_id,
t1.update_time,
t1.msku,
t1.asin,
t1.sku,
la.listing_price,
t1.business_user_id,
t1.business_user_name,
t1.currency,
lepa.rating_star,
pmihr.inv_age_0_to_90_days,
pmihr.inv_age_91_to_180_days,
pmihr.inv_age_181_to_270_days,
pmihr.inv_age_271_to_365_days,
pmihr.inv_age_365_plus_days,
pmihr.inv_age_90_plus_days,
pmihr.inv_age_180_plus_days,
t1.parent_asin,
t1.listing_method,
t1.publish_time,
t1.seller_id,
t1.marketplace_id,
t1.warehouse,
la.discount_start,
la.discount_end,
t1.delivery_type
FROM
t_amazon_listing_12 t1
LEFT JOIN t_amazon_listing_amount_12 la ON t1.id = la.id
LEFT JOIN plat_manage_inventory_health_report pmihr ON pmihr.order_source_id = t1.source_id
AND pmihr.sku = t1.msku
AND pmihr.asin = t1.asin
LEFT JOIN t_amazon_listing_tag_12 lt ON t1.id = lt.listing_id
LEFT JOIN t_amazon_listing_extra_asin_us lea ON lea.marketplace_id = t1.marketplace_id
AND lea.asin = t1.asin
LEFT JOIN t_amazon_listing_extra_parent_asin_us lepa ON lepa.marketplace_id = t1.marketplace_id
AND lepa.asin = t1.asin
AND lepa.asin_type = 0
WHERE
t1.is_deleted = 0
AND t1.msku IN (
"00002XSROPOC30D1KOX47K8C","000073GNBAP","000104UH503SOQ9CEE","0001902PQU","0001FL1018Z7R","0004CY17SYMC","0004GA0046HXX","000505X56MCAFD","0005132Z7N","000525C9XV8","00059Q47025C","00063OIRT17R","00065RA05V","0007HG35GWX","000905RYX669L","000NFDSD80143K1YAR","000NR53C050Q","000O41XK14F42","000QFAS36SDUJ58ZQXPGG08","000VHYQ48R20CG3364SLN0J","000ZA5E58F53UL6","00102P13VWI1","001033V5ABHRXT81X10Q64PP","001050D0ZF1N743KXJ7I","001313BOUAZ","0013222617","00133Q01KB95A","00133QW11WJ8","001348SUM67P","00134XU23M1","0013K617FKT3C","00142OK23V","00144253YLRMD6","0014468IPJ","001545D86KUH","0015GF17WLWV656Y6","001754AQG51BF3X","00175531EC","0017LTUQV7J6W292QS6CU","0017NAV055O68T4GO","0018320XO9","0018503E2OC","0018735RG956EOYAKUZAO7TL","001973H00JZN1P","001B139K50578","002002006J9","002021MKR8","002144BHV336GWKKUE9U","002314Q7LR8ZDYO9","002325Z10UMF","0023FYGF14OI9TMHEEG","0023N28LQ6","0023WX09D9NZWNX","0024136411","0024VJ1714D","0025AKYW16OBCKAN","0025PK16IVQH","00265GKX45JD24QCT70WZKQR","00272L18CR","0027Y18YEKD5LKOXQRYEB2X","0028J53BFKN","0028VT851PFR","002AV29D173RX","0030624202","0031403EVB","00324J2DLV71EFLC108","0032AHW201","0032AJLZ01952DQVHGJ","0032BZFJKSXK067P","0032W4Q132F7E492D4AFH","003346QEHAE7","0034B6WR08C5JM","0034CNZ809MU14","00350535ZRYU9C9","003505B16KU","003516U2PNWJ","00358003NDU","0035M03WRL","00389322KFIBU1WA7","00398RLXTA712HXE5Q","0039VT4160Z","003Q2R4820A","003Y9KUSHO6W19JZRAL7J075","0040194K19QOVFIS","00401JY18LM","004028BRGWG7","0040Q617Y2X","0041800RZW","00427W56SSPDEC5","004394Q8OX0SE","0044QQ4LV03Y33ICLNN2NP","0045532P834","0046OW42LJG9S14J","0047A06T1ZE2ZJF","0049GSB7K9QJ04P3H","0049NSY1188CAFQ","004C1941CUM1YK8SUJHOZC","004NR085Q4JRCSEZ06EU54FY","004OPUAO39YF9CLD7B14IUNXV","004P09484BAY","004ZM02VPSWQH21NE279Q49","0050554EQ1INK","00506C6GNI3559PXIF","0050ZTFS012W2GS","00516AA0422B","0051749ZWS7","0051D036100VEBL2Q","005208ZLYRG439A","005264TPFQ","005337D2ZV217Q0","005387S1N6FRWXWP","0053CBVS2HP31AHXH","005411C61QPRIM6FY","005414YX5B","0054G511J9","0056JVCAD01157LCDBE","0056RFQXHGJM519LDX6LI4H","005751970LB","0058047WQX","0058224S6X4","005906EL9YSGZ62YB","0059W56YI81B","005T317BWP558449WP5J","005VY5122K","0061818S4T1KRP4SU","00620OKE033UKG","00629YHIY115","00634631MUK2P","0063AW94K022KQOEFA5","0065415FH9","0066X12U3KGJM4","0069855YE18N","0069OY52WOF5LY","006K2ZYGZ2865234R6UA","006KQX3095A1X7","006O1504P7","006W10WAOT220J417OJ36","0070AS1VQ8F25M4M2SK160","00737MOF9LS60913NZ4B","0074422325","007560I7ZKKW","0075Z207GA","00773BIR32E5LN3P","0078J37V09T58GC8R","007A0904KD","007CG4004G","007G2502372F21","00803257DH5","00807V15T18Y","0081C8PPBGQTY8Y3015T","008205ZVK2P3Q","0082911H8SW2PZE5OFTJOR","0082WH2IV30EXCXY24Y","0083OQN5177","0084D5S7T726JTMHL","0085552U5WGA47KY79CSLTN","0087Z4HKM05FWOR","0088LOR29KY472VUX","0089X4V1Q26F17","008O5W641M1250981H3","00905777JLTW4","0091449MA4","00914I21I6G","0092IYU60RRBJP5522B","00936WXE44Z1VZ","00937DOOLMJKUB19S0KQOS","009550MSO23502RNL5DLJ9M","00962T3ZA171SRRI71","0097JKKM9011GCUSD9B","009BNK37X406XFA73","009NJ522006XDF","009Q9TFKDMH21626CHT265Z7R","009S4317S5UERKX1T8MDB","00A5521PN6Q","00B34CS09S4534M5R01XX","00BD029RQRSX5X18WY","00BL2VT16P5X00OXD1GCKT6","00BX51QR7H7HE06A7","00CD37A18U","00CT05017C32","00D654JG10U","00E1534SVJ3B","00E25LBCR0022CVYF156P9","00E4BOC3413331ENACZL15G","00FCY67H04715GJ5TI2ST18Z","00FZ433BBK08Y44AEPV2Y","00FZBH28VQ119","00G0F915B06OQ5A","00G16W019J","00G27ZNG6MZZSGU13CE6BRC","00HO3115E62XUK15E2MV","00HQ4413XYJFOG4IK","00HV06132YVF","00IDBCKE56E10EIK","00IS9AB5OGYSK95566Q15I","00IVKPZ1452U076","00J24UAQ55UXTX","00J53EAB28UK5DV","00JN6MO3914VB","00JXGWA3801044GTFV","00K4643HPHY4GHG1333CI02","00K9U1R9C31BB3V11IW","00KK4654FWO","00KYLE34P7U4177KE34QZ3YU","00L00QTZGZ2426ODEYA","00L20H17I7","00LWD2628A9S","00M27A17U8KOUJSMGMH5YXM","00M3383SI4L11Z6272WK41I","00N06B2D42C3ER4Z","00N15222ZV","00NV258QOR1012J7","00O15GYDU57XQ9","00O3157E54IC6","00O7GEQ8YYXA562PX30FQO","00OXHTA11544LWPU","00P25057CE","00P29T30E1Z","00P36UY81RPT02014P61KIOJP","152BF845GR94039","16042806E12H","59XPYL4H03N345X7PA3T4WR","A27V50004A","HKCOLQ4015204MDX","OC029J003A604OCEI","QYCSC2IG200250VVR20P6H040","Y3A25542176"
)
AND t1.asin IS NOT NULL
AND t1.asin != ''
AND t1.seller_id IS NOT NULL
AND t1.marketplace_id IS NOT NULL
AND t1.source_id = 6891
AND t1.country = 'US'
AND la.listing_price BETWEEN '1.0000'
AND '100.0000'

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	亚马逊
所属计划
所属迭代	亚马逊产品线 - listingV1切换项目
Bug类型	程序BUG
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效	53.73
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2024-03-18 14:03:33
截止日期	0000-00-00
上线时间	0000-00-00 00:00:00
上线时效	17744600
操作系统	全部
浏览器	chrome
关键词
抄送给

所属迭代	亚马逊产品线 - listingV1切换项目
相关需求	#18391 IMS-AMZ：优惠券系统迁移到新java架构
相关任务	IMS-AMZ：优惠券系统迁移到新java架构 --测试执行

Bug的一生
其他相关

由谁创建	劳世仙于 2024-03-15 16:46:52
影响环境	测试环境-测试反馈
由谁解决	张粤利于 2024-03-18 10:32:39
解决版本	主干
解决方案	非BUG-纯属误判
由谁关闭	劳世仙于 2024-03-18 14:03:33
最后修改	劳世仙于 2024-03-18 14:03:33

相关Bug