410134 - [Oracle] Make Oracle case-insensitive for Bugzilla

Status: RESOLVED FIXED

(Bugzilla :: Database, enhancement)

Description

[Xiaoou]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
Build Identifier: 

By default, query in Oracle is case-sensitive, but Bugzilla is 
case-insensitive.

Reproducible: Always

Comment 1

[Xiaoou]

Attachment: v1

Accent-Insensitive

Comment 2

[Max Kanat-Alexander]

Comment on attachment 294805 [details] [diff] [review]
v1

Beautiful! Case-insensitive and accent-insensitive! Great! :-)

Comment 3

[Max Kanat-Alexander]

This is going to need to be documented somewhere, that Oracle databases are both case-insensitive and accent-insensitive for Bugzilla, meaning that, for example, "FrÈdèriC" is the same as "frederic".

Checking in Bugzilla/DB/Oracle.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Oracle.pm,v  <--  Oracle.pm
new revision: 1.4; previous revision: 1.3
done

Comment 4

[Sam Folk-Williams]

should we put this in "5.5. Searching for Bugs" or "5.8. Hints and Tips"?

Comment 5

[Sam Folk-Williams]

Attachment: draft 1

is this what you have in mind for documentation?

Comment 6

[Max Kanat-Alexander]

Comment on attachment 297572 [details] [diff] [review]
draft 1

You don't need to add the bit about Oracle.

You should note that PostgreSQL is case-sensitive for some things, though, and case-insensitive for others.

Comment 7

[Sam Folk-Williams]

Attachment: clarified the 3 dbs

Comment 8

[Frédéric Buclin]

Comment on attachment 297584 [details] [diff] [review]
clarified the 3 dbs

Looks good to me and the information is accurate. r=LpSolit

Comment 9

[Frédéric Buclin]

Sam, we need to backport the doc patch to 3.0 and 2.22 as we don't mention the difference between MySQL and PostgreSQL on these branches.

Comment 10

[Sam Folk-Williams]

Attachment: backport to 2.22

for 2.22 branch

Comment 11

[Sam Folk-Williams]

Attachment: patch for 3.0

patch for 3.0

Comment 12

[Frédéric Buclin]

Comment on attachment 297993 [details] [diff] [review]
backport to 2.22

>+      Bugzilla queries are case-insensitive and accent-insensitive, when
>+      used with either MySQL or Oracle databases.

Doesn't make sense to talk about Oracle on 2.22 as we don't even support it on this branch.

Comment 13

[Frédéric Buclin]

Comment on attachment 297994 [details] [diff] [review]
patch for 3.0

>     <section id="list">
>+
>+    <section id="casesensitivity">

Err... You pasted the text at the wrong place. id="list" should come later.


>+      Bugzilla queries are case-insensitive and accent-insensitive, when
>+      used with either MySQL or Oracle databases.

Don't talk about Oracle as 3.0 doesn't support it.

Comment 14

[Sam Folk-Williams]

Attachment: version 2.22 patch

Comment 15

[Sam Folk-Williams]

Attachment: 3.0 doc patch

Comment 16

[Frédéric Buclin]

Comment on attachment 298023 [details] [diff] [review]
version 2.22 patch

>+      the way PostreSQL handles case and accent sensitivity. 

s/PostreSQL/PostgreSQL/

Comment 17

[Frédéric Buclin]

Comment on attachment 298025 [details] [diff] [review]
3.0 doc patch

>+      the way PostreSQL handles case and accent sensitivity. 

PostgreSQL


>     <section id="list">
>+
>       <title>Bug Lists</title>

Useless newline. Should be removed on checkin. r=LpSolit

Comment 18

[Frédéric Buclin]

tip:

Checking in docs/xml/using.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/using.xml,v  <--  using.xml
new revision: 1.77; previous revision: 1.76
done

3.0.3:

Checking in docs/xml/using.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/using.xml,v  <--  using.xml
new revision: 1.64.2.10; previous revision: 1.64.2.9
done

2.22.3:

Checking in docs/xml/using.xml;
/cvsroot/mozilla/webtools/bugzilla/docs/xml/using.xml,v  <--  using.xml
new revision: 1.37.2.24; previous revision: 1.37.2.23
done