google-code-export / ords

Automatically exported from code.google.com/p/ords
1 stars 0 forks source link

Export query as .csv doesn't always export the final record from the query results #499

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Go to the Milestone version of the 'from-scratch database' in the Project 
'James's new project'
2. Build and run the query 'select * from "People"'
3. Notice that this produces three results
2. click 'Export Query Results as CSV'
3. Notice that the final record in the results list is NOT being exported

What is the expected output? What do you see instead?
I've tested this in other databases, but they all seem to work fine. I'm not 
sure what it is that is preventing the third record in this particular table 
from being exported, but it's obviously a major issue as this kind of thing can 
potentially bugger up people's analysis of their data.

Please use labels and text to provide additional information.
Chrome Dev 0.10.beta - 3449

Original issue reported on code.google.com by jajwil...@gmail.com on 30 Jul 2014 at 3:34

GoogleCodeExporter commented 9 years ago
This is probably best assigned to Dave, as I've never looked at the export code 
yet.

Original comment by marxjohn...@gmail.com on 30 Jul 2014 at 3:40

GoogleCodeExporter commented 9 years ago
I have just run the query and noticed that 2 records are displayed in the ORDS 
web site (and consequently downloaded via export). I then looked at the native 
data in Postgres and noticed that there are, indeed, 2 records in Postgres for 
the People table. Never three.

Original comment by thest...@gmail.com on 31 Jul 2014 at 6:13

GoogleCodeExporter commented 9 years ago
No - there are three (3) query results. This is the Milestone version I'm 
talking about, as stated above.

I think I've now figured out what the problem is, however. When you run a query 
on a Milestone version of a db and try to export this as .csv, the system 
actually exports the query as though it has been run on the MAIN version of the 
database.

Original comment by jajwil...@gmail.com on 31 Jul 2014 at 8:22

GoogleCodeExporter commented 9 years ago
Ah - sorry. I hadn't noticed it was the milestone db.

Original comment by thest...@gmail.com on 31 Jul 2014 at 8:55

GoogleCodeExporter commented 9 years ago

Original comment by thest...@gmail.com on 31 Jul 2014 at 9:21

GoogleCodeExporter commented 9 years ago
I have fixed such that you can now export data from test and milestone 
databases. I have also removed the option to create datasets of these since I 
din't have time to fix before go-live. Please raise a new issue for this.

Original comment by thest...@gmail.com on 31 Jul 2014 at 9:35