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