[MDEV-5393] ConnectSE: ODBC: CATFUNC=Tables returns too few rows - Jira

Details

Type: Bug
Status: Closed (View Workflow)
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).

Attachments

Activity

Ascending order - Click to sort in descending order

Olivier Bertrand added a comment - 2013-12-06 19:07

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

Olivier Bertrand added a comment - 2013-12-06 19:07 This was a limit built into the code. I was raised to 16384.

Olivier Bertrand added a comment - 2013-12-16 02:53

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.

Olivier Bertrand added a comment - 2013-12-16 02:53 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:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2013-12-05 17:15

Updated:: 2013-12-16 02:53

Resolved:: 2013-12-16 02:53

Git Integration

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

MariaDB Server