No positional variables are allowed over datasets.

[GoogleCodeExporter]

What steps will reproduce the problem?
//1. Run the following DDLs:

/*schema*/
drop dataverse STBench if exists;
create dataverse STBench;
use dataverse STBench;
/* longitude: x, latitude: y */

create type SimpleGeoPlaceType as closed {
   coordinates: point,      /* geometry -> coordinates (first -> should be x, second -> should be y) */
    id: int64,             
    name: string,           /* properties -> name */
    tags: string,           /* properties -> tags (arrary of string) */
    categories: string,     /* properties -> classifiers -> category, type, subcategory (will be concatenated as a string) */
    phone: string           /* properties -> phone */
}
create dataset SimpleGeoPlace (SimpleGeoPlaceType) primary key id;
/* load - adm file is attached*/
use dataverse STBench;
load dataset SimpleGeoPlace 
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/SimpleGeoPlace_100.adm"),("format"="adm"));

//2. Run the following query.

for $x in at $i dataset SimpleGeoPlace
where $i = 13
return $x;

What is the expected output? What do you see instead?

The above query should return the same result as the following query, 
query:
for $x in dataset SimpleGeoPlace
limit 1 offset 13
return $x;

result:
{ "coordinates": point("-58.3667319,-34.6070993"), "id": 13i64, "name": 
"CodeGlide", "tags": "open-source crm etl integration software solution 
collaboration groupware", "categories": "Professional Services Computer 
Services", "phone": "" }

but it returns the following error:

No positional variables are allowed over datasets. [AlgebricksException]

Original issue reported on code.google.com by kiss...@gmail.com on 11 Jul 2015 at 12:21

Attachments:

• SimpleGeoPlace_100.adm