{"action":"created","issue":{"url":"https://api.github.com/repos/infinidb/infinidb/issues/11","labels_url":"https://api.github.com/repos/infinidb/infinidb/issues/11/labels{/name}","comments_url":"https://api.github.com/repos/infinidb/infinidb/issues/11/comments","events_url":"https://api.github.com/repos/infinidb/infinidb/issues/11/events","html_url":"https://github.com/infinidb/infinidb/issues/11","id":67290388,"number":11,"title":"Bug report for Infinidb 4.6.2","user":{"login":"tongsir","id":11866018,"avatar_url":"https://avatars.githubusercontent.com/u/11866018?v=3","gravatar_id":"","url":"https://api.github.com/users/tongsir","html_url":"https://github.com/tongsir","followers_url":"https://api.github.com/users/tongsir/followers","following_url":"https://api.github.com/users/tongsir/following{/other_user}","gists_url":"https://api.github.com/users/tongsir/gists{/gist_id}","starred_url":"https://api.github.com/users/tongsir/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tongsir/subscriptions","organizations_url":"https://api.github.com/users/tongsir/orgs","repos_url":"https://api.github.com/users/tongsir/repos","events_url":"https://api.github.com/users/tongsir/events{/privacy}","received_events_url":"https://api.github.com/users/tongsir/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-04-09T06:24:52Z","updated_at":"2015-06-10T14:01:52Z","closed_at":null,"body":"Hi there,\r\nthank you for your great job on such a great data warehouse,\r\nbut during trying Infinidb, I found a situation which will lead data inconsistency with what it should be, below is the step for reproduce the bug.\r\n\r\n\r\nmysql> create table t2 (c1 varchar(100), c2 varchar(100))engine=infinidb;\r\nQuery OK, 0 rows affected (13.23 sec)\r\n\r\nmysql> insert into t2 values (\"12345\",\"12345\"),(\"23456\",\"23456\"),(\"34567\",\"34567\");\r\nQuery OK, 3 rows affected (40.09 sec)\r\n\r\nmysql> SELECT c1 FROM t2 WHERE t2.c1 LIKE CONCAT((IF('62101'='62101','1','2')),'%');\r\n+-------+\r\n| c1    |\r\n+-------+\r\n| 12345 |\r\n| 23456 |\r\n| 34567 |\r\n+-------+\r\n3 rows in set (0.03 sec)\r\n\r\n\r\n\r\nyou can see that when the result set should be '12345', but its outcome is not.\r\n\r\nit seems this bug only occur when LIKE, CONCAT and IF is used together.\r\n\r\nwaiting for your reply at sitong@outlook.com :)\r\n\r\nregards."},"comment":{"url":"https://api.github.com/repos/infinidb/infinidb/issues/comments/110765665","html_url":"https://github.com/infinidb/infinidb/issues/11#issuecomment-110765665","issue_url":"https://api.github.com/repos/infinidb/infinidb/issues/11","id":110765665,"user":{"login":"davidhilldallas","id":7253836,"avatar_url":"https://avatars.githubusercontent.com/u/7253836?v=3","gravatar_id":"","url":"https://api.github.com/users/davidhilldallas","html_url":"https://github.com/davidhilldallas","followers_url":"https://api.github.com/users/davidhilldallas/followers","following_url":"https://api.github.com/users/davidhilldallas/following{/other_user}","gists_url":"https://api.github.com/users/davidhilldallas/gists{/gist_id}","starred_url":"https://api.github.com/users/davidhilldallas/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidhilldallas/subscriptions","organizations_url":"https://api.github.com/users/davidhilldallas/orgs","repos_url":"https://api.github.com/users/davidhilldallas/repos","events_url":"https://api.github.com/users/davidhilldallas/events{/privacy}","received_events_url":"https://api.github.com/users/davidhilldallas/received_events","type":"User","site_admin":false},"created_at":"2015-06-10T14:01:52Z","updated_at":"2015-06-10T14:01:52Z","body":"Thanks, 'schedule' is a better work. That is when we plan to do a QA on the builds and release to the public.\r\n\r\nAnd yes, these builds are available to the public. Here is the procedure:\r\n\r\n1. Create an account by clicking the \"Sign Up\" button from this WEB site:\r\n   https://mariadb.com/blog/infinidb-support-continues-part-mariadbs-service-offering\r\n2. Then after you log in, click \"My Portal\" button, top right, if you are already on the \"My Portal\" Page\r\n3. Click Downloads on tab bar\r\n4. Click InfiniDB, you should be on the InfiniDB page to select packages to download."}}