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

ConnectSE: ODBC: CATFUNC=Tables returns too few rows

        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 run this script with a data source having many tables:

          drop table if exists t1;
create table t1 engine=connect table_type=odbc connection='DSN=oraodbc;UID=system;PWD=manager' catfunc=Tables;
select * from t1;

          it returns only the first 512 records.
          The data source has actually more tables (about 8900 tables and views).

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                bertrandop Olivier Bertrand added a comment -

                This was a limit built into the code. I was raised to 16384.

                Show
                bertrandop Olivier Bertrand added a comment - This was a limit built into the code. I was raised to 16384.
                Hide
                Permalink
                bertrandop Olivier Bertrand added a comment -

                Limits can now be changed using the MAXRES option (to be specified in the OPTION_LIST) Default values are:

                Drivers 256
                Data sources: 512
                Tables: 10000
                Columns 20000

                Of course, retrieving a result set of say 120,000 may seem ridiculous for display, however it is needed when doing functional or group by queries.

                Show
                bertrandop Olivier Bertrand added a comment - Limits can now be changed using the MAXRES option (to be specified in the OPTION_LIST) Default values are: Drivers 256 Data sources: 512 Tables: 10000 Columns 20000 Of course, retrieving a result set of say 120,000 may seem ridiculous for display, however it is needed when doing functional or group by queries.

                  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 - 7 hours
                      7h