Re: 'Single quotation mark' makes different results for 'explain select'

2005-06-08 Thread Dan Nelson
In the last episode (Jun 08), Ying Lu said: > By the way, I am using 4.0.18-log on i686.linux2.6.10. > >I did the following two explain select ... According to whether I put > >the single quotation mark or not, I will get totally different results: > > > >1. Without single quotation mark: > > > >e

'Single quotation mark' makes different results for 'explain select'

2005-06-08 Thread Ying Lu
Greetings, I did the following two explain select ... According to whether I put the single quotation mark or not, I will get totally different results: 1. Without single quotation mark: explain SELECT * FROM test T1 force index (idx_test) WHERE *T1.STUDID = 099 AND T1.Prog_link = *;

Re: 'Single quotation mark' makes different results for 'explain select'

2005-06-08 Thread Ying Lu
By the way, I am using 4.0.18-log on i686.linux2.6.10. Greetings, I did the following two explain select ... According to whether I put the single quotation mark or not, I will get totally different results: 1. Without single quotation mark: explain SELECT * FROM test T1 force index (idx_t