RE: creating index changes result of select query.

Grant Morgan writes:
> Creating an index on a in the queries below table causes a subsequent select
> query to produce a wrong result.
> How-To-Repeat:

[skip]

> When the index is created the final query returns too many rows. I tried
> create unique index temp on jp_domain (p_dom_name);
> I also tried creating the index as part of the create TABLE statement. all
> with the same reult. p_dom_name is a varchar 100 which may contain nulls
>
> jp_reconcile has a one column with a primary key on it
>
> Gran Morgan
>

One more notice.

We need a full repeatable test case, which you have not provided.

Which also includes a dump of the entire table.

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com

Join MySQL Users Conference and Expo:
http://www.mysql.com/events/uc2003/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13783@lists.mysql.com
To unsubscribe, e-mail