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

expressions in mysqltest

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.1
    • Tests

    Description

      Let's add support for

      • standard arithmetic +, -, *, /, %
      • comparisons ==, !=, <, <=, >, >=
      • boolean &&, ||, may be ?:
      • if possible: string repetition, perl-style x (to replace `SELECT REPEAT()` in test files)
      • alternatively: functions, like instr, substr, repeat, replace, etc (to be added as needed)

      This should work in let, if, while, $( ... )

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-12130 Improve mysqltest language

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36108 variable substitutions in mysqltest

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}, may be {{?:}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}, may be {{?:}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            Labels gsoc25
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * ~if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)~

            This should work in {{let}}, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * ~if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)~

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in {{let}}, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in {{let}}, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in -{{let}}-, {{if}}, {{while}}.
            serg Sergei Golubchik made changes -
            svoj Sergey Vojtovich made changes -
            Labels gsoc25 contribution gsoc25
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich made changes -
            Fix Version/s 11.8 [ 29921 ]
            svoj Sergey Vojtovich made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] Open [ 1 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 12.1 [ 29992 ]
            Fix Version/s 11.8 [ 29921 ]
            svoj Sergey Vojtovich made changes -
            Labels contribution gsoc25 gsoc25
            svoj Sergey Vojtovich added a comment -

            Reset contribution label as there is no active pull request.

            svoj Sergey Vojtovich added a comment - Reset contribution label as there is no active pull request.
            VW100 Vaibhav Wadhwani added a comment -

            Can I work on this project under GSOC'25 ?

            VW100 Vaibhav Wadhwani added a comment - Can I work on this project under GSOC'25 ?
            serg Sergei Golubchik added a comment -

            if it's GSoC — you need to follow GSoC rules, you need to submit a project proposal and wait till it's accepted

            serg Sergei Golubchik added a comment - if it's GSoC — you need to follow GSoC rules, you need to submit a project proposal and wait till it's accepted
            VW100 Vaibhav Wadhwani added a comment -

            Can you please suggest me what can I do to enhance my chances of getting selected in GSOC 2025 under this project?

            VW100 Vaibhav Wadhwani added a comment - Can you please suggest me what can I do to enhance my chances of getting selected in GSOC 2025 under this project?
            Fatiha_Maryam Fatiha Maryam added a comment -

            Hello everyone,

            I am Fatiha Maryam, an aspiring GSOC 2025 contributor interested in working on MDEV-36107.
            So far, I have:
            Successfully built and installed MariaDB from source.
            Explored "mysql-test" and studied how test cases are written and executed.
            Run existing test cases like "main.variables".
            Written and executed my own test case successfully.
            Looked into beginner-friendly issues to get started with contributions.

            I would love any guidance on how to move forward with MDEV-36107. Looking forward to contributing!

            Best regards,
            Fatiha Maryam

            Fatiha_Maryam Fatiha Maryam added a comment - Hello everyone, I am Fatiha Maryam, an aspiring GSOC 2025 contributor interested in working on MDEV-36107 . So far, I have: Successfully built and installed MariaDB from source. Explored "mysql-test" and studied how test cases are written and executed. Run existing test cases like "main.variables". Written and executed my own test case successfully. Looked into beginner-friendly issues to get started with contributions. I would love any guidance on how to move forward with MDEV-36107 . Looking forward to contributing! Best regards, Fatiha Maryam
            Fatiha_Maryam Fatiha Maryam made changes -
            Comment [ First, ask yourself why you are here. If you chose this project, you must have seen the skills and problem statement. Make sure you understand them. Then, set up the project environment, read the README, explore test cases, and try solving issues. Stay consistent and motivated. Hope for the best! ]
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in -{{let}}-, {{if}}, {{while}}.             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in -{{let}}-, {{if}}, {{while}}, {{$( ... )}}
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-

            This should work in -{{let}}-, {{if}}, {{while}}, {{$( ... )}}             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-
            * alternatively: functions, like {{instr}}, {{substr}}, {{repeat}}, {{replace}}, etc (to be added as needed)

            This should work in -{{let}}-, {{if}}, {{while}}, {{$( ... )}}
            serg Sergei Golubchik made changes -
            Description Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, may be {{?:}}
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-
            * alternatively: functions, like {{instr}}, {{substr}}, {{repeat}}, {{replace}}, etc (to be added as needed)

            This should work in -{{let}}-, {{if}}, {{while}}, {{$( ... )}}             		Let's add support for
            * standard arithmetic {{+}}, {{-}}, {{*}}, {{/}}, {{%}}
            * comparisons {{==}}, {{!=}}, {{<}}, {{<=}}, {{>}}, {{>=}}
            * boolean {{&&}}, {{||}}, -may be {{?:}}-
            * -if possible: string repetition, perl-style {{x}} (to replace {{`SELECT REPEAT()`}} in test files)-
            * alternatively: functions, like {{instr}}, {{substr}}, {{repeat}}, {{replace}}, etc (to be added as needed)

            This should work in -{{let}}-, {{if}}, {{while}}, {{$( ... )}}

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.