Re: IT'S A BUG!
What makes you think the 2 select statement are the same?
The extra table in the 1st statement is not unused, the result of the 2 queries has to be very different.
The query with 2 tables is doing a cartesian product, and the result of it is a table of 1665 * 13656 rows, which exceeds 20 millions rows.
Edited 1 time(s). Last edit at 10/06/2005 01:36AM by KimSeong Loh.
Subject
Views
Written By
Posted
27751
August 11, 2005 11:25AM
23671
August 12, 2005 09:07AM
18966
August 12, 2005 01:06PM
18441
August 22, 2005 09:46AM
16545
August 24, 2005 03:27PM
12996
August 24, 2005 04:05PM
13689
August 26, 2005 11:02AM
7466
August 26, 2005 11:05AM
6850
August 26, 2005 11:45AM
6631
August 26, 2005 05:46PM
6895
August 26, 2005 10:34PM
6503
August 25, 2005 01:08PM
5897
August 26, 2005 11:07AM
5703
August 27, 2005 09:09AM
6029
August 29, 2005 11:50AM
5950
August 29, 2005 12:04PM
5305
August 29, 2005 12:55PM
5188
August 29, 2005 05:26PM
5160
August 29, 2005 06:34PM
4799
August 29, 2005 08:40PM
4674
August 29, 2005 08:47PM
4549
August 29, 2005 09:00PM
4735
August 30, 2005 10:05AM
4617
August 30, 2005 10:18AM
5135
August 30, 2005 10:20AM
6138
August 29, 2005 08:53PM
5011
August 29, 2005 09:50PM
4842
August 29, 2005 10:01PM
5289
August 30, 2005 08:53AM
4701
August 30, 2005 11:22AM
5241
August 30, 2005 11:33AM
4907
August 30, 2005 11:59AM
24375
August 31, 2005 02:32PM
6544
August 31, 2005 02:49PM
5223
August 31, 2005 02:56PM
5076
August 31, 2005 03:06PM
8321
December 07, 2006 10:30AM
5014
August 31, 2005 03:10PM
4889
August 31, 2005 03:32PM
17731
August 31, 2005 07:15PM
5135
September 01, 2005 03:05AM
7854
September 15, 2005 04:31PM
5578
September 01, 2005 04:39AM
4474
September 08, 2005 09:53AM
4837
September 08, 2005 11:25AM
4616
September 26, 2005 11:52AM
4527
September 26, 2005 12:13PM
4454
September 27, 2005 09:55AM
4238
September 27, 2005 10:18AM
4138
September 28, 2005 10:29AM
4279
September 28, 2005 10:34AM
4453
September 28, 2005 10:52AM
4913
September 28, 2005 10:58AM
9700
September 23, 2005 01:56AM
4977
September 23, 2005 07:11AM
4956
October 05, 2005 04:58AM
5252
October 05, 2005 04:52PM
6171
October 05, 2005 11:49PM
Re: IT'S A BUG!
5416
October 06, 2005 01:34AM
6738
October 06, 2005 04:57PM
4668
December 13, 2005 10:28AM
4658
December 13, 2005 10:34AM
4572
November 17, 2005 09:39AM
4925
January 08, 2007 12:12PM
4795
December 12, 2005 02:13PM
4639
December 14, 2005 11:43PM
4225
December 15, 2005 08:37AM
4304
December 15, 2005 11:18AM
4221
December 15, 2005 11:27AM
4340
December 15, 2005 11:32AM
4090
December 15, 2005 11:43AM
4052
December 15, 2005 11:43AM
4222
December 15, 2005 11:48AM
4107
December 15, 2005 11:51AM
4498
December 15, 2005 02:14PM
4155
December 15, 2005 02:18PM
4030
December 15, 2005 02:27PM
4525
December 15, 2005 02:43PM
4062
December 15, 2005 08:46AM
5062
January 26, 2006 12:38PM
4186
January 26, 2006 01:48PM
4258
January 26, 2006 01:48PM
4049
January 26, 2006 01:52PM
4186
January 27, 2006 04:46PM
4070
January 29, 2006 11:21AM
4404
January 30, 2006 09:42AM
4440
February 27, 2006 02:17PM
4121
February 27, 2006 02:23PM
4351
March 05, 2006 04:56AM
4175
March 06, 2006 08:09AM
4143
April 05, 2006 01:03PM
4317
September 27, 2006 08:43AM
4275
November 19, 2006 04:42AM
4423
December 14, 2006 05:45PM
4244
February 01, 2007 04:40AM
4920
November 11, 2007 01:24PM
5124
December 20, 2007 10:40AM
6566
January 21, 2008 10:14AM
5897
January 21, 2008 10:53AM
5373
May 19, 2008 09:41AM
5575
February 05, 2008 10:27AM
6121
March 12, 2008 08:37AM
5435
May 19, 2008 03:02AM
6169
November 14, 2008 12:31AM
7182
March 06, 2009 03:36PM