Re: [Apache Bloodhound] #654: Rows in ticket query result set not sorted by column

[Apache Bloodhound]

#654: Rows in ticket query result set not sorted by column
---------------------------+-----------------------------------
  Reporter:  olemis        |      Owner:  gjm
      Type:  defect        |     Status:  accepted
  Priority:  blocker       |  Milestone:  Release 8
 Component:  multiproduct  |    Version:
Resolution:                |   Keywords:  ticket query, sorting
---------------------------+-----------------------------------

Comment (by olemis):

 This is what I did , I applied [attachment:t654_r1551811_query_sort.diff
 this patch] like shown below

 {{{#!sh

 $ hg qapplied
 t654/t654_r1551811_query_sort.diff

 $ hg log -r qparent
 changeset:   506:ac7476a0b5da
 tag:         qparent
 tag:         svn-1551811
 user:        rjollos@13f79535-47bb-0310-9956-ffa450edef68
 date:        Wed Dec 18 02:31:10 2013 +0000
 summary:     0.8dev: Added Bootstrap styling to the diff form.

 }}}

 ... and , even if rows seem to be sorted by id , priority ... , I noticed
 this error in the logs

 [[span(Log entry, class=label label-important)]]
 {{{
 2014-01-05 21:35:59,541 Trac[theme] ERROR: BH: Quick create ticket failed
 column "product" specified more than once
 LINE 1: ...one,component,version,resolution,time,changetime, product) V...
 }}}

 [[span(Traceback, class=label label-important)]]
 {{{#!py

 Traceback (most recent call last):
   File "/path/to/bloodhound/bloodhound_theme/bhtheme/theme.py", line 595,
 in process_request
     product, tid = self.create(req, summary, desc, attrs, True)
   File "/path/to/bloodhound/bloodhound_theme/bhtheme/theme.py", line 638,
 in create
     t.insert()
   File "/path/to/bloodhound/trac/trac/ticket/model.py", line 241, in
 insert
     [values[name] for name in std_fields])
   File
 "/path/to/bloodhound/bloodhound_multiproduct/multiproduct/dbcursor.py",
 line 145, in execute
     return self.cursor.execute(sql, args=args)
   File
 "/path/to/bloodhound/bloodhound_multiproduct/multiproduct/dbcursor.py",
 line 85, in execute
     return super(BloodhoundIterableCursor,
 self).execute(translate_sql(self.env, sql), args=args)
   File "/path/to/bloodhound/trac/trac/db/util.py", line 65, in execute
     return self.cursor.execute(sql_escape_percent(sql), args)
 ProgrammingError: column "product" specified more than once
 LINE 1: ...one,component,version,resolution,time,changetime, product) V...
                                                              ^
 }}}

-- 
Ticket URL: <https://issues.apache.org/bloodhound/ticket/654#comment:13>
Apache Bloodhound <https://issues.apache.org/bloodhound/>
The Apache Bloodhound issue tracker