/*
 * Description  : This test case is to verify the fix for issue288
 				: https://code.google.com/p/asterixdb/issues/detail?id=288
 * Expected Res : Success
 * Date         : 3th April 2013
 */

use dataverse test;

load dataset LineID 
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/tpch0.001/lineitem_0.tbl"),("format"="delimited-text"),("delimiter"="|")) pre-sorted;


insert into dataset LineID (
let $x:=1
let $y:=2
let $z:=3
return {
	"l_orderkey": $x,
	"l_linenumber": $y,
	"l_suppkey": $z
}
);