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

FOUND_ROWS() returns 1 if no statement has still been executed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • None
    • None
    • None
    • None
    • 5.5

    Description

      Reading MySQL manual it's not clear what FOUND_ROWS() should return if no statement has been executed by the current session. However I think that 1 could be misleading.

      Enter password:
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MariaDB connection id is 2
      Server version: 5.5.25-MariaDB mariadb.org binary distribution

      This software comes with ABSOLUTELY NO WARRANTY. This is free software,
      and you are welcome to modify and redistribute it under the GPL v2 license

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> select found_rows();
      --------------

      found_rows()

      --------------

      1

      --------------
      1 row in set (0.00 sec)

      Attachments

        Activity

          People

            Unassigned Unassigned
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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