Code Monkey home page Code Monkey logo

Comments (4)

dulm avatar dulm commented on May 29, 2024

由于有3张表关联, 最左表生成的sql没 is_deleted变deleted, 但is_deleted有时生成的会没掉, 大部分时候是正确的。
这张表会在 diboot的 DynamicSqlProvider.buildDynamicSql加入is_deleted.

以下是3种不同的生成sql.

SELECT self.*
FROM tbl_purchase_form_plan self
LEFT OUTER JOIN tbl_purchase_rel_plan_goods r1m ON self.purchase_form_plan_id = r1m.purchase_form_plan_id
LEFT OUTER JOIN tbl_goods_goods_info r1 ON r1m.goods_id = r1.goods_id
WHERE (r1.goods_nm = ?)


SELECT self.*
FROM tbl_purchase_form_plan self
LEFT OUTER JOIN tbl_purchase_rel_plan_goods r1m ON self.purchase_form_plan_id = r1m.purchase_form_plan_id AND r1m.is_deleted = 0
LEFT OUTER JOIN tbl_goods_goods_info r1 ON r1m.goods_id = r1.goods_id
WHERE (r1.goods_nm = ?)



SELECT self.*
FROM tbl_purchase_form_plan self
LEFT OUTER JOIN tbl_purchase_rel_plan_goods r1m ON self.purchase_form_plan_id = r1m.purchase_form_plan_id AND r1m.is_deleted = 0
LEFT OUTER JOIN tbl_goods_goods_info r1 ON r1m.goods_id = r1.goods_id
WHERE (r1.goods_nm = ? AND self.is_deleted = 0)

from diboot.

dulm avatar dulm commented on May 29, 2024

之前是junit test上测,会出现这种不稳定随机出错现象。
今天放到服务器启动后的controller中测试,一直正常,没测出错误来。
junit中依然随机出错,由于不了解原因,所以也不敢保证说非junit中必然不会出错。
期待作者能找出原因。

PS:目前市面上看下来两表n对n的,你们的方案最优雅~

from diboot.

JerryMa1024 avatar JerryMa1024 commented on May 29, 2024

谢谢反馈,下个版本发布前我们会核实一下这个问题

from diboot.

Scorrt-2021 avatar Scorrt-2021 commented on May 29, 2024

BindQuery动态SQL构建中对于逻辑删除字段的处理已优化,经过单元测试验证该问题已解决,等待下次版本发布。

from diboot.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.