diff options
author | Igor Babaev <igor@askmonty.org> | 2018-01-12 15:51:10 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2018-01-15 11:19:14 -0800 |
commit | 6267be460ab5147e3bc0fffd03e690b3650f2fe2 (patch) | |
tree | 992f21384f7445d87eccbb23f2b853e1aa0c2d6d /mysql-test/t/sp-destruct.test | |
parent | d8001106c97db246b33b977c09986beea22941bb (diff) | |
download | mariadb-git-6267be460ab5147e3bc0fffd03e690b3650f2fe2.tar.gz |
Fixed mdev-14911: zero_date is considered as NULL, depending on
optimizer_switch
For DATE and DATETIME columns defined as NOT NULL,
"date_notnull IS NULL" has to be modified to:
"date_notnull IS NULL OR date_notnull == 0"
if date_notnull is from an inner table of outer join);
"date_notnull == 0" - otherwise.
This must hold for such columns of mergeable views and derived
tables as well. So far the code did the above re-writing only
for columns of base tables and temporary tables.
Diffstat (limited to 'mysql-test/t/sp-destruct.test')
0 files changed, 0 insertions, 0 deletions