2019-05-23 18:12
浏览 319


How have you solved the issue around LEFT JOIN's and null values with MySQL and Go?

For example I have two tables order and order_item. All columns have the not null attribute. An order can have 0 or more order_items. A simple select, left join query of an order without any order_items fails Row.Scan() because the order_item columns come back as null:

SELECT * FROM `order`
LEFT JOIN `order_item` USING (order_id)
WHERE `order`.order_id = '123'

I can see three solutions, none that I think are really good:

  1. Use COALESCE/IFNULL => Annoying because my select part of the query is automatically generated.
  2. Use the null values from mysql go lib => This will mean that every value in my order_item struct will be of these types.
  3. Split the query into 2 => Problem if I want a list of 50 orders with order_items, that will be 51 queries.

Any other solutions you have?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • drl92080 2019-05-23 19:22

    You can use option 2 but instead of scanning into your struct and having to change the types of your struct, you can scan into temporary variables with nullable datatypes and based on the validity of those variables, copy their values into your struct with non-nullable types.

    解决 无用
    打赏 举报

相关推荐 更多相似问题