MySQL Forums
Forum List  »  CSV Storage Engine

CSV Engine Undocumented Limitations?
Posted by: Steve Martin
Date: September 17, 2009 10:14PM

Can someone explain why I can 'see' ie. SELECT COUNT(*) FROM... only 2,209,217 rows of my 12,338,857 row CSV file? The file size is about 5GB (should that make a difference?), row size is around 450, all recs have the same len and all fields are fixed length CHARs. Are there some undocumented limitations at work here?

For what it's worth...

mysql> show table status\G
*************************** 1. row ***************************
Name: m199907
Engine: CSV
Version: 10
Row_format: Fixed
Rows: 2
Avg_row_length: 0
Data_length: 0
Max_data_length: 0
Index_length: 0
Data_free: 0
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
CSV Engine Undocumented Limitations?
8540
September 17, 2009 10:14PM
5095
September 18, 2009 02:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.