title: What is the maximum limit of JSON Length when running SELECT from MySQL
body: <p>i have a table with 8 columns and 62,000+ rows. i'd like MySQL to convert its table defition to JSON via the select statement which i do by:</p>
  
  <pre><code>SELECT
      CONCAT(
          '[',
          GROUP_CONCAT(
              JSON_OBJECT(
                  'json_column_name', tbl.actual_column_name,
                  ...
              )
          ),
          ']'
      )
  FROM
      table_name tbl;
  </code></pre>
  
  <p>However, the JSON is cut once it reaches the 4th row from the table, this even with <code>LIMIT 2</code> declared for testing (which i don't understand because i've limited to first 2 rows). i already increased my <code>max_allowed_packets</code> to 1GB but still, the JSON gets cut.</p>