Victoria Reznichenko writes:
> Hi!
>
> SM> Are you using our binaries ??
>
> Yes.
>
> SM> If yes, send me a dump of the table and exact queries ...
>
> It's a strange...
>
> Seems, troubles occur when there is a fulltext index and the text
> column is NOT NULL. Besides, when I do CREATE .. SELECT, new table works fine ...
> The number of rows that appear in SELECT 8 FROM table_name doesn't
> depend on number of rows in the table, i.e. I have 2 table with 3 rows
> in each table:
>
> mysql> select 8 from qq;
> Empty set (0.00 sec)
>
> mysql> select 8 from bb;
> +---+
> | 8 |
> +---+
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> +---+
> 8 rows in set (0.00 sec)
>
> 8-[ ]
>
> Table aa contains 4 rows, but in the result I get:
>
> mysql> select 8 from aa;
> +---+
> | 8 |
> +---+
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> | 8 |
> +---+
> 5 rows in set (0.00 sec)
>
> I attached all three tables...
>
> --
> Victoria Reznichenko
Thank you for your bug report, which helped us fix a bug.
Here is a patch :
===== /mnt/hdc/Sinisa/mysql-4.0/sql/sql_select.cc 1.173 vs edited =====
*** /tmp/sql_select.cc-1.173-1672 Tue Jun 11 11:20:22 2002
--- edited//mnt/hdc/Sinisa/mysql-4.0/sql/sql_select.cc Fri Jun 14 14:42:01 2002
***************
*** 257,263 ****
--- 257,270 ----
}
TABLE_LIST *table;
for (table=tables ; table ; table=table->next)
+ {
join.tables++;
+ if (!thd->used_tables)
+ {
+ TABLE *tbl=table->table;
+ tbl->keys_in_use_for_query=tbl->used_keys= tbl->keys_in_use=0;
+ }
+ }
}
procedure=setup_procedure(thd,proc_param,result,fields,&error);
if (error)
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
