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

[MDEV-5393] ConnectSE: ODBC: CATFUNC=Tables returns too few rows Created: 2013-12-05 Updated: 2013-12-16 Resolved: 2013-12-16
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.0.6
Fix Version/s:	10.0.7

Type:

Bug

Priority:

Minor

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

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).

Comments

Comment by Olivier Bertrand [ 2013-12-06 ]

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

Comment by Olivier Bertrand [ 2013-12-16 ]

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.

Generated at Thu Feb 08 07:04:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.