{"action":"created","issue":{"url":"https://api.github.com/repos/jdbi/jdbi/issues/1156","repository_url":"https://api.github.com/repos/jdbi/jdbi","labels_url":"https://api.github.com/repos/jdbi/jdbi/issues/1156/labels{/name}","comments_url":"https://api.github.com/repos/jdbi/jdbi/issues/1156/comments","events_url":"https://api.github.com/repos/jdbi/jdbi/issues/1156/events","html_url":"https://github.com/jdbi/jdbi/issues/1156","id":328686133,"node_id":"MDU6SXNzdWUzMjg2ODYxMzM=","number":1156,"title":"Problem using '<' mark in SqlQuery","user":{"login":"changan1995","id":25133089,"node_id":"MDQ6VXNlcjI1MTMzMDg5","avatar_url":"https://avatars1.githubusercontent.com/u/25133089?v=4","gravatar_id":"","url":"https://api.github.com/users/changan1995","html_url":"https://github.com/changan1995","followers_url":"https://api.github.com/users/changan1995/followers","following_url":"https://api.github.com/users/changan1995/following{/other_user}","gists_url":"https://api.github.com/users/changan1995/gists{/gist_id}","starred_url":"https://api.github.com/users/changan1995/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/changan1995/subscriptions","organizations_url":"https://api.github.com/users/changan1995/orgs","repos_url":"https://api.github.com/users/changan1995/repos","events_url":"https://api.github.com/users/changan1995/events{/privacy}","received_events_url":"https://api.github.com/users/changan1995/received_events","type":"User","site_admin":false},"labels":[{"id":335744163,"node_id":"MDU6TGFiZWwzMzU3NDQxNjM=","url":"https://api.github.com/repos/jdbi/jdbi/labels/question","name":"question","color":"207de5","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/jdbi/jdbi/milestones/5","html_url":"https://github.com/jdbi/jdbi/milestone/5","labels_url":"https://api.github.com/repos/jdbi/jdbi/milestones/5/labels","id":2162120,"node_id":"MDk6TWlsZXN0b25lMjE2MjEyMA==","number":5,"title":"JDBI 2.x maintenance","description":"","creator":{"login":"qualidafial","id":38629,"node_id":"MDQ6VXNlcjM4NjI5","avatar_url":"https://avatars2.githubusercontent.com/u/38629?v=4","gravatar_id":"","url":"https://api.github.com/users/qualidafial","html_url":"https://github.com/qualidafial","followers_url":"https://api.github.com/users/qualidafial/followers","following_url":"https://api.github.com/users/qualidafial/following{/other_user}","gists_url":"https://api.github.com/users/qualidafial/gists{/gist_id}","starred_url":"https://api.github.com/users/qualidafial/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qualidafial/subscriptions","organizations_url":"https://api.github.com/users/qualidafial/orgs","repos_url":"https://api.github.com/users/qualidafial/repos","events_url":"https://api.github.com/users/qualidafial/events{/privacy}","received_events_url":"https://api.github.com/users/qualidafial/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":24,"state":"open","created_at":"2016-11-28T20:56:36Z","updated_at":"2018-06-05T18:40:19Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2018-06-01T23:11:18Z","updated_at":"2018-06-05T18:42:10Z","closed_at":null,"author_association":"NONE","body":"`    //call insert into oss.\r\n    @SqlUpdate(\"INSERT INTO temp_expired_log_visit4 SELECT * FROM temp_log_visit WHERE visit_at <= 1500617376201\")\r\n    abstract void mvExpired();`\r\nI has a trouble using this Query, it's simply moving from this temp_log_visit to temp_expired_log_visit4;\r\nthe condition is visit_at(sometime) < 1500617376201L.\r\n\r\nThe error log is pretty strange:\r\n`line 1:103: expecting '>', found '<EOF>'`\r\n`  testTruncateExpired(com.borderx.fifthave.db.pg.PgLogVisitDAOTest): org.postgresql.util.PSQLException: ERROR: syntax error at end of input`\r\n\r\nI think that somehow the jbi.ondemand() consider < as a start of '<>' rather than less than...\r\n\r\nIs there a way to avoid it?\r\n"},"comment":{"url":"https://api.github.com/repos/jdbi/jdbi/issues/comments/394817388","html_url":"https://github.com/jdbi/jdbi/issues/1156#issuecomment-394817388","issue_url":"https://api.github.com/repos/jdbi/jdbi/issues/1156","id":394817388,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NDgxNzM4OA==","user":{"login":"qualidafial","id":38629,"node_id":"MDQ6VXNlcjM4NjI5","avatar_url":"https://avatars2.githubusercontent.com/u/38629?v=4","gravatar_id":"","url":"https://api.github.com/users/qualidafial","html_url":"https://github.com/qualidafial","followers_url":"https://api.github.com/users/qualidafial/followers","following_url":"https://api.github.com/users/qualidafial/following{/other_user}","gists_url":"https://api.github.com/users/qualidafial/gists{/gist_id}","starred_url":"https://api.github.com/users/qualidafial/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/qualidafial/subscriptions","organizations_url":"https://api.github.com/users/qualidafial/orgs","repos_url":"https://api.github.com/users/qualidafial/repos","events_url":"https://api.github.com/users/qualidafial/events{/privacy}","received_events_url":"https://api.github.com/users/qualidafial/received_events","type":"User","site_admin":false},"created_at":"2018-06-05T18:42:10Z","updated_at":"2018-06-05T18:42:10Z","author_association":"MEMBER","body":"Sure thing. My recollection is fuzzy but I believe we addressed this in the v2 branch--you could try version 2.78 and see if that fixes the `<` parsing."}}
{"actor":{"display_login":"qualidafial"}}