Hibernate version:2.1.6
Name and version of the database you are using: MySQL 4.0.20 and HSQLDB 1.7.2
I am currently working through "Hibernate a Developer's Notebook" by James Elliot and have found that when using the exact same code, schema, and mapping files I get two different results.
The code is:
Code:
Criteria criteria = session.createCriteria(Track.class);
criteria.add(Expression.le("playTime", length));
criteria.add(Expression.like("title", "%A%"));
criteria.addOrder(Order.asc("title"));
return criteria.list();
When using HSQLDB it returns the correct results, all titles that contain an uppercase A. When using MySQL it returns all titles that contain A regardless of case. With a little instruction I can get more info if needed.
Login
FAQ
Search
