IS NOT DISTINCT FROM NULL doesn't use index
-------------------------------------------
Key: CORE-3722
URL: http://tracker.firebirdsql.org/browse/CORE-3722
Project: Firebird Core
Issue Type: Bug
Components: Engine
Reporter: Adriano dos Santos Fernandes
Problem happens only with the NULL constant. An expression resulting in NULL
works.
create table t (a varchar(5));
create index t_a on t (a);
select * from t where a is null;
PLAN (T INDEX (T_A))
select * from t where a is not distinct from null;
PLAN (T NATURAL)
select * from t where a is not distinct from null PLAN (T INDEX (T_A));
Statement failed, SQLSTATE = 42000
index T_A cannot be used in the specified plan
select * from t where a is not distinct from nullif('', '');
PLAN (T INDEX (T_A))
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual
desktops for less than the cost of PCs and save 60% on VDI infrastructure
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
