Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

author
message
[Level:0]quamis

Post subject: SELECT * FROM test returns only 100 rows

registered: 06/09/2011

IP: *.121.75.101

views: 109

I have a table with ~20000 rows. When i issue SELECT * FROM test, i only get 100 rows. Why is that? Is there some kind of internal limit on the maximum number of results?

Quote
[Level:8]CUBRID

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 03/29/2010

IP: *.91.139.51

Hi quamis,


Could you please provide your environment details such as CUBRID version, PHP version, OS, etc.?

Quote
[Level:0]quamis

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 06/09/2011

IP: *.26.198.100

Hello


php -v
PHP 5.3.5-1ubuntu7.2 with Suhosin-Patch (cli) (built: May  2 2011 23:00:17)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


uname -a
Linux ubuntu 2.6.38-8-server #42-Ubuntu SMP Mon Apr 11 03:49:04 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux


cubrid --version
cubrid (cubrid utilities) R3.1


Installed from CUBRID-8.3.1.2003-linux.x86_64.sh


This server runs under virtualBox, 64bit, 512Mb RAM



Another question: SHOW TABLES is not implemented for CUBRID? Should i open another thread for this?

Quote
[Level:8]CUBRID

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 03/29/2010

IP: *.91.139.51

SHOW TABLES is available starting from CUBRID 8.4.0.

Quote
[Level:0]quamis

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 06/09/2011

IP: *.26.15.11

How can i get a list of tables in the current DB then?

Quote
[Level:0]quamis

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 06/09/2011

IP: *.26.15.11

Nevermind, i found

http://www.php.net/manual/en/function.pdo-cubrid_schema.php

Quote
[Level:0]Yifan

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 04/11/2011

IP: *.108.20.146

Hi quamis, 


There is no internal limit on the maximum number of results in CUBRID PHP. I have run a similar test on a x86_64 centos using CUBRID 8.3.1.2003, but I didn't see this problem. It is better that you can show us your PHP test script.


Thanks.


Quote
[Level:0]quamis

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 06/09/2011

IP: *.26.15.11

The attached test files are used for the competition. The same code contains the code that generated the test table and data. The data is not indexed in any way and contains random data.

Quote

Attachment:

[Level:0]quamis

# Post subject:Re: SELECT * FROM test returns only 100 rows

profile

registered: 06/09/2011

IP: *.26.15.11

On my test machine, i get this result:

Program started...
Testing DB 01
Scan test_858
    Table has 41795 rows
 row 153 
 total items in the table: 41795, i got  153 items

Quote




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: