[MDEV-6065] MySQL Bug #13623473 MISSING ROWS ON SELECT AND JOIN WITH TIME/DATETIME COMPARE Created: 2014-04-10  Updated: 2018-02-09  Resolved: 2014-06-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.10
Fix Version/s: 10.0.12

Type: Bug Priority: Critical
Reporter: Sergey Vojtovich Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-4784 merge test cases from 5.6 Stalled
Relates
relates to MDEV-15262 Wrong results for SELECT..WHERE non_i... Closed

 Description   

Test case for MySQL "Bug #13623473 MISSING ROWS ON SELECT AND JOIN WITH TIME/DATETIME COMPARE" fails in 10.0. Please check if there is real bug here.

revno: 3402.50.166
committer: Guilhem Bichot <guilhem.bichot@oracle.com>
branch nick: trunk3
timestamp: Thu 2012-02-09 18:07:12 +0100
message:
  Bug #13623473 	MISSING ROWS ON SELECT AND JOIN WITH TIME/DATETIME COMPARE
  Cannot use index for indexed_time=datetime.
------------------------------------------------------------
revno: 3402.50.148
committer: Guilhem Bichot <guilhem.bichot@oracle.com>
branch nick: semijoin_ls
timestamp: Tue 2012-02-07 21:32:47 +0100
message:
  Temporarily revert fix for
  Bug#13623473 MISSING ROWS ON SELECT AND JOIN WITH TIME/DATETIME COMPARE
  until the failure of ps_2myisam on Windows non-debug builds
  in pb2 is fixed.
------------------------------------------------------------
revno: 3402.50.144
committer: Guilhem Bichot <guilhem.bichot@oracle.com>
branch nick: trunk3
timestamp: Tue 2012-02-07 14:09:03 +0100
message:
  Bug #13623473 	MISSING ROWS ON SELECT AND JOIN WITH TIME/DATETIME COMPARE
  Cannot use index for indexed_time=datetime.



 Comments   
Comment by Sergei Golubchik [ 2014-06-09 ]

bar, please, review. Commist are in the email:

Comment by Alexander Barkov [ 2014-06-10 ]

Okey to push (after addressing the issues discussed on IRC).

Generated at Thu Feb 08 07:09:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.