summaryrefslogtreecommitdiffstats
path: root/Bugzilla/Search.pm
AgeCommit message (Collapse)AuthorFilesLines
2005-04-20Bug 284599: Use of REGEXP search is not consistent wrt case sensitivitymkanat%kerio.com1-3/+3
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
2005-04-16Bug 286360: ANSI SQL does not allow aliases to be used in HAVING clausemkanat%kerio.com1-9/+14
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=myk, r=joel, a=myk
2005-04-05Bug 286461:Add products table to search if classification are neededbugreport%peshkin.net1-0/+4
Patch by joel r=gerv, a=justdave
2005-03-17Bug 284125: PostgreSQL cannot call SUM on a boolean (Boolean Charts)mkanat%kerio.com1-2/+2
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
2005-03-16Bug 174295: ANSI SQL requires all columns in SELECT to be in GROUP BY, ↵mkanat%kerio.com1-3/+15
unless they are in "aggregate" functions Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=joel, a=myk
2005-03-16Bug 283581 : Move UserInGroup out of globals.pltravis%sedsystems.ca1-5/+5
Patch by Colin Ogilvie <colin.ogilvie@gmail.com> r=mkanat a=justdave
2005-03-15Bug 251960: Search.pm uses DB dependent comma operatormkanat%kerio.com1-89/+110
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=joel, a=justdave
2005-03-09Bug 281582: Replace CONCAT and MATCH with Bugzilla::DB function call (Note: ↵mkanat%kerio.com1-11/+15
This patch also creates a database-agnostic fulltext search method.) Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=myk
2005-03-05Bug 284598: INSTR function is not supported by postgresmkanat%kerio.com1-14/+9
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
2005-03-03Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQLmkanat%kerio.com1-1/+1
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=wicked, a=justdave
2005-03-03Bug 284172: checksetup cannot run CREATE DATABASE on PostgreSQLmkanat%kerio.com1-2/+2
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=glob, a=justdave
2005-02-25Bug 264192: Fix search where BugsThisDependsOn or OtherBugsDependingOnThis ↵bugreport%peshkin.net1-4/+8
is empty Patch by Joel Peshkin <bugreport@peshkin.net> r=mkanat, a=myk
2005-02-25Bug 283237: Move DBname_to_id out of globals.plmkanat%kerio.com1-1/+2
Patch By Max Kanat-Alexander <mkanat@kerio.com> r=wurblzap, a=myk
2005-02-25Bug 17453: Enumerators in Bugzilla are not cross-DB compatible. This removes ↵mkanat%kerio.com1-2/+14
all 'enum' types in the database from Bugzilla. Patch By Max Kanat-Alexander <mkanat@kerio.com> r=joel, a=justdave
2005-02-20Bug 280502: Replace "INTERVAL" with Bugzilla::DB function callmkanat%kerio.com1-1/+1
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
2005-02-20Bug 280499: Replace "TO_DAYS()" with Bugzilla::DB function callmkanat%kerio.com1-1/+2
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
2005-02-19Bug 282705: Remove newlines from LEFT JOIN parts of SQL in Search.pmbugreport%peshkin.net1-9/+9
r=lpsolit, a=justdave
2005-02-19Bug 253721: Add group-based lists to whiningerik%dasbistro.com1-20/+3
Patch by Erik Stambaugh <erik@dasbistro.com> r=joel, r,a=justdave
2005-02-19Bug 280497: Replace "LIMIT" with Bugzilla::DB function callmkanat%kerio.com1-1/+3
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat,a=justdave
2005-02-17Bug 280495: Replace "REGEXP" with Bugzilla::DB function callmkanat%kerio.com1-5/+8
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=wurblzap, a=myk
2005-02-16Bug 189366 : real name columns should fall back to e-mail nametravis%sedsystems.ca1-6/+3
Patch by Marc Schumann <wurblzap@gmail.com> r=LpSolit,jpeshkin a=justdave
2005-01-19Bug 179451 : Move order-by generation from buglist.cgi into search.pmtravis%sedsystems.ca1-5/+104
Patch by Max K-A <mkanat@kerio.com> r=Joel Peshkin <bugreport@peshkin.net> a=myk
2005-01-16Patch for bug 103636: Support specifying a date on which a bug is expected ↵jocuri%softhome.net1-2/+30
to be resolved; patch by Alexandre Michetti Manduca <michetti@grad.icmc.usp.br>, r=jouni, a=myk.
2004-12-31Patch for bug 275788: Provide a line of code that defines legal query ↵jocuri%softhome.net1-0/+11
formats for other scripts to use; patch by Colin S. Ogilvie <colin.ogilvie@gmail.com>, r=vladd, a=justdave.
2004-12-31Patch for bug 275523: Replace INNER JOIN in flag searches with LEFT JOIN; ↵jocuri%softhome.net1-8/+12
patch by me, r=joel, a=justdave.
2004-12-14Patch for bug 270823: Remove failure on search 'time since owner touched ↵jocuri%softhome.net1-2/+2
bug' (remove linebreaks from middle join clause); patch by Joel Peshkin <bugreport@peshkin.net>, r=justdave, r=vladd, a=justdave.
2004-12-14Patch for bug 252889: Change Search.pm activity log joins to LEFT JOINS; ↵jocuri%softhome.net1-49/+43
patch by Joel Peshkin <bugreport@peshkin.net>, r=justdave, a=justdave.
2004-09-11Bug 255663: Query on [Bug creation] and anything to do with attachments no ↵justdave%bugzilla.org1-2/+2
longer crashes r=joel, a=myk
2004-09-11Fix for bug 215319: changes "flag requester" field in boolean charts to ↵myk%mozilla.org1-4/+4
"flag requestee" field, which is what it should have been ("flag requester" can be queried via the "flag setter" field) r=justdave
2004-08-21Bug 224208 Add a higher level of categorization (.ie departments, locations, ↵bugreport%peshkin.net1-1/+16
etc.) patch by Albert Ting r=joel, glob a=myk
2004-08-11Bug 244239: Add group-based pronouns to querybugreport%peshkin.net1-0/+68
r=erik,justdave a=justdave
2004-07-31Bug 253588: Change Bugzilla->user to be usable even for a logged-out userbugreport%peshkin.net1-3/+3
patch by erik,joel r=kiko a=justdave
2004-07-29Bug 204903: Enable searches to match NULL aliases, missing qa_contact, and ↵bugreport%peshkin.net1-3/+16
search on CC even when cc-list is empty r=jouni a=myk
2004-07-22Bug 238544: Emit appropriate error if content and matches are used inbugreport%peshkin.net1-0/+6
invalid search combinations. r=jouni a=justdave
2004-07-21Bug 245272: Add per-chart negation to boolean searchesbugreport%peshkin.net1-1/+9
r=justdave,myk,timeless a=myk
2004-07-17Bug 251567: Make sure "find a specific bug" doesn't miss exact matches in ↵bugreport%peshkin.net1-1/+9
summary r=justdave a=justdave
2004-07-13Bug 226434: Add %reporter%, %user%, and %assignee% pronouns to boolean chartsbugreport%peshkin.net1-10/+76
r=jouni a=justdave
2004-07-12Bug 245158: Combine multiple redundant LEFT JOINs into a single LEFT JOIN in ↵bugreport%peshkin.net1-4/+16
Search.pm r=zach,justdave a=justdave
2004-07-06Bug 223878: Flag system dies when changing a deleted flag.jouni%heikniemi.net1-1/+2
r=joel, justdave a=justdave
2004-06-02Bug 244927: Add search on time owner has left the bug idlebugreport%peshkin.net1-0/+36
r=jouni a=myk
2004-05-27Bug 243351: Fix mysql version sensitivity in case-sensitive searchbugreport%peshkin.net1-1/+9
r=jouni a=justdave
2004-05-26Bug 244650: Fix query on commentor in combination with other email-based ↵bugreport%peshkin.net1-17/+27
criteria r=justdave a=justdave
2004-04-06Fix for bug 237176: allows power users to display relevance values as a ↵myk%mozilla.org1-8/+16
column in the search results for a fulltext search r=justdave a=justdave
2004-02-13Fix for bug 234100: removes redundant longdescs table join criterionmyk%mozilla.org1-1/+0
r=justdave
2004-01-26Fix for bug 232164: Adds backwards-compatibility hack for changedin queries ↵myk%mozilla.org1-16/+27
for newly created bugs and simplifies the code. r=bbaetz
2004-01-26Fix for bug 232150: Corrects "field changed" queries including [Bug ↵myk%mozilla.org1-10/+19
creation] as one of the fields so that they actually work instead of taking forever. The query was structured as "[Bug creation] clause OR (bugs_activity JOIN clause OR (other field clauses))" when it should have been "bugs_activity JOIN CLAUSE AND ([Bug creation] clause OR other field clauses)" r=bbaetz a=myk
2004-01-21Bug 225075: Fix exact case search so it only selects bugs with matching case ↵bugreport%peshkin.net1-1/+1
strings. r=bbaetz, a=justdave
2003-11-23Bug 226284 - slow queries for creation_tsbbaetz%acm.org1-1/+1
r,a=justdave
2003-11-03Bu 210735 - collectstats.pl broken. Removes "uninitialised value" warning. ↵gerv%gerv.net1-2/+1
Patch by gerv; r=bbaetz, a=justdave.
2003-09-14Bug 208699 - Move Throw{Code,Template}Error into Error.pmbbaetz%acm.org1-4/+5
r,a=justdave