Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    SQL formatting in 12.1p

    Hi Isomorphic,

    I'm in the process of updating from v12.0p_2020-03-11 to v12.1p_2022-06-03 and noticed that the log is now formatted. This is of course great.
    Is there a switch to disable this, though? I'm comparing the important generated SQLs before and after and this formatting on one side makes me need to reformat both, so that they are comparable.
    Not important if not, but would be nice to know if there was the possibility to do so.

    Best regards
    Blama

    #2
    What do you mean by the log being formatted? Are you talking about indentation?

    Comment


      #3
      Hi Isomorphic,

      yes, the indention and line breaks for key words.

      Best regards
      Blama

      Comment


        #4
        You may disable SQL queries formatting in logs by the setting in server.properties:
        Code:
        sql.log.formatQueries: false

        Comment


          #5
          Hi Isomorphic,

          that's working.

          Thank you & Best regards
          Blama

          Comment

          Working...
          X