Piggydb Piggydb

The following error is occasionally thrown when displaying fragments by Title from any of several pages.

Exception
Class   org.h2.jdbc.JdbcSQLException
Message   Order by expression "UPPER(F.TITLE)" must be in the result list in this case; SQL statement: select distinct f.fragment_id, UPPER(f.title) from fragment as f, tagging as t where f.fragment_id = t.target_id and t.target_type = 2 and t.tag_id in (22) minus select distinct f.fragment_id, UPPER(f.title) from fragment as f, tagging as t where f.fragment_id = t.target_id and t.target_type = 2 and t.tag_id in (68, 84, 7, 77) order by UPPER(f.title) desc nulls first [90068-147]

org.h2.jdbc.JdbcSQLException: Order by expression "UPPER(F.TITLE)" must be in the result list in this case; SQL statement:
select distinct f.fragment_id, UPPER(f.title) from fragment as f, tagging as t where f.fragment_id = t.target_id and t.target_type = 2 and t.tag_id in (22) minus select distinct f.fragment_id, UPPER(f.title) from fragment as f, tagging as t where f.fragment_id = t.target_id and t.target_type = 2 and t.tag_id in (68, 84, 7, 77) order by UPPER(f.title) desc nulls first [90068-147]
   at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
   at org.h2.message.DbException.get(DbException.java:167)
   at org.h2.message.DbException.get(DbException.java:144)
   at org.h2.command.dml.Query.initOrder(Query.java:347)
   at org.h2.command.dml.SelectUnion.prepare(SelectUnion.java:271)
   at org.h2.command.Parser.prepare(Parser.java:202)
   at org.h2.command.Parser.prepareCommand(Parser.java:214)
   at org.h2.engine.Session.prepareLocal(Session.java:425)
   at org.h2.engine.Session.prepareCommand(Session.java:374)
   at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1056)
   at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:71)
   at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:443)
   at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458)
   at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466)
   at marubinotto.piggydb.external.jdbc.h2.H2FragmentRepository.getIdsByFilter(H2FragmentRepository.java:414)
   at marubinotto.piggydb.external.jdbc.h2.H2FragmentRepository.findByFilter(H2FragmentRepository.java:371)
   at marubinotto.piggydb.presentation.page.html.FragmentsByFilter.setFragments(FragmentsByFilter.java:21)
   at marubinotto.piggydb.presentation.page.html.AbstractFragments.setModels(AbstractFragments.java:73)
   at marubinotto.piggydb.presentation.page.AbstractPage.onRender(AbstractPage.java:369)
   at marubinotto.piggydb.presentation.page.html.AbstractHtml.onRender(AbstractHtml.java:15)
   at net.sf.click.ClickServlet.processPage(ClickServlet.java:588)
   at net.sf.click.ClickServlet.handleRequest(ClickServlet.java:356)
   at net.sf.click.ClickServlet.doGet(ClickServlet.java:284)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1219)
   at marubinotto.util.web.CustomizedSecurityFilter.doFilter(CustomizedSecurityFilter.java:29)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)
   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:424)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494)
   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)
   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:931)
   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:361)
   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)
   at org.eclipse.jetty.server.Server.handle(Server.java:337)
   at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581)
   at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1005)
   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:560)
   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:222)
   at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417)
   at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474)
   at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:437)
   at java.lang.Thread.run(Unknown Source)

Page
Classname   marubinotto.piggydb.presentation.page.html.FragmentsByFilter
Path   /html/fragments-by-filter.htm