{"action":"created","issue":{"url":"https://api.github.com/repos/slamdata/slamengine/issues/792","labels_url":"https://api.github.com/repos/slamdata/slamengine/issues/792/labels{/name}","comments_url":"https://api.github.com/repos/slamdata/slamengine/issues/792/comments","events_url":"https://api.github.com/repos/slamdata/slamengine/issues/792/events","html_url":"https://github.com/slamdata/slamengine/issues/792","id":90139842,"number":792,"title":"error with variables having space in names???","user":{"login":"jdegoes","id":156745,"avatar_url":"https://avatars.githubusercontent.com/u/156745?v=3","gravatar_id":"","url":"https://api.github.com/users/jdegoes","html_url":"https://github.com/jdegoes","followers_url":"https://api.github.com/users/jdegoes/followers","following_url":"https://api.github.com/users/jdegoes/following{/other_user}","gists_url":"https://api.github.com/users/jdegoes/gists{/gist_id}","starred_url":"https://api.github.com/users/jdegoes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdegoes/subscriptions","organizations_url":"https://api.github.com/users/jdegoes/orgs","repos_url":"https://api.github.com/users/jdegoes/repos","events_url":"https://api.github.com/users/jdegoes/events{/privacy}","received_events_url":"https://api.github.com/users/jdegoes/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/slamdata/slamengine/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/slamdata/slamengine/labels/ready","name":"ready","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/slamdata/slamengine/milestones/11","html_url":"https://github.com/slamdata/slamengine/milestones/ASAP","labels_url":"https://api.github.com/repos/slamdata/slamengine/milestones/11/labels","id":1142034,"number":11,"title":"ASAP","description":"","creator":{"login":"jdegoes","id":156745,"avatar_url":"https://avatars.githubusercontent.com/u/156745?v=3","gravatar_id":"","url":"https://api.github.com/users/jdegoes","html_url":"https://github.com/jdegoes","followers_url":"https://api.github.com/users/jdegoes/followers","following_url":"https://api.github.com/users/jdegoes/following{/other_user}","gists_url":"https://api.github.com/users/jdegoes/gists{/gist_id}","starred_url":"https://api.github.com/users/jdegoes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdegoes/subscriptions","organizations_url":"https://api.github.com/users/jdegoes/orgs","repos_url":"https://api.github.com/users/jdegoes/repos","events_url":"https://api.github.com/users/jdegoes/events{/privacy}","received_events_url":"https://api.github.com/users/jdegoes/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":17,"state":"open","created_at":"2015-06-01T01:16:20Z","updated_at":"2015-06-23T19:46:17Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-06-22T15:57:21Z","updated_at":"2015-06-24T07:07:09Z","closed_at":null,"body":"```\r\nError in query: SQL AST Select(distinct) ├─ Proj(count) │ ╰─ InvokeFunction(count) │ ╰─ Splice ├─ Proj │ ╰─ Ident(type) ├─ Proj │ ╰─ Ident(country) ├─ TableRelation(./slamengine-test-01/olympics) ├─ Binop(=) │ ├─ InvokeFunction(UPPER) │ │ ╰─ Ident(sport) │ ╰─ InvokeFunction(UPPER) │ ╰─ Variable(:sport) ╰─ GroupBy ├─ Ident(country) ╰─ Ident(type) Annotated Tree Select(distinct) ├─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Obj(Map(count -> Int, type -> Top, country -> Top),None)) ├─ Proj(count) │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance(Empty) │ │ ├─ None │ │ ╰─ Type(Int) │ ╰─ InvokeFunction(count) │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance(Empty) │ │ ├─ ManyToOne(COUNT) │ │ ╰─ Type(Int) │ ╰─ Splice │ ╰─ Annotation │ ├─ None │ ├─ Provenance(Empty) │ ├─ None │ ╰─ Type(Top) ├─ Proj │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance(./slamengine-test-01/olympics) │ │ ├─ None │ │ ╰─ Type(Top) │ ╰─ Ident(type) │ ╰─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Top) ├─ Proj │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance(./slamengine-test-01/olympics) │ │ ├─ None │ │ ╰─ Type(Top) │ ╰─ Ident(country) │ ╰─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Top) ├─ TableRelation(./slamengine-test-01/olympics) │ ╰─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Bottom) ├─ Binop(=) │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance((Some(./slamengine-test-01/olympics) & Some(Value))) │ │ ├─ OneToOne((=)) │ │ ╰─ Type(Bool) │ ├─ InvokeFunction(UPPER) │ │ ├─ Annotation │ │ │ ├─ None │ │ │ ├─ Provenance(./slamengine-test-01/olympics) │ │ │ ├─ OneToOne(upper) │ │ │ ╰─ Type(Str) │ │ ╰─ Ident(sport) │ │ ╰─ Annotation │ │ ├─ None │ │ ├─ Provenance(./slamengine-test-01/olympics) │ │ ├─ None │ │ ╰─ Type(Str) │ ╰─ InvokeFunction(UPPER) │ ├─ Annotation │ │ ├─ None │ │ ├─ Provenance(Value) │ │ ├─ OneToOne(upper) │ │ ╰─ Type(Str) │ ╰─ Variable(:sport) │ ╰─ Annotation │ ├─ None │ ├─ Provenance(Value) │ ├─ None │ ╰─ Type(Str) ╰─ GroupBy ├─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Arr(List(Top, Top))) ├─ Ident(country) │ ╰─ Annotation │ ├─ None │ ├─ Provenance(./slamengine-test-01/olympics) │ ├─ None │ ╰─ Type(Top) ╰─ Ident(type) ╰─ Annotation ├─ None ├─ Provenance(./slamengine-test-01/olympics) ├─ None ╰─ Type(Top) Annotated Tree (variables substituted) The variable :sport should be convertible to type Str but found: VarValue(Ice Skating) slamdata.engine.Variables$$anonfun$substVars$3.error$lzycompute$1(variables.scala:57) slamdata.engine.Variables$$anonfun$substVars$3.slamdata$engine$Variables$$anonfun$$error$1(variables.scala:57) slamdata.engine.Variables$$anonfun$substVars$3$$anonfun$apply$3.apply(variables.scala:59) slamdata.engine.Variables$$anonfun$substVars$3$$anonfun$apply$3.apply(variables.scala:59) ... (3) slamdata.engine.Variables$$anonfun$substVars$3.apply(variables.scala:59) slamdata.engine.Variables$$anonfun$substVars$3.apply(variables.scala:52) slamdata.engine.sql.Expr$class.exprLoop$1(ast.scala:230) slamdata.engine.sql.Expr$$anonfun$exprLoop$1$3.apply(ast.scala:185) slamdata.engine.sql.Expr$$anonfun$exprLoop$1$3.apply(ast.scala:185) ... (1) slamdata.engine.sql.Expr$class.exprLoop$1(ast.scala:185) slamdata.engine.sql.Expr$$anonfun$exprLoop$1$2.apply(ast.scala:180) slamdata.engine.sql.Expr$$anonfun$exprLoop$1$2.apply(ast.scala:179) ... (12) slamdata.engine.Variables$.substVars(variables.scala:66) slamdata.engine.Planner$$anonfun$queryPlanner$1$$anonfun$apply$1$$anonfun$apply$3.apply(planner.scala:45) slamdata.engine.Planner$$anonfun$queryPlanner$1$$anonfun$apply$1$$anonfun$apply$3.apply(planner.scala:44) ... (14) slamdata.engine.Planner$$anonfun$queryPlanner$1$$anonfun$apply$1.apply(planner.scala:44) slamdata.engine.Planner$$anonfun$queryPlanner$1$$anonfun$apply$1.apply(planner.scala:43) ... (14) slamdata.engine.Planner$$anonfun$queryPlanner$1.apply(planner.scala:43) slamdata.engine.Planner$$anonfun$queryPlanner$1.apply(planner.scala:37) slamdata.engine.PlannerBackend$class.run(backend.scala:179) slamdata.engine.BackendDefinitions$$anonfun$1$$anonfun$applyOrElse$1$$anon$1.run(backends.scala:23) slamdata.engine.NestedBackend.run(backend.scala:284) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$slamdata$engine$api$FileSystemApi$$anonfun$$go$1$2$$anonfun$apply$27.apply(fs.scala:238) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$slamdata$engine$api$FileSystemApi$$anonfun$$go$1$2$$anonfun$apply$27.apply(fs.scala:237) ... (17) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$slamdata$engine$api$FileSystemApi$$anonfun$$go$1$2.apply(fs.scala:237) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$slamdata$engine$api$FileSystemApi$$anonfun$$go$1$2.apply(fs.scala:236) ... (1) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1.slamdata$engine$api$FileSystemApi$$anonfun$$go$1(fs.scala:235) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$applyOrElse$5.apply(fs.scala:248) slamdata.engine.api.FileSystemApi$$anonfun$queryService$1$$anonfun$applyOrElse$5.apply(fs.scala:247) ... (29)\r\n```\r\n\r\nIn all likelihood, this is a subset of the other ticket, slamdata/slamengine#769 (allowing / requiring SQL expressions to be used for variables) and will be fixed along with it."},"comment":{"url":"https://api.github.com/repos/slamdata/slamengine/issues/comments/114754453","html_url":"https://github.com/slamdata/slamengine/issues/792#issuecomment-114754453","issue_url":"https://api.github.com/repos/slamdata/slamengine/issues/792","id":114754453,"user":{"login":"sellout","id":33031,"avatar_url":"https://avatars.githubusercontent.com/u/33031?v=3","gravatar_id":"","url":"https://api.github.com/users/sellout","html_url":"https://github.com/sellout","followers_url":"https://api.github.com/users/sellout/followers","following_url":"https://api.github.com/users/sellout/following{/other_user}","gists_url":"https://api.github.com/users/sellout/gists{/gist_id}","starred_url":"https://api.github.com/users/sellout/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sellout/subscriptions","organizations_url":"https://api.github.com/users/sellout/orgs","repos_url":"https://api.github.com/users/sellout/repos","events_url":"https://api.github.com/users/sellout/events{/privacy}","received_events_url":"https://api.github.com/users/sellout/received_events","type":"User","site_admin":false},"created_at":"2015-06-24T07:07:09Z","updated_at":"2015-06-24T07:07:09Z","body":"So, this ticket can be closed then, right?"}}