Skip to content

Instantly share code, notes, and snippets.

@BlackPrincess
Last active August 29, 2015 13:55
Show Gist options
  • Select an option

  • Save BlackPrincess/8779015 to your computer and use it in GitHub Desktop.

Select an option

Save BlackPrincess/8779015 to your computer and use it in GitHub Desktop.
Post.join(Post.tagsRef).findById(1) // byDefault抜け
select p.id as i_on_p, p.title as t_on_p, p.body as b_on_p, p.created_at as ca_on_p, p.updated_at as ua_on_p , pt.id as i_on_pt, pt.tag_id as ti_on_pt, pt.post_id as pi_on_pt, pt.created_at as ca_on_pt, pt.updated_at as ua_on_pt , t.id as i_on_t, t.name as n_on_t, t.created_at as ca_on_t, t.updated_at as ua_on_t from posts p left join posts_tags pt on p.id = pt.post_id left join tags t on pt.tag_id = t.id where p.id = 1;
scalikejdbc.TooManyRowsException: null
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:138) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DBSession$$anonfun$single$1.apply(DBSession.scala:132) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.LoanPattern$.using(LoanPattern.scala:29) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.package$.using(package.scala:76) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DBSession$class.single(DBSession.scala:131) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.ActiveSession.single(DBSession.scala:420) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.SQLToOption$$anonfun$apply$14.apply(SQL.scala:542) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.SQLToOption$$anonfun$apply$14.apply(SQL.scala:542) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DBConnection$$anonfun$readOnly$1.apply(DB.scala:150) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DBConnection$$anonfun$readOnly$1.apply(DB.scala:149) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.LoanPattern$.using(LoanPattern.scala:29) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.package$.using(package.scala:76) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DBConnection$class.readOnly(DB.scala:149) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DB.readOnly(DB.scala:492) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DB$$anonfun$readOnly$2.apply(DB.scala:596) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DB$$anonfun$readOnly$2.apply(DB.scala:595) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.LoanPattern$.using(LoanPattern.scala:29) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.package$.using(package.scala:76) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.DB$.readOnly(DB.scala:595) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.SQLToOption$class.apply(SQL.scala:542) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at scalikejdbc.SQLToOptionImpl.apply(SQL.scala:563) ~[scalikejdbc_2.10-1.7.3.jar:1.7.3]
at skinny.orm.feature.FinderFeatureWithId$class.findById(FinderFeature.scala:33) ~[skinny-orm_2.10-0.9.27.jar:0.9.27]
at skinny.orm.feature.CRUDFeatureWithId$$anon$1.findById(CRUDFeature.scala:49) ~[skinny-orm_2.10-0.9.27.jar:0.9.27]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment