dynamobi/dynamobi — Issue #267: [LDB-54] rows with incorrect number of columns are skipped in sampling
Author: dynamobi-build
Created: 2011-12-30 02:25:42+00:00
State: closed
Labels: Flatfile, LDB

[reporter="schoi", created="Sun, 2 Apr 2006 23:36:01 -0500 (GMT-05:00)"]
In //open/lu/dev/farrago/unitsql/med/flatfile.ref

-- 3.8 Test sampling of a file with nulls in data

select * from flatfile_server_empty.BCP."nulldata";

2 rows are returned, but in the nulldata.txt, there is one more row with too many columns.

No error is returned; it just skips that row.

Try:

select * from flatfile_server_empty.SAMPLE."nulldata";