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

ConnectSE: ODBC: ORDER BY does not work for CATFUN with an SQLite3 DSN

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.6
    • Fix Version/s: 10.0.7
    • Component/s: None
    • Labels:
      None

      Description

      If I change either of the last two SELECT queries in
      storage/connect/mysql-test/connect/t/odbc_sqlite3.test from

      SELECT * FROM t1;
      

      to

      SELECT * FROM t1 ORDER BY Table_name
      

      it returns the following error:

      mysqltest: At line 84: query 'SELECT * FROM t1 ORDER BY Table_name' failed: 1032: Can't find record in 't1'
      

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            bertrandop Olivier Bertrand added a comment -

            Fixed for version 10.0

            Show
            bertrandop Olivier Bertrand added a comment - Fixed for version 10.0

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours
                  2h