Ben Clewett Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 14:10
Ben Clewett
Query optimizer-miss with unqualified expressions, bug or feature?
I have noticed that an unqualified boolean expression cannot be optimized by MySQL to use an index in 5.6.24.
For example:
CREATE TABLE t ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a BOOLEAN NOT NULL, KEY a (a) ) ENGINE=InnoDB;
This will hit key 'a':
SELECT * FROM t WHERE a = TRUE;
This will return the same results, but not use key 'a':
SELECT * FROM t WHERE a;
Is this a bug, or deliberate behaviour, or a missing feature, or perhaps something else?
Thanks,
Ben Clewett.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Oct 19
Roy Lyseng Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 15:19
Roy Lyseng
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19
Ben Clewett Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 15:07
Ben Clewett
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19
Roy Lyseng Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 21:48
Roy Lyseng
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19
shawn l.green Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 16:33
shawn l.green
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19
Roy Lyseng Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 19, 2015; 22:48
Roy Lyseng
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 20
Johan De Meersman Re: Query optimizer-miss with unqualified expressions, bug or feature?
Oct 20, 2015; 10:36
Johan De Meersman
Re: Query optimizer-miss with unqualified expressions, bug or feature?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!