Re: [I] [BUG] PG database upgrade scripts are not tested [shenyu]</span></a></span> </h1> <p class="darkgray font13"> <span class="sender pipe"><a href="/search?l=notifications@shenyu.apache.org&q=from:%22via+GitHub%22" rel="nofollow"><span itemprop="author" itemscope itemtype="http://schema.org/Person"><span itemprop="name">via GitHub</span></span></a></span> <span class="date"><a href="/search?l=notifications@shenyu.apache.org&q=date:20250316" rel="nofollow">Sun, 16 Mar 2025 07:53:09 -0700</a></span> </p> </div> <div itemprop="articleBody" class="msgBody"> <!--X-Body-of-Message--> <pre> ImmortalFan commented on issue #5961: URL: <a rel="nofollow" href="https://github.com/apache/shenyu/issues/5961#issuecomment-2727483032">https://github.com/apache/shenyu/issues/5961#issuecomment-2727483032</a></pre><pre> 你好： 2.5.1-2.6.0 的升级sql存在问题： ALTER TABLE selector ADD COLUMN match_restful TINYINT(0) NOT NULL COMMENT 'whether to match restful(0 cache, 1 not cache)'; COMMIT; ALTER TABLE rule ADD COLUMN match_restful TINYINT(0) NOT NULL COMMENT 'whether to match restful(0 cache, 1 not cache)'; COMMIT; 如果是已经使用一段时间的数据库，selector和rule是存在数据的，这时候这个sql就会报错。当然如果是一个空库应该是没问题的。  这个表discovery_upstream这个两个int2类型的sql是正确的吗？我查了一些资料，反馈的信息是int2类型不能使用COLLATE 2.6.1-2.7.0的sql升级脚本问题：  这个和2.5.1-2.6.0的脚本反馈的第一个问题一样，已经有历史数据了，增加字段的时候 使用NOT NULL是会报错的 > 2025年3月16日 21:09，aias00 ***@***.***> 写道： > > > Aias00 > left a comment > (apache/shenyu#5961) > Hi, can you point out where the problem is? Or perhaps submit a PR with the SQL modification? > > — > Reply to this email directly, view it on GitHub, or unsubscribe. > You are receiving this because you authored the thread. > > <<a rel="nofollow" href="https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878">https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878</a>> <<a rel="nofollow" href="https://github.com/notifications/unsubscribe-auth/AEAFHRDAUV32SGOIR5GESNT2UVZW5AVCNFSM6AAAAABZDM2Q2WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDOMRXGM4TCOBXHA">https://github.com/notifications/unsubscribe-auth/AEAFHRDAUV32SGOIR5GESNT2UVZW5AVCNFSM6AAAAABZDM2Q2WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDOMRXGM4TCOBXHA</a>> > > Aias00 > left a comment > (apache/shenyu#5961) > <<a rel="nofollow" href="https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878">https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878</a>> > Hi, can you point out where the problem is? Or perhaps submit a PR with the SQL modification? > > — > Reply to this email directly, view it on GitHub <<a rel="nofollow" href="https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878">https://github.com/apache/shenyu/issues/5961#issuecomment-2727391878</a>>, or unsubscribe <<a rel="nofollow" href="https://github.com/notifications/unsubscribe-auth/AEAFHRDAUV32SGOIR5GESNT2UVZW5AVCNFSM6AAAAABZDM2Q2WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDOMRXGM4TCOBXHA">https://github.com/notifications/unsubscribe-auth/AEAFHRDAUV32SGOIR5GESNT2UVZW5AVCNFSM6AAAAABZDM2Q2WVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDOMRXGM4TCOBXHA</a>>. > You are receiving this because you authored the thread. > -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@shenyu.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org </pre> </div> <div class="msgButtons margintopdouble"> <ul class="overflow"> <li class="msgButtonItems"><a class="button buttonleft " accesskey="p" href="msg32769.html">Previous message</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="c" href="index.html#32770">View by thread</a></li> <li class="msgButtonItems textaligncenter"><a class="button" accesskey="i" href="maillist.html#32770">View by date</a></li> <li class="msgButtonItems textalignright"><a class="button buttonright " accesskey="n" href="msg32772.html">Next message</a></li> </ul> </div> <a name="tslice"></a> <div class="tSliceList margintopdouble"> <ul class="icons monospace"> <li class="icons-email"><span class="subject"><a href="msg32765.html">[I] [BUG] <title>PG database upgrade scripts are not test...</a></span> <span class="sender italic">via GitHub</span></li> <li><ul> <li class="icons-email"><span class="subject"><a href="msg32769.html">Re: [I] [BUG] <title>PG database upgrade scripts are...</a></span> <span class="sender italic">via GitHub</span></li> <li class="icons-email tSliceCur"><span class="subject">Re: [I] [BUG] <title>PG database upgrade scripts are...</span> <span class="sender italic">via GitHub</span></li> <li class="icons-email"><span class="subject"><a href="msg32772.html">Re: [I] [BUG] <title>PG database upgrade scripts are...</a></span> <span class="sender italic">via GitHub</span></li> </ul> </ul> </div> <div class="overflow msgActions margintopdouble"> <div class="msgReply" > <h2> Reply via email to </h2> <form method="POST" action="/mailto.php"> <input type="hidden" name="subject" value="Re: [I] [BUG] <title>PG database upgrade scripts are not tested [shenyu]"> <input type="hidden" name="msgid" value="I_kwDOCGCHjs6uN5b5-9837e685-235c-4ca4-bc2d-557393d0d624@gitbox.apache.org"> <input type="hidden" name="relpath" value="notifications@shenyu.apache.org/msg32770.html"> <input type="submit" value=" via GitHub "> </form> </div> </div> </div> <div class="aside" role="complementary"> <div class="logo"> <a href="/"><img src="/logo.png" width=247 height=88 alt="The Mail Archive"></a> </div> <form class="overflow" action="/search" method="get"> <input type="hidden" name="l" value="notifications@shenyu.apache.org"> <label class="hidden" for="q">Search the site</label> <input class="submittext" type="text" id="q" name="q" placeholder="Search notifications"> <input class="submitbutton" name="submit" type="image" src="/submit.png" alt="Submit"> </form> <div class="nav margintop" id="nav" role="navigation"> <ul class="icons font16"> <li class="icons-home"><a href="/">The Mail Archive home</a></li> <li class="icons-list"><a href="/notifications@shenyu.apache.org/">notifications - all messages</a></li> <li class="icons-about"><a href="/notifications@shenyu.apache.org/info.html">notifications - about the list</a></li> <li class="icons-expand"><a href="/search?l=notifications@shenyu.apache.org&q=subject:%22Re%5C%3A+%5C%5BI%5C%5D+%5C%5BBUG%5C%5D+%3Ctitle%3EPG+database+upgrade+scripts+are+not+tested+%5C%5Bshenyu%5C%5D%22&o=newest&f=1" title="e" id="e">Expand</a></li> <li class="icons-prev"><a href="msg32769.html" title="p">Previous message</a></li> <li class="icons-next"><a href="msg32772.html" title="n">Next message</a></li> </ul> </div> <div class="listlogo margintopdouble"> </div> <div class="margintopdouble"> </div> </div> </div> <div class="footer" role="contentinfo"> <ul> <li><a href="/">The Mail Archive home</a></li> <li><a href="/faq.html#newlist">Add your mailing list</a></li> <li><a href="/faq.html">FAQ</a></li> <li><a href="/faq.html#support">Support</a></li> <li><a href="/faq.html#privacy">Privacy</a></li> <li class="darkgray">I_kwDOCGCHjs6uN5b5-9837e685-235c-4ca4-bc2d-557393d0d624@gitbox.apache.org</li> </ul> </div> </body> </html>