Hi, you may want to ask this on the Slick mailinglist[1].
[1]: https://groups.google.com/forum/#!forum/scalaquery On Fri, Mar 28, 2014 at 8:15 PM, Peter Wolf <[email protected]> wrote: > Hello, I just started playing with Slick, and it is indeed very cool :-D > > However, I am puzzled by this behavior... > > I have a table of accountID and accountRoleTypeID > > class AccountRoleTypeMatch(tag: Tag) extends Table[(Int,Int)](tag, > "AccountRoleTypeMatch") { > def accountID: Column[Int] = column[Int]("AccountID", O.PrimaryKey) > def accountRoleTypeID: Column[Int] = column[Int]("AccountRoleTypeID") > > def * : ProvenShape[(Int, Int)] = (accountID, accountRoleTypeID) > } > > And I want to retrieve the accountIDs with accountRoleTypeID == 21 > > val accountRoleTypeMatchs: TableQuery[AccountRoleTypeMatch] = > TableQuery[AccountRoleTypeMatch] > val premiumAccountIDs = accountRoleTypeMatchs.filter( > _.accountRoleTypeID == 21 ) > > premiumAccountIDs.list.foreach { > case (accountID, accountRoleTypeID) => > println(accountID + " " + accountRoleTypeID) > } > > But it generates this select, and I get nothing > > select x2.`AccountID`, x2.`AccountRoleTypeID` from > `AccountRoleTypeMatch` x2 where false > > If I change the filter to > > val premiumAccountIDs = accountRoleTypeMatchs.filter( > _.accountRoleTypeID < 21 ) > > Then it works as expected > > select x2.`AccountID`, x2.`AccountRoleTypeID` from > `AccountRoleTypeMatch` x2 where x2.`AccountRoleTypeID` < 21 > > What is going on? How should I filter to get only rows with > accountRoleTypeID==21? > > Thanks > Peter > > -- > >>>>>>>>>> Read the docs: http://akka.io/docs/ > >>>>>>>>>> Check the FAQ: > http://doc.akka.io/docs/akka/current/additional/faq.html > >>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user > --- > You received this message because you are subscribed to the Google Groups > "Akka User List" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/akka-user. > For more options, visit https://groups.google.com/d/optout. > -- Cheers, √ *———————**Viktor Klang* *Chief Architect - **Typesafe <http://www.typesafe.com/>* Twitter: @viktorklang -- >>>>>>>>>> Read the docs: http://akka.io/docs/ >>>>>>>>>> Check the FAQ: >>>>>>>>>> http://doc.akka.io/docs/akka/current/additional/faq.html >>>>>>>>>> Search the archives: https://groups.google.com/group/akka-user --- You received this message because you are subscribed to the Google Groups "Akka User List" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/akka-user. For more options, visit https://groups.google.com/d/optout.
