title: Getting autoincrement values with Slick library in Scala
body: <p>How do I get the auto-incremented values for records inserted with Slick? The following code prints 1111. I would have expected it to print 1234</p>
  
  <pre><code>import scala.slick.driver.H2Driver.simple._
  
  object TestMappedTable extends App{
      case class User(id: Option[Int], first: String, last: String)
  
      object Users extends Table[User]("users") {
          def id = column[Int]("id", O.PrimaryKey, O.AutoInc)
          def first = column[String]("first")
          def last = column[String]("last")
          def * = id.? ~ first ~ last &lt;&gt; (User, User.unapply _)
      }
  
    implicit val session = Database.forURL("jdbc:h2:mem:test1", driver = "org.h2.Driver").createSession()
    session.withTransaction{
      Users.ddl.create
  
      print(Users.insert(User(None, "Jack", "Green" )))
      print(Users.insert(User(None, "Joe", "Blue" )))
      print(Users.insert(User(None, "John", "Purple" )))
      print(Users.insert(User(None, "Jim", "Yellow" )))
    }
  }
  </code></pre>
  
  <p>I'm using Slick 0.11.2 for Scala 2.10.0-RC1</p>