Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12130

Improve mysqltest language

    XMLWordPrintable

    Details

      Description

      mysqltest has a lot of historical problems:

      • ad hoc parser, weird limitations
      • commands added as needed with no view over the total language structure
      • historical code issues (e.g. casts that become unnecessary ~10 years ago)
        etc

      A lot can be done to improve it.

      Ideas

      • control structures, else in if, break and continue in while, for (or foreach) loop
      • proper expression support in let, if, etc
      • rich enough expressions to make resorting to sql unnecessary in most cases
      • remove unused and redundant commands (e.g. system vs exec, query_vertical vs vertical_results ONCE)
      • remove complex commands that do many sql statements under the hood, if they can be scripted, e.g. sync_slave_with_master
      • remove over-verbose treatment of rpl test failures
      • scoped variables
      • parameters for the source command
      • remove dead code

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              serg Sergei Golubchik
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated: