boogerlad/mj - Change KP6SOABNHAFFYDJNC6BS4TPU624OMWH2UDQCRYDEYJIATNJ6TWCQC

fix ios_product/variant_id potentially returning wrong id. old behavior is if input is null, don't filter on that field at all, which is wrong. New behavior is if input is null, field should be null as well. For example, if _quantity is null and _flavor is null, it's possible to return a variant where quantity and / or flavor is not null

Created by boogerlad on June 4, 2020

KP6SOABNHAFFYDJNC6BS4TPU624OMWH2UDQCRYDEYJIATNJ6TWCQC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 487 [6.17]

B:BD[4.976] → [5.0:52]

			(producer = _producer or _producer is null) and

[4.976]

[2.345]

			producer is not distinct from _producer and

Replacement in initialize.sql at line 533 [6.17]

B:BD[4.2044] → [3.0:52]

			(quantity = _quantity or _quantity is null) and

[4.2044]

[4.2073]

			quantity is not distinct from _quantity and

Replacement in initialize.sql at line 535 [6.17]
B:BD[4.2102] → [5.96:138]
```
			(flavor = _flavor or _flavor is null)
```
[4.2102]
[4.2142]
```
			flavor is not distinct from _flavor
```