You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
POST Request to endpoint: store/carts/{cart_id}/shipping-methods
I can select shipping option when a product has 1 variant.
When a product has 2 or more variants , the database will throw error
2024-12-25 16:15:55.087 UTC [839] ERROR: operator does not exist: text = record at character 6844
2024-12-25 16:15:55.087 UTC [839] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2024-12-25 16:15:55.087 UTC [839] STATEMENT: select "price"."id" as "id", "ps"."id" as "price_set_id", "price"."amount" as "amount", "price"."raw_amount" as "raw_amount", "price"."min_quantity" as "min_quantity", "price"."max_quantity" as "max_quantity", "price"."currency_code" as "currency_code", "price"."rules_count" as "rules_count", "price"."pl_rules_count" as "pl_rules_count", "price"."pl_type" as "price_list_type", "price"."price_list_id" as "price_list_id", COALESCE(price.rules_count, 0) + COALESCE(price.pl_rules_count, 0) as "all_rules_count" from "price_set" as "ps" inner join (select "price"."id" as "id", "price"."amount" as "amount", "price"."raw_amount" as "raw_amount", "price"."min_quantity" as "min_quantity", "price"."max_quantity" as "max_quantity", "price"."currency_code" as "currency_code", "price"."price_set_id" as "price_set_id", "price"."rules_count" as "rules_count", "price"."price_list_id" as "price_list_id", "pl"."rules_count" as "pl_rules_count", "pl"."type" as "pl_type", case when price.price_list_id IS NULL then False else True end as "has_price_list" from "price" as "price" left join "price_rule" as "pr" on "pr"."price_id" = "price"."id" left join "price_list" as "pl" on "pl"."id" = "price"."price_list_id" and "pl"."status" = $1 left join "price_list_rule" as "plr" on "plr"."price_list_id" = "pl"."id" where ("price"."price_list_id" is null and (("pr"."attribute" = $2 and "pr"."value" in ($3)) or ("pr"."attribute" = $4 and "pr"."value" in ($5)) or ("pr"."attribute" = $6 and "pr"."value" in ($7)) or ("pr"."attribute" = $8 and ("pr"."operator" = $9 and $10 >= pr.value::numeric) or ("pr"."operator" = $11 and $12 > pr.value::numeric) or ("pr"."operator" = $13 and $14 < pr.value::numeric) or ("pr"."operator" = $15 and $16 <= pr.value::numeric) or ("pr"."operator" = $17 and $18 = pr.value::numeric)) or ("pr"."attribute" = $19 and ("pr"."operator" = $20 and $21 >= pr.value::numeric) or ("pr"."operator" = $22 and $23 > pr.value::numeric) or ("pr"."operator" = $24 and $25 < pr.value::numeric) or ("pr"."operator" = $26 and $27 <= pr.value::numeric) or ("pr"."operator" = $28 and $29 = pr.value::numeric)) or ("pr"."attribute" = $30 and "pr"."value" in ($31)) or ("pr"."attribute" = $32 and "pr"."value" in ($33)) or ("pr"."attribute" = $34 and "pr"."value" in ($35)) or ("pr"."attribute" = $36 and "pr"."value" in ($37)) or ("pr"."attribute" = $38 and "pr"."value" in ($39)) or ("pr"."attribute" = $40 and "pr"."value" in ($41)) or ("pr"."attribute" = $42 and "pr"."value" in ($43, $44, $45)) or ("pr"."attribute" = $46 and "pr"."value" in ($47, $48, $49)) or ("pr"."attribute" = $50 and "pr"."value" in ($51, $52, $53)) or ("pr"."attribute" = $54 and "pr"."value" in ($55, $56, $57)) or ("pr"."attribute" = $58 and "pr"."value" in ($59, $60, $61)) or ("pr"."attribute" = $62 and "pr"."value" in ($63, $64, $65)) or ("pr"."attribute" = $66 and "pr"."value" in ($67, $68, $69)) or ("pr"."attribute" = $70 and "pr"."value" in ($71, $72, $73)) or ("pr"."attribute" = $74 and "pr"."value" in ($75, $76, $77)) or ("pr"."attribute" = $78 and "pr"."value" in ($79, $80, $81)) or ("pr"."attribute" = $82 and "pr"."value" in ($83, $84, $85)) or ("pr"."attribute" = $86 and "pr"."value" in ($87, $88, $89)) or ("pr"."attribute" = $90 and "pr"."value" in ($91, $92, $93)) or ("pr"."attribute" = $94 and "pr"."value" in ($95, $96, $97)) or ("pr"."attribute" = $98 and "pr"."value" in ($99, $100, $101)) or ("pr"."attribute" = $102 and "pr"."value" in ($103, $104, $105)) or ("pr"."attribute" = $106 and "pr"."value" in ($107, $108, $109)) or ("pr"."attribute" = $110 and "pr"."value" in ($111, $112, $113)) or ("pr"."attribute" = $114 and "pr"."value" in ($115, $116, $117)) or ("pr"."attribute" = $118 and "pr"."value" in ($119, $120, $121)) or ("pr"."attribute" = $122 and "pr"."value" in ($123, $124, $125)) or ("pr"."attribute" = $126 and "pr"."value" in ($127, $128, $129)) or ("pr"."attribute" = $130 and "pr"."value" in ($131, $132, $133)) or ("pr"."attribute" = $134 and "pr"."value" in ($135, $136, $137)) or ("pr"."attribute" = $138 and "pr"."value" in ($139, $140, $141)) or ("pr"."attribute" = $142 and "pr"."value" in ($143, $144, $145)) or ("pr"."attribute" = $146 and "pr"."value" in ($147, $148, $149)) or ("pr"."attribute" = $150 and "pr"."value" in ($151, $152, $153)) or ("pr"."attribute" = $154 and "pr"."value" in ($155, $156, $157)) or ("pr"."attribute" = $158 and "pr"."value" in ($159, $160, $161)) or ("pr"."attribute" = $162 and "pr"."value" in ($163, $164, $165)) or ("pr"."attribute" = $166 and "pr"."value" in ($167, $168, $169)) or ("pr"."attribute" = $170 and "pr"."value" in ($171, $172, $173)) or ("pr"."attribute" = $174 and "pr"."value" in ($175, $176, $177)) or ("pr"."attribute" = $178 and "pr"."value" in ($179, $180, $181)) or ("pr"."attribute" = $182 and "pr"."value" in ($183, $184, $185)) or ("pr"."attribute" = $186 and "pr"."value" in ($187, $188, $189)) or ("pr"."attribute" = $190 and "pr"."value" in ($191, $192, $193)) or ("pr"."attribute" = $194 and "pr"."value" in ($195, $196, $197)) or ("pr"."attribute" = $198 and "pr"."value" in ($199, $200, $201)) or ("pr"."attribute" = $202 and "pr"."value" in ($203, $204, $205)) or ("pr"."attribute" = $206 and "pr"."value" in ($207, $208, $209)) or ("pr"."attribute" = $210 and "pr"."value" in ($211, $212, $213)) or ("pr"."attribute" = $214 and "pr"."value" in ($215, $216, $217)) or ("pr"."attribute" = $218 and "pr"."value" in ($219, $220, $221)) or ("pr"."attribute" = $222 and "pr"."value" in ($223, $224, $225)) or ("pr"."attribute" = $226 and "pr"."value" in ($227, $228, $229)) or ("pr"."attribute" = $230 and "pr"."value" in ($231, $232, $233)) or ("pr"."attribute" = $234 and "pr"."value" in ($235, $236, $237)) or ("pr"."attribute" = $238 and "pr"."value" in ($239, $240, $241)) or ("pr"."attribute" = $242 and "pr"."value" in ($243, $244, $245)) or ("pr"."attribute" = $246 and "pr"."value" in ($247, $248, $249)) or ("pr"."attribute" = $250 and "pr"."value" in ($251, $252, $253)) or ("pr"."attribute" = $254 and "pr"."value" in ($255, $256, $257)) or ("pr"."attribute" = $258 and "pr"."value" in ($259, $260, $261)) or ("pr"."attribute" = $262 and "pr"."value" in ($263, $264, $265)) or ("pr"."attribute" = $266 and "pr"."value" in ($267, $268, $269)) or ("pr"."attribute" = $270 and "pr"."value" in ($271, $272, $273)) or ("pr"."attribute" = $274 and "pr"."value" in ($275, $276, $277)) or ("pr"."attribute" = $278 and "pr"."value" in ($279, $280, $281)) or ("pr"."attribute" = $282 and "pr"."value" in ($283, $284, $285)) or ("pr"."attribute" = $286 and "pr"."value" in ($287, $288, $289)) or ("pr"."attribute" = $290 and "pr"."value" in ($291, $292, $293)) or ("pr"."attribute" = $294 and "pr"."value" in ($295, $296, $297)) or ("pr"."attribute" = $298 and "pr"."value" in ($299, $300, $301)) or ("pr"."attribute" = $302 and "pr"."value" in (($303), ($304), ($305, $306))) or "price"."rules_count" = $307)) or ("price"."price_list_id" is not null and "pl"."deleted_at" is null and ("pl"."starts_at" is null or "pl"."starts_at" <= CURRENT_TIMESTAMP) and ("pl"."ends_at" is null or "pl"."ends_at" >= CURRENT_TIMESTAMP) and ((("plr"."attribute" = $308) and "plr"."value" @> $309 or ("plr"."attribute" = $310) and "plr"."value" @> $311 or ("plr"."attribute" = $312) and "plr"."value" @> $313 or ("plr"."attribute" = $314) and "plr"."value" @> $315 or ("plr"."attribute" = $316) and "plr"."value" @> $317 or ("plr"."attribute" = $318) and "plr"."value" @> $319 or ("plr"."attribute" = $320) and "plr"."value" @> $321 or ("plr"."attribute" = $322) and "plr"."value" @> $323 or ("plr"."attribute" = $324) and "plr"."value" @> $325 or ("plr"."attribute" = $326) and "plr"."value" @> $327 or ("plr"."attribute" = $328) and "plr"."value" @> $329 or ("plr"."attribute" = $330) and "plr"."value" @> $331 or ("plr"."attribute" = $332) and "plr"."value" @> $333 or ("plr"."attribute" = $334) and "plr"."value" @> $335 or ("plr"."attribute" = $336) and "plr"."value" @> $337 or ("plr"."attribute" = $338) and "plr"."value" @> $339 or ("plr"."attribute" = $340) and "plr"."value" @> $341 or ("plr"."attribute" = $342) and "plr"."value" @> $343 or ("plr"."attribute" = $344) and "plr"."value" @> $345 or ("plr"."attribute" = $346) and "plr"."value" @> $347 or ("plr"."attribute" = $348) and "plr"."value" @> $349 or ("plr"."attribute" = $350) and "plr"."value" @> $351 or ("plr"."attribute" = $352) and "plr"."value" @> $353 or ("plr"."attribute" = $354) and "plr"."value" @> $355 or ("plr"."attribute" = $356) and "plr"."value" @> $357 or ("plr"."attribute" = $358) and "plr"."value" @> $359 or ("plr"."attribute" = $360) and "plr"."value" @> $361 or ("plr"."attribute" = $362) and "plr"."value" @> $363 or ("plr"."attribute" = $364) and "plr"."value" @> $365 or ("plr"."attribute" = $366) and "plr"."value" @> $367 or ("plr"."attribute" = $368) and "plr"."value" @> $369 or ("plr"."attribute" = $370) and "plr"."value" @> $371 or ("plr"."attribute" = $372) and "plr"."value" @> $373 or ("plr"."attribute" = $374) and "plr"."value" @> $375 or ("plr"."attribute" = $376) and "plr"."value" @> $377 or ("plr"."attribute" = $378) and "plr"."value" @> $379 or ("plr"."attribute" = $380) and "plr"."value" @> $381 or ("plr"."attribute" = $382) and "plr"."value" @> $383 or ("plr"."attribute" = $384) and "plr"."value" @> $385 or ("plr"."attribute" = $386) and "plr"."value" @> $387 or ("plr"."attribute" = $388) and "plr"."value" @> $389 or ("plr"."attribute" = $390) and "plr"."value" @> $391 or ("plr"."attribute" = $392) and "plr"."value" @> $393 or ("plr"."attribute" = $394) and "plr"."value" @> $395 or ("plr"."attribute" = $396) and "plr"."value" @> $397 or ("plr"."attribute" = $398) and "plr"."value" @> $399 or ("plr"."attribute" = $400) and "plr"."value" @> $401 or ("plr"."attribute" = $402) and "plr"."value" @> $403 or ("plr"."attribute" = $404) and "plr"."value" @> $405 or ("plr"."attribute" = $406) and "plr"."value" @> $407 or ("plr"."attribute" = $408) and "plr"."value" @> $409 or ("plr"."attribute" = $410) and "plr"."value" @> $411 or ("plr"."attribute" = $412) and "plr"."value" @> $413 or ("plr"."attribute" = $414) and "plr"."value" @> $415 or ("plr"."attribute" = $416) and "plr"."value" @> $417 or ("plr"."attribute" = $418) and "plr"."value" @> $419 or ("plr"."attribute" = $420) and "plr"."value" @> $421 or ("plr"."attribute" = $422) and "plr"."value" @> $423 or ("plr"."attribute" = $424) and "plr"."value" @> $425 or ("plr"."attribute" = $426) and "plr"."value" @> $427 or ("plr"."attribute" = $428) and "plr"."value" @> $429 or ("plr"."attribute" = $430) and "plr"."value" @> $431 or ("plr"."attribute" = $432) and "plr"."value" @> $433 or ("plr"."attribute" = $434) and "plr"."value" @> $435 or ("plr"."attribute" = $436) and "plr"."value" @> $437 or ("plr"."attribute" = $438) and "plr"."value" @> $439 or ("plr"."attribute" = $440) and "plr"."value" @> $441 or ("plr"."attribute" = $442) and "plr"."value" @> $443 or ("plr"."attribute" = $444) and "plr"."value" @> $445 or ("plr"."attribute" = $446) and "plr"."value" @> $447 or ("plr"."attribute" = $448) and "plr"."value" @> $449 or ("plr"."attribute" = $450) and "plr"."value" @> $451 or ("plr"."attribute" = $452) and "plr"."value" @> $453 or ("plr"."attribute" = $454) and "plr"."value" @> $455 or ("plr"."attribute" = $456) and "plr"."value" @> $457 or ("plr"."attribute" = $458) and "plr"."value" @> $459 or ("plr"."attribute" = $460) and "plr"."value" @> $461 or "pl"."rules_count" = $462) and ((("pr"."attribute" = $463 and "pr"."value" in ($464)) or ("pr"."attribute" = $465 and "pr"."value" in ($466)) or ("pr"."attribute" = $467 and "pr"."value" in ($468)) or ("pr"."attribute" = $469 and ("pr"."operator" = $470 and $471 >= pr.value::numeric) or ("pr"."operator" = $472 and $473 > pr.value::numeric) or ("pr"."operator" = $474 and $475 < pr.value::numeric) or ("pr"."operator" = $476 and $477 <= pr.value::numeric) or ("pr"."operator" = $478 and $479 = pr.value::numeric)) or ("pr"."attribute" = $480 and ("pr"."operator" = $481 and $482 >= pr.value::numeric) or ("pr"."operator" = $483 and $484 > pr.value::numeric) or ("pr"."operator" = $485 and $486 < pr.value::numeric) or ("pr"."operator" = $487 and $488 <= pr.value::numeric) or ("pr"."operator" = $489 and $490 = pr.value::numeric)) or ("pr"."attribute" = $491 and "pr"."value" in ($492)) or ("pr"."attribute" = $493 and "pr"."value" in ($494)) or ("pr"."attribute" = $495 and "pr"."value" in ($496)) or ("pr"."attribute" = $497 and "pr"."value" in ($498)) or ("pr"."attribute" = $499 and "pr"."value" in ($500)) or ("pr"."attribute" = $501 and "pr"."value" in ($502)) or ("pr"."attribute" = $503 and "pr"."value" in ($504, $505, $506)) or ("pr"."attribute" = $507 and "pr"."value" in ($508, $509, $510)) or ("pr"."attribute" = $511 and "pr"."value" in ($512, $513, $514)) or ("pr"."attribute" = $515 and "pr"."value" in ($516, $517, $518)) or ("pr"."attribute" = $519 and "pr"."value" in ($520, $521, $522)) or ("pr"."attribute" = $523 and "pr"."value" in ($524, $525, $526)) or ("pr"."attribute" = $527 and "pr"."value" in ($528, $529, $530)) or ("pr"."attribute" = $531 and "pr"."value" in ($532, $533, $534)) or ("pr"."attribute" = $535 and "pr"."value" in ($536, $537, $538)) or ("pr"."attribute" = $539 and "pr"."value" in ($540, $541, $542)) or ("pr"."attribute" = $543 and "pr"."value" in ($544, $545, $546)) or ("pr"."attribute" = $547 and "pr"."value" in ($548, $549, $550)) or ("pr"."attribute" = $551 and "pr"."value" in ($552, $553, $554)) or ("pr"."attribute" = $555 and "pr"."value" in ($556, $557, $558)) or ("pr"."attribute" = $559 and "pr"."value" in ($560, $561, $562)) or ("pr"."attribute" = $563 and "pr"."value" in ($564, $565, $566)) or ("pr"."attribute" = $567 and "pr"."value" in ($568, $569, $570)) or ("pr"."attribute" = $571 and "pr"."value" in ($572, $573, $574)) or ("pr"."attribute" = $575 and "pr"."value" in ($576, $577, $578)) or ("pr"."attribute" = $579 and "pr"."value" in ($580, $581, $582)) or ("pr"."attribute" = $583 and "pr"."value" in ($584, $585, $586)) or ("pr"."attribute" = $587 and "pr"."value" in ($588, $589, $590)) or ("pr"."attribute" = $591 and "pr"."value" in ($592, $593, $594)) or ("pr"."attribute" = $595 and "pr"."value" in ($596, $597, $598)) or ("pr"."attribute" = $599 and "pr"."value" in ($600, $601, $602)) or ("pr"."attribute" = $603 and "pr"."value" in ($604, $605, $606)) or ("pr"."attribute" = $607 and "pr"."value" in ($608, $609, $610)) or ("pr"."attribute" = $611 and "pr"."value" in ($612, $613, $614)) or ("pr"."attribute" = $615 and "pr"."value" in ($616, $617, $618)) or ("pr"."attribute" = $619 and "pr"."value" in ($620, $621, $622)) or ("pr"."attribute" = $623 and "pr"."value" in ($624, $625, $626)) or ("pr"."attribute" = $627 and "pr"."value" in ($628, $629, $630)) or ("pr"."attribute" = $631 and "pr"."value" in ($632, $633, $634)) or ("pr"."attribute" = $635 and "pr"."value" in ($636, $637, $638)) or ("pr"."attribute" = $639 and "pr"."value" in ($640, $641, $642)) or ("pr"."attribute" = $643 and "pr"."value" in ($644, $645, $646)) or ("pr"."attribute" = $647 and "pr"."value" in ($648, $649, $650)) or ("pr"."attribute" = $651 and "pr"."value" in ($652, $653, $654)) or ("pr"."attribute" = $655 and "pr"."value" in ($656, $657, $658)) or ("pr"."attribute" = $659 and "pr"."value" in ($660, $661, $662)) or ("pr"."attribute" = $663 and "pr"."value" in ($664, $665, $666)) or ("pr"."attribute" = $667 and "pr"."value" in ($668, $669, $670)) or ("pr"."attribute" = $671 and "pr"."value" in ($672, $673, $674)) or ("pr"."attribute" = $675 and "pr"."value" in ($676, $677, $678)) or ("pr"."attribute" = $679 and "pr"."value" in ($680, $681, $682)) or ("pr"."attribute" = $683 and "pr"."value" in ($684, $685, $686)) or ("pr"."attribute" = $687 and "pr"."value" in ($688, $689, $690)) or ("pr"."attribute" = $691 and "pr"."value" in ($692, $693, $694)) or ("pr"."attribute" = $695 and "pr"."value" in ($696, $697, $698)) or ("pr"."attribute" = $699 and "pr"."value" in ($700, $701, $702)) or ("pr"."attribute" = $703 and "pr"."value" in ($704, $705, $706)) or ("pr"."attribute" = $707 and "pr"."value" in ($708, $709, $710)) or ("pr"."attribute" = $711 and "pr"."value" in ($712, $713, $714)) or ("pr"."attribute" = $715 and "pr"."value" in ($716, $717, $718)) or ("pr"."attribute" = $719 and "pr"."value" in ($720, $721, $722)) or ("pr"."attribute" = $723 and "pr"."value" in ($724, $725, $726)) or ("pr"."attribute" = $727 and "pr"."value" in ($728, $729, $730)) or ("pr"."attribute" = $731 and "pr"."value" in ($732, $733, $734)) or ("pr"."attribute" = $735 and "pr"."value" in ($736, $737, $738)) or ("pr"."attribute" = $739 and "pr"."value" in ($740, $741, $742)) or ("pr"."attribute" = $743 and "pr"."value" in ($744, $745, $746)) or ("pr"."attribute" = $747 and "pr"."value" in ($748, $749, $750)) or ("pr"."attribute" = $751 and "pr"."value" in ($752, $753, $754)) or ("pr"."attribute" = $755 and "pr"."value" in ($756, $757, $758)) or ("pr"."attribute" = $759 and "pr"."value" in ($760, $761, $762)) or ("pr"."attribute" = $763 and "pr"."value" in (($764), ($765), ($766, $767))) and "price"."rules_count" > $768) or "price"."rules_count" = $769))) group by "price"."id", "pl"."id" having count(pr.attribute) = price.rules_count AND price.price_list_id IS NULL or count(DISTINCT plr.attribute) = pl.rules_count AND price.price_list_id IS NOT NULL) as "price" on "price"."price_set_id" = "ps"."id" where "ps"."id" in ($770) and "price"."currency_code" = $771 and ("price"."min_quantity" <= $772 or "price"."min_quantity" is null) order by "price"."has_price_list" asc, "all_rules_count" desc, "amount" asc
Expected behavior
I can select shipping option with product has many variants
Actual behavior
Error when select shipping option with product has many variants
Link to reproduction repo
private
The text was updated successfully, but these errors were encountered:
Package.json file
Node.js version
v20
Database and its version
Postgres 17
Operating system name and version
Debian 12
Browser name
No response
What happended?
POST Request to endpoint: store/carts/{cart_id}/shipping-methods
I can select shipping option when a product has 1 variant.
When a product has 2 or more variants , the database will throw error
2024-12-25 16:15:55.087 UTC [839] ERROR: operator does not exist: text = record at character 6844
2024-12-25 16:15:55.087 UTC [839] HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
2024-12-25 16:15:55.087 UTC [839] STATEMENT: select "price"."id" as "id", "ps"."id" as "price_set_id", "price"."amount" as "amount", "price"."raw_amount" as "raw_amount", "price"."min_quantity" as "min_quantity", "price"."max_quantity" as "max_quantity", "price"."currency_code" as "currency_code", "price"."rules_count" as "rules_count", "price"."pl_rules_count" as "pl_rules_count", "price"."pl_type" as "price_list_type", "price"."price_list_id" as "price_list_id", COALESCE(price.rules_count, 0) + COALESCE(price.pl_rules_count, 0) as "all_rules_count" from "price_set" as "ps" inner join (select "price"."id" as "id", "price"."amount" as "amount", "price"."raw_amount" as "raw_amount", "price"."min_quantity" as "min_quantity", "price"."max_quantity" as "max_quantity", "price"."currency_code" as "currency_code", "price"."price_set_id" as "price_set_id", "price"."rules_count" as "rules_count", "price"."price_list_id" as "price_list_id", "pl"."rules_count" as "pl_rules_count", "pl"."type" as "pl_type", case when price.price_list_id IS NULL then False else True end as "has_price_list" from "price" as "price" left join "price_rule" as "pr" on "pr"."price_id" = "price"."id" left join "price_list" as "pl" on "pl"."id" = "price"."price_list_id" and "pl"."status" = $1 left join "price_list_rule" as "plr" on "plr"."price_list_id" = "pl"."id" where ("price"."price_list_id" is null and (("pr"."attribute" = $2 and "pr"."value" in ($3)) or ("pr"."attribute" = $4 and "pr"."value" in ($5)) or ("pr"."attribute" = $6 and "pr"."value" in ($7)) or ("pr"."attribute" = $8 and ("pr"."operator" = $9 and $10 >= pr.value::numeric) or ("pr"."operator" = $11 and $12 > pr.value::numeric) or ("pr"."operator" = $13 and $14 < pr.value::numeric) or ("pr"."operator" = $15 and $16 <= pr.value::numeric) or ("pr"."operator" = $17 and $18 = pr.value::numeric)) or ("pr"."attribute" = $19 and ("pr"."operator" = $20 and $21 >= pr.value::numeric) or ("pr"."operator" = $22 and $23 > pr.value::numeric) or ("pr"."operator" = $24 and $25 < pr.value::numeric) or ("pr"."operator" = $26 and $27 <= pr.value::numeric) or ("pr"."operator" = $28 and $29 = pr.value::numeric)) or ("pr"."attribute" = $30 and "pr"."value" in ($31)) or ("pr"."attribute" = $32 and "pr"."value" in ($33)) or ("pr"."attribute" = $34 and "pr"."value" in ($35)) or ("pr"."attribute" = $36 and "pr"."value" in ($37)) or ("pr"."attribute" = $38 and "pr"."value" in ($39)) or ("pr"."attribute" = $40 and "pr"."value" in ($41)) or ("pr"."attribute" = $42 and "pr"."value" in ($43, $44, $45)) or ("pr"."attribute" = $46 and "pr"."value" in ($47, $48, $49)) or ("pr"."attribute" = $50 and "pr"."value" in ($51, $52, $53)) or ("pr"."attribute" = $54 and "pr"."value" in ($55, $56, $57)) or ("pr"."attribute" = $58 and "pr"."value" in ($59, $60, $61)) or ("pr"."attribute" = $62 and "pr"."value" in ($63, $64, $65)) or ("pr"."attribute" = $66 and "pr"."value" in ($67, $68, $69)) or ("pr"."attribute" = $70 and "pr"."value" in ($71, $72, $73)) or ("pr"."attribute" = $74 and "pr"."value" in ($75, $76, $77)) or ("pr"."attribute" = $78 and "pr"."value" in ($79, $80, $81)) or ("pr"."attribute" = $82 and "pr"."value" in ($83, $84, $85)) or ("pr"."attribute" = $86 and "pr"."value" in ($87, $88, $89)) or ("pr"."attribute" = $90 and "pr"."value" in ($91, $92, $93)) or ("pr"."attribute" = $94 and "pr"."value" in ($95, $96, $97)) or ("pr"."attribute" = $98 and "pr"."value" in ($99, $100, $101)) or ("pr"."attribute" = $102 and "pr"."value" in ($103, $104, $105)) or ("pr"."attribute" = $106 and "pr"."value" in ($107, $108, $109)) or ("pr"."attribute" = $110 and "pr"."value" in ($111, $112, $113)) or ("pr"."attribute" = $114 and "pr"."value" in ($115, $116, $117)) or ("pr"."attribute" = $118 and "pr"."value" in ($119, $120, $121)) or ("pr"."attribute" = $122 and "pr"."value" in ($123, $124, $125)) or ("pr"."attribute" = $126 and "pr"."value" in ($127, $128, $129)) or ("pr"."attribute" = $130 and "pr"."value" in ($131, $132, $133)) or ("pr"."attribute" = $134 and "pr"."value" in ($135, $136, $137)) or ("pr"."attribute" = $138 and "pr"."value" in ($139, $140, $141)) or ("pr"."attribute" = $142 and "pr"."value" in ($143, $144, $145)) or ("pr"."attribute" = $146 and "pr"."value" in ($147, $148, $149)) or ("pr"."attribute" = $150 and "pr"."value" in ($151, $152, $153)) or ("pr"."attribute" = $154 and "pr"."value" in ($155, $156, $157)) or ("pr"."attribute" = $158 and "pr"."value" in ($159, $160, $161)) or ("pr"."attribute" = $162 and "pr"."value" in ($163, $164, $165)) or ("pr"."attribute" = $166 and "pr"."value" in ($167, $168, $169)) or ("pr"."attribute" = $170 and "pr"."value" in ($171, $172, $173)) or ("pr"."attribute" = $174 and "pr"."value" in ($175, $176, $177)) or ("pr"."attribute" = $178 and "pr"."value" in ($179, $180, $181)) or ("pr"."attribute" = $182 and "pr"."value" in ($183, $184, $185)) or ("pr"."attribute" = $186 and "pr"."value" in ($187, $188, $189)) or ("pr"."attribute" = $190 and "pr"."value" in ($191, $192, $193)) or ("pr"."attribute" = $194 and "pr"."value" in ($195, $196, $197)) or ("pr"."attribute" = $198 and "pr"."value" in ($199, $200, $201)) or ("pr"."attribute" = $202 and "pr"."value" in ($203, $204, $205)) or ("pr"."attribute" = $206 and "pr"."value" in ($207, $208, $209)) or ("pr"."attribute" = $210 and "pr"."value" in ($211, $212, $213)) or ("pr"."attribute" = $214 and "pr"."value" in ($215, $216, $217)) or ("pr"."attribute" = $218 and "pr"."value" in ($219, $220, $221)) or ("pr"."attribute" = $222 and "pr"."value" in ($223, $224, $225)) or ("pr"."attribute" = $226 and "pr"."value" in ($227, $228, $229)) or ("pr"."attribute" = $230 and "pr"."value" in ($231, $232, $233)) or ("pr"."attribute" = $234 and "pr"."value" in ($235, $236, $237)) or ("pr"."attribute" = $238 and "pr"."value" in ($239, $240, $241)) or ("pr"."attribute" = $242 and "pr"."value" in ($243, $244, $245)) or ("pr"."attribute" = $246 and "pr"."value" in ($247, $248, $249)) or ("pr"."attribute" = $250 and "pr"."value" in ($251, $252, $253)) or ("pr"."attribute" = $254 and "pr"."value" in ($255, $256, $257)) or ("pr"."attribute" = $258 and "pr"."value" in ($259, $260, $261)) or ("pr"."attribute" = $262 and "pr"."value" in ($263, $264, $265)) or ("pr"."attribute" = $266 and "pr"."value" in ($267, $268, $269)) or ("pr"."attribute" = $270 and "pr"."value" in ($271, $272, $273)) or ("pr"."attribute" = $274 and "pr"."value" in ($275, $276, $277)) or ("pr"."attribute" = $278 and "pr"."value" in ($279, $280, $281)) or ("pr"."attribute" = $282 and "pr"."value" in ($283, $284, $285)) or ("pr"."attribute" = $286 and "pr"."value" in ($287, $288, $289)) or ("pr"."attribute" = $290 and "pr"."value" in ($291, $292, $293)) or ("pr"."attribute" = $294 and "pr"."value" in ($295, $296, $297)) or ("pr"."attribute" = $298 and "pr"."value" in ($299, $300, $301)) or ("pr"."attribute" = $302 and "pr"."value" in (($303), ($304), ($305, $306))) or "price"."rules_count" = $307)) or ("price"."price_list_id" is not null and "pl"."deleted_at" is null and ("pl"."starts_at" is null or "pl"."starts_at" <= CURRENT_TIMESTAMP) and ("pl"."ends_at" is null or "pl"."ends_at" >= CURRENT_TIMESTAMP) and ((("plr"."attribute" = $308) and "plr"."value" @> $309 or ("plr"."attribute" = $310) and "plr"."value" @> $311 or ("plr"."attribute" = $312) and "plr"."value" @> $313 or ("plr"."attribute" = $314) and "plr"."value" @> $315 or ("plr"."attribute" = $316) and "plr"."value" @> $317 or ("plr"."attribute" = $318) and "plr"."value" @> $319 or ("plr"."attribute" = $320) and "plr"."value" @> $321 or ("plr"."attribute" = $322) and "plr"."value" @> $323 or ("plr"."attribute" = $324) and "plr"."value" @> $325 or ("plr"."attribute" = $326) and "plr"."value" @> $327 or ("plr"."attribute" = $328) and "plr"."value" @> $329 or ("plr"."attribute" = $330) and "plr"."value" @> $331 or ("plr"."attribute" = $332) and "plr"."value" @> $333 or ("plr"."attribute" = $334) and "plr"."value" @> $335 or ("plr"."attribute" = $336) and "plr"."value" @> $337 or ("plr"."attribute" = $338) and "plr"."value" @> $339 or ("plr"."attribute" = $340) and "plr"."value" @> $341 or ("plr"."attribute" = $342) and "plr"."value" @> $343 or ("plr"."attribute" = $344) and "plr"."value" @> $345 or ("plr"."attribute" = $346) and "plr"."value" @> $347 or ("plr"."attribute" = $348) and "plr"."value" @> $349 or ("plr"."attribute" = $350) and "plr"."value" @> $351 or ("plr"."attribute" = $352) and "plr"."value" @> $353 or ("plr"."attribute" = $354) and "plr"."value" @> $355 or ("plr"."attribute" = $356) and "plr"."value" @> $357 or ("plr"."attribute" = $358) and "plr"."value" @> $359 or ("plr"."attribute" = $360) and "plr"."value" @> $361 or ("plr"."attribute" = $362) and "plr"."value" @> $363 or ("plr"."attribute" = $364) and "plr"."value" @> $365 or ("plr"."attribute" = $366) and "plr"."value" @> $367 or ("plr"."attribute" = $368) and "plr"."value" @> $369 or ("plr"."attribute" = $370) and "plr"."value" @> $371 or ("plr"."attribute" = $372) and "plr"."value" @> $373 or ("plr"."attribute" = $374) and "plr"."value" @> $375 or ("plr"."attribute" = $376) and "plr"."value" @> $377 or ("plr"."attribute" = $378) and "plr"."value" @> $379 or ("plr"."attribute" = $380) and "plr"."value" @> $381 or ("plr"."attribute" = $382) and "plr"."value" @> $383 or ("plr"."attribute" = $384) and "plr"."value" @> $385 or ("plr"."attribute" = $386) and "plr"."value" @> $387 or ("plr"."attribute" = $388) and "plr"."value" @> $389 or ("plr"."attribute" = $390) and "plr"."value" @> $391 or ("plr"."attribute" = $392) and "plr"."value" @> $393 or ("plr"."attribute" = $394) and "plr"."value" @> $395 or ("plr"."attribute" = $396) and "plr"."value" @> $397 or ("plr"."attribute" = $398) and "plr"."value" @> $399 or ("plr"."attribute" = $400) and "plr"."value" @> $401 or ("plr"."attribute" = $402) and "plr"."value" @> $403 or ("plr"."attribute" = $404) and "plr"."value" @> $405 or ("plr"."attribute" = $406) and "plr"."value" @> $407 or ("plr"."attribute" = $408) and "plr"."value" @> $409 or ("plr"."attribute" = $410) and "plr"."value" @> $411 or ("plr"."attribute" = $412) and "plr"."value" @> $413 or ("plr"."attribute" = $414) and "plr"."value" @> $415 or ("plr"."attribute" = $416) and "plr"."value" @> $417 or ("plr"."attribute" = $418) and "plr"."value" @> $419 or ("plr"."attribute" = $420) and "plr"."value" @> $421 or ("plr"."attribute" = $422) and "plr"."value" @> $423 or ("plr"."attribute" = $424) and "plr"."value" @> $425 or ("plr"."attribute" = $426) and "plr"."value" @> $427 or ("plr"."attribute" = $428) and "plr"."value" @> $429 or ("plr"."attribute" = $430) and "plr"."value" @> $431 or ("plr"."attribute" = $432) and "plr"."value" @> $433 or ("plr"."attribute" = $434) and "plr"."value" @> $435 or ("plr"."attribute" = $436) and "plr"."value" @> $437 or ("plr"."attribute" = $438) and "plr"."value" @> $439 or ("plr"."attribute" = $440) and "plr"."value" @> $441 or ("plr"."attribute" = $442) and "plr"."value" @> $443 or ("plr"."attribute" = $444) and "plr"."value" @> $445 or ("plr"."attribute" = $446) and "plr"."value" @> $447 or ("plr"."attribute" = $448) and "plr"."value" @> $449 or ("plr"."attribute" = $450) and "plr"."value" @> $451 or ("plr"."attribute" = $452) and "plr"."value" @> $453 or ("plr"."attribute" = $454) and "plr"."value" @> $455 or ("plr"."attribute" = $456) and "plr"."value" @> $457 or ("plr"."attribute" = $458) and "plr"."value" @> $459 or ("plr"."attribute" = $460) and "plr"."value" @> $461 or "pl"."rules_count" = $462) and ((("pr"."attribute" = $463 and "pr"."value" in ($464)) or ("pr"."attribute" = $465 and "pr"."value" in ($466)) or ("pr"."attribute" = $467 and "pr"."value" in ($468)) or ("pr"."attribute" = $469 and ("pr"."operator" = $470 and $471 >= pr.value::numeric) or ("pr"."operator" = $472 and $473 > pr.value::numeric) or ("pr"."operator" = $474 and $475 < pr.value::numeric) or ("pr"."operator" = $476 and $477 <= pr.value::numeric) or ("pr"."operator" = $478 and $479 = pr.value::numeric)) or ("pr"."attribute" = $480 and ("pr"."operator" = $481 and $482 >= pr.value::numeric) or ("pr"."operator" = $483 and $484 > pr.value::numeric) or ("pr"."operator" = $485 and $486 < pr.value::numeric) or ("pr"."operator" = $487 and $488 <= pr.value::numeric) or ("pr"."operator" = $489 and $490 = pr.value::numeric)) or ("pr"."attribute" = $491 and "pr"."value" in ($492)) or ("pr"."attribute" = $493 and "pr"."value" in ($494)) or ("pr"."attribute" = $495 and "pr"."value" in ($496)) or ("pr"."attribute" = $497 and "pr"."value" in ($498)) or ("pr"."attribute" = $499 and "pr"."value" in ($500)) or ("pr"."attribute" = $501 and "pr"."value" in ($502)) or ("pr"."attribute" = $503 and "pr"."value" in ($504, $505, $506)) or ("pr"."attribute" = $507 and "pr"."value" in ($508, $509, $510)) or ("pr"."attribute" = $511 and "pr"."value" in ($512, $513, $514)) or ("pr"."attribute" = $515 and "pr"."value" in ($516, $517, $518)) or ("pr"."attribute" = $519 and "pr"."value" in ($520, $521, $522)) or ("pr"."attribute" = $523 and "pr"."value" in ($524, $525, $526)) or ("pr"."attribute" = $527 and "pr"."value" in ($528, $529, $530)) or ("pr"."attribute" = $531 and "pr"."value" in ($532, $533, $534)) or ("pr"."attribute" = $535 and "pr"."value" in ($536, $537, $538)) or ("pr"."attribute" = $539 and "pr"."value" in ($540, $541, $542)) or ("pr"."attribute" = $543 and "pr"."value" in ($544, $545, $546)) or ("pr"."attribute" = $547 and "pr"."value" in ($548, $549, $550)) or ("pr"."attribute" = $551 and "pr"."value" in ($552, $553, $554)) or ("pr"."attribute" = $555 and "pr"."value" in ($556, $557, $558)) or ("pr"."attribute" = $559 and "pr"."value" in ($560, $561, $562)) or ("pr"."attribute" = $563 and "pr"."value" in ($564, $565, $566)) or ("pr"."attribute" = $567 and "pr"."value" in ($568, $569, $570)) or ("pr"."attribute" = $571 and "pr"."value" in ($572, $573, $574)) or ("pr"."attribute" = $575 and "pr"."value" in ($576, $577, $578)) or ("pr"."attribute" = $579 and "pr"."value" in ($580, $581, $582)) or ("pr"."attribute" = $583 and "pr"."value" in ($584, $585, $586)) or ("pr"."attribute" = $587 and "pr"."value" in ($588, $589, $590)) or ("pr"."attribute" = $591 and "pr"."value" in ($592, $593, $594)) or ("pr"."attribute" = $595 and "pr"."value" in ($596, $597, $598)) or ("pr"."attribute" = $599 and "pr"."value" in ($600, $601, $602)) or ("pr"."attribute" = $603 and "pr"."value" in ($604, $605, $606)) or ("pr"."attribute" = $607 and "pr"."value" in ($608, $609, $610)) or ("pr"."attribute" = $611 and "pr"."value" in ($612, $613, $614)) or ("pr"."attribute" = $615 and "pr"."value" in ($616, $617, $618)) or ("pr"."attribute" = $619 and "pr"."value" in ($620, $621, $622)) or ("pr"."attribute" = $623 and "pr"."value" in ($624, $625, $626)) or ("pr"."attribute" = $627 and "pr"."value" in ($628, $629, $630)) or ("pr"."attribute" = $631 and "pr"."value" in ($632, $633, $634)) or ("pr"."attribute" = $635 and "pr"."value" in ($636, $637, $638)) or ("pr"."attribute" = $639 and "pr"."value" in ($640, $641, $642)) or ("pr"."attribute" = $643 and "pr"."value" in ($644, $645, $646)) or ("pr"."attribute" = $647 and "pr"."value" in ($648, $649, $650)) or ("pr"."attribute" = $651 and "pr"."value" in ($652, $653, $654)) or ("pr"."attribute" = $655 and "pr"."value" in ($656, $657, $658)) or ("pr"."attribute" = $659 and "pr"."value" in ($660, $661, $662)) or ("pr"."attribute" = $663 and "pr"."value" in ($664, $665, $666)) or ("pr"."attribute" = $667 and "pr"."value" in ($668, $669, $670)) or ("pr"."attribute" = $671 and "pr"."value" in ($672, $673, $674)) or ("pr"."attribute" = $675 and "pr"."value" in ($676, $677, $678)) or ("pr"."attribute" = $679 and "pr"."value" in ($680, $681, $682)) or ("pr"."attribute" = $683 and "pr"."value" in ($684, $685, $686)) or ("pr"."attribute" = $687 and "pr"."value" in ($688, $689, $690)) or ("pr"."attribute" = $691 and "pr"."value" in ($692, $693, $694)) or ("pr"."attribute" = $695 and "pr"."value" in ($696, $697, $698)) or ("pr"."attribute" = $699 and "pr"."value" in ($700, $701, $702)) or ("pr"."attribute" = $703 and "pr"."value" in ($704, $705, $706)) or ("pr"."attribute" = $707 and "pr"."value" in ($708, $709, $710)) or ("pr"."attribute" = $711 and "pr"."value" in ($712, $713, $714)) or ("pr"."attribute" = $715 and "pr"."value" in ($716, $717, $718)) or ("pr"."attribute" = $719 and "pr"."value" in ($720, $721, $722)) or ("pr"."attribute" = $723 and "pr"."value" in ($724, $725, $726)) or ("pr"."attribute" = $727 and "pr"."value" in ($728, $729, $730)) or ("pr"."attribute" = $731 and "pr"."value" in ($732, $733, $734)) or ("pr"."attribute" = $735 and "pr"."value" in ($736, $737, $738)) or ("pr"."attribute" = $739 and "pr"."value" in ($740, $741, $742)) or ("pr"."attribute" = $743 and "pr"."value" in ($744, $745, $746)) or ("pr"."attribute" = $747 and "pr"."value" in ($748, $749, $750)) or ("pr"."attribute" = $751 and "pr"."value" in ($752, $753, $754)) or ("pr"."attribute" = $755 and "pr"."value" in ($756, $757, $758)) or ("pr"."attribute" = $759 and "pr"."value" in ($760, $761, $762)) or ("pr"."attribute" = $763 and "pr"."value" in (($764), ($765), ($766, $767))) and "price"."rules_count" > $768) or "price"."rules_count" = $769))) group by "price"."id", "pl"."id" having count(pr.attribute) = price.rules_count AND price.price_list_id IS NULL or count(DISTINCT plr.attribute) = pl.rules_count AND price.price_list_id IS NOT NULL) as "price" on "price"."price_set_id" = "ps"."id" where "ps"."id" in ($770) and "price"."currency_code" = $771 and ("price"."min_quantity" <= $772 or "price"."min_quantity" is null) order by "price"."has_price_list" asc, "all_rules_count" desc, "amount" asc
Expected behavior
I can select shipping option with product has many variants
Actual behavior
Error when select shipping option with product has many variants
Link to reproduction repo
private
The text was updated successfully, but these errors were encountered: