4 ms·

Same SQL, Different Results: A Subtle Oracle vs. PostgreSQL Migration Bug

• harperlee 8mo ago
  Obviously written by AI.
  • smallerfish 8mo ago
    Yeah. There's nothing wrong with using AI to draft an article, but ffs have some taste and edit it significantly once the draft is written.
    • mahtodeepak 8mo ago
      Feedback taken. I have been blogging since long and have my own way for telling technical stuff.
  • mahtodeepak 8mo ago
    I draft most of my blog first without any AI and later refine it for flow and clarity. These time i had used it to influence the flow and agree it changed a lot. But i liked the flow so kept it like that.
• aerzen 8mo ago
  This is a really long article for saying "precedence between || and + is different between PostgreSQL and Oracle SQL".
  • mahtodeepak 8mo ago
    I am the author of the Blog. I wanted to share the journey as part of analysis. Blog is not on precedence between || and + but primarily highlight fact that implicit casting cause it to change in Oracle. Ideally precedence is same in both engines.
    • aerzen 8mo ago
      Sorry for being dismissive. I've written a post [1] that highlights the core discrepancy between the two dialects. I like criticizing SQL and having a documented case like this is nice. [1]: https://aljaz.murerzen.eu/sql-precedence/ https://aljaz.murerzen.eu/sql-precedence/