Fork me on GitHub
#honeysql
<
2022-10-27
>
Jungwoo Kim23:10:49

Hello! Does honeysql support *&lt;<https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_equal-to%7C&lt;=&gt;&gt;*(null-safe> operator) in mysql? I’ve checked out <https://github.com/seancorfield/honeysql/blob/develop/doc/operator-reference.md|here>. Is there any workaround instead of `:raw`?

seancorfield23:10:38

Feel free to create a GH issue so it gets registered by default when the :mysql dialect is selected.

🙂 1
seancorfield23:10:03

(I've used MySQL for over a decade and I've never encountered that operator!)

😂 1
seancorfield23:10:23

Maybe it's new in 8.0? (we're still on 5.7 for... reasons...)

hifumi12323:10:28

Aha, I was about to mention that it should be possible to patch into HoneySQL by using

register-op!
I also can't say I've used <=> before, but I mostly use PostgreSQL, which probably lacks it

👍 1
Jungwoo Kim23:10:38

Thanks you all. I would try to use register op first.