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
When I query by clause like db.Raw("SELECT count(*) FROM mall_order WHERE 'ddd' MEMBER OF (product_configs->'$[*].Product.name') > 0")Everything is OK.
Howerver, When I query by clause like db.Model(m).Where("? MEMBER OF (product_configs->'$[*].Product.name') > 0", "ddd").Count(&num),
it complain error 3141: invalid json text in argument 1 to function cast_as_json: "invalid value." at position 0.
In order to test, I try to run db.Model(m).Where(fmt.Sprintf("'?' MEMBER OF (product_configs->'$[*].Product.name') > 0", "ddd")).Count(&num). Everything goes well again
The text was updated successfully, but these errors were encountered:
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨
GORM Playground Link
go-gorm/playground#1
Description
When I query by clause like
db.Raw("SELECT count(*) FROM mall_order WHERE 'ddd' MEMBER OF (product_configs->'$[*].Product.name') > 0")
Everything is OK.Howerver, When I query by clause like
db.Model(m).Where("? MEMBER OF (product_configs->'$[*].Product.name') > 0", "ddd").Count(&num)
,it complain
error 3141: invalid json text in argument 1 to function cast_as_json: "invalid value." at position 0.
In order to test, I try to run
db.Model(m).Where(fmt.Sprintf("'?' MEMBER OF (product_configs->'$[*].Product.name') > 0", "ddd")).Count(&num)
. Everything goes well againThe text was updated successfully, but these errors were encountered: