0.9.5
- Dynamic orderBy
- Fix error with enumerations within groupBy
0.9.5-RC2
- Cryptic error message upon field type deduction failure became more explicit.
- added transaction and inTransaction that takes a SessionFactory
0.9.5-RC1
Additional changes :
- migration to sbt 0.10.x
- Fix case statement with String (varchar) return type for Oracle
- SQLServer adapter quotes idendifiers
- SQL Server: Properly quote identifiers to allow using reserved words in field names
- added def transaction[A](s: Session)(a: =>A)
- Convert === None to SQL o is null
- fail safe close on the jdbc connection when it fails on commit or rollback
- Fixed an issue with retrieval of @ScalaSig data.
- Option type deduction was failing for POSOs with a lot of fields (~50). This method relies more on scalap. Also, added turned off SBTs default filtering of the scala-complier. The compiler is a dependency of scalap and is necessary for the @ScalaSig retrieval and parsing.
- Changed ThreadLocal handing so that they get cleaned up after use. To be sure, all ThreadLocals are also initialized with null values.
- Support Enumerations in IN. Added also a test case of .? that does not compile
- adding update method to the ActiveRecord
- Postgres/DB2/Oracle now honor uninsertable field meta data flag
- Support unupdatable, uninsertable in schema DSL for columns
- Do not persist static fields of POSOs
- Add implicit so that nvl on a Timestamp followed by >= compiles.
- Previously, the compiler would report the following error:
- value >= is not a member of org.squeryl.dsl.NvlFunctionNonNumerical[Option[org.squeryl.PrimitiveTypeMode.TimestampType],org.squeryl.PrimitiveTypeMode.TimestampType]
- added implicit conv for Option[BinaryType]
- Fixed an issue where .leftOuter.inhibitWhen led to an inner join being performed by adding an inhibitWhen method on OuterJoinedQueryable. This also means that inhibiting a leftOuter will now result in an Option[T] rather than an Option[Option[T]]
- Added implicts to handle lists of UUIDs
- Removal of deprecated Boolean → LogicalBoolean implicit conversion
- Fix of : having being inhibited when followed by compute
0.9.4 Final
- http://www.assembla.com/spaces/squeryl/tickets/52-missing-implicit-for-compute%28min%28atimestamp%29%29
- http://www.assembla.com/spaces/squeryl/tickets/49-allow-specifying-the-name-of-manytomany-relations
0.9.4-RC7
- #8 columns get duplicated in the select clause on Posos that have reentrant property accessors
- #9 An enumerations in a subquery within an ‘in’ operator, causes the outter query to contain the enumeration in the select clause
- #35 Add support for EXISTS / NOT EXISTS
- #32 UUID support
- #14 Assertion fails on self referring OneToManyRelationship
- #34 LeftOuter join does not work in some orderings of the from/join clause
- #40 Nested JOINs aren’t mapped correctly
- #10 avg() not supporting BigDecimal type on RC4
- #27 inhibitWhen cannot be used with isNotNull
- #46 def id’ on non composite KeyedEntity backed by another field causes assertion failure
- #48 Constant nodes sould have a mapper, or select(&lower(“aConstant”)) should work
- #1 Convert all tests to ScalaTest
0.9.4-RC6
- CompositeKey support now up to 9 columns
Fix for issue 79 (Returning or excepting out of nested transaction block kills session)
eager closing of preparedStatement for DB updates
0.9.4-RC3
- compiled against Scala 2.8.1
- Externalisation of POSO creation, now part of the FieldMetaDataFactory (for fixing metadata in Lift squery-record)
- fix for issue 68 Invoking a persisent field during construction causes interference in AST construction
- Allow the many side of a one-to-many relatonship to be a non-KeyedEntity.
- Fixed/finished support for Binary/Array[Byte] types. (thanks to Michael Bayne)
- fix for issue 61: Schema.defaultsTo(T) on Enumerations outputs String instead of Int
- Fix for issue 59 on/declare expression on KeyedEntity.id doesn’t override the schema default attributes
- MSSQL support (note : query pagination, not yet working…)
- Fix for issue 51 : update fails with KeyedEntities[CompositeKey[…]]
- Fix for issue 52 : regex expression not passed as param to jdbc prepared statement.
0.9.4-RC2
- Fix for issue 48 (Exception thrown in outer join with subquery member)
the problem was that the ordering of the table expression was not strict, so the from expression
would get mixed with a join expression.
- test case for outer join with group by
- Support for overriding default database column type declaration
- Fix for issue 45 (Timestamp as query input param gets truncated)
- @transient applied to PersistenceStatus._isPersisted
- Fix for issue 16 : SQL ‘in’ operator now accepts empty lists and inhibits
“not in (empty)” tautology and returns an always false for “in (empty)”
http://github.com/max-l/Squeryl/issues#issue/16
- Fix for issue 42 (problems creating indices: missing single-column indices)
- Moved annotations package to adhere to the convention
- Fix for issue 44 (Class cast exception on OneToMany query)
0.9.4-RC1
Features :
- OneToMany and ManyToMany Relations
- Composite Keys
- Support for BigDecimal, (kindly contributed by Antti Tuppurainen)
- Support for Binary column type (graciousness of Mitsutoshi Aoe)
- Support for Injection of custom SQL functions by implit conversions
- Enhancements to Schema Definition : declaration of column attributes for schema creation (indexes, uniqueness constraint, auto increment, etc…)
- Support for DB2 (a huge thanks to Christian Maslen)
- Fully qualified table names, i.e. support for prefixing table names with the schema name issue #2
- Injection of SQL functions by implicit conversion
- regex, lower, upper string functions
- Dynamic where clause definition
- Redesign of inner,outer joins with new join function
- Lift support (Lift 2.0 M2)
- fixed a bunch of issue
As well as a few minor enhancements and bug fixes.
Contributors to this release (in alphabetical order) :
- Alec Wysoker
- Antti Tuppurainen
- Christian Maslen
- David Flemström
- Mitsutoshi Aoe
0.9.3
- Batched updates and inserts
- Optimistic Concurrency Control
- Declarative transactions
0.9.2
- Paginated Queries
- Dynamic inhibition (removal) of query elements
0.9.1
First published version of Squeryl