{"action":"closed","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/203","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/203/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/203/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/203/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/203","id":57669875,"number":203,"title":"Running a query and % is dropped?","user":{"login":"StormTrooper","id":1429043,"avatar_url":"https://avatars.githubusercontent.com/u/1429043?v=3","gravatar_id":"","url":"https://api.github.com/users/StormTrooper","html_url":"https://github.com/StormTrooper","followers_url":"https://api.github.com/users/StormTrooper/followers","following_url":"https://api.github.com/users/StormTrooper/following{/other_user}","gists_url":"https://api.github.com/users/StormTrooper/gists{/gist_id}","starred_url":"https://api.github.com/users/StormTrooper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/StormTrooper/subscriptions","organizations_url":"https://api.github.com/users/StormTrooper/orgs","repos_url":"https://api.github.com/users/StormTrooper/repos","events_url":"https://api.github.com/users/StormTrooper/events{/privacy}","received_events_url":"https://api.github.com/users/StormTrooper/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/milestones/6","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/milestones/6/labels","id":968715,"number":6,"title":"3.6","description":"","creator":{"login":"MKleusberg","id":3153504,"avatar_url":"https://avatars.githubusercontent.com/u/3153504?v=3","gravatar_id":"","url":"https://api.github.com/users/MKleusberg","html_url":"https://github.com/MKleusberg","followers_url":"https://api.github.com/users/MKleusberg/followers","following_url":"https://api.github.com/users/MKleusberg/following{/other_user}","gists_url":"https://api.github.com/users/MKleusberg/gists{/gist_id}","starred_url":"https://api.github.com/users/MKleusberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MKleusberg/subscriptions","organizations_url":"https://api.github.com/users/MKleusberg/orgs","repos_url":"https://api.github.com/users/MKleusberg/repos","events_url":"https://api.github.com/users/MKleusberg/events{/privacy}","received_events_url":"https://api.github.com/users/MKleusberg/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":3,"state":"open","created_at":"2015-02-06T13:24:57Z","updated_at":"2015-02-15T07:07:19Z","due_on":"2015-03-01T23:00:00Z","closed_at":null},"comments":8,"created_at":"2015-02-13T23:52:09Z","updated_at":"2015-02-15T07:07:19Z","closed_at":"2015-02-15T07:07:19Z","body":"Table:\r\n\r\nBEGIN TRANSACTION;\r\nCREATE TABLE `table1` (\r\n\t`Field1`\tTEXT\r\n);\r\nINSERT INTO `table1` VALUES ('testing');\r\nINSERT INTO `table1` VALUES ('123');\r\nINSERT INTO `table1` VALUES ('87654');\r\nCOMMIT;\r\n\r\n\r\nQuery:\r\nselect * from table1 where CAST(Field1 AS Text) LIKE '%2%'\r\n\r\n\r\n1 Rows returned from: select * from table1 where CAST(Field1 AS Text) LIKE '2%' (took %3ms)\r\n\r\nThe % in front of '2%' is dropped and no results are returned.\r\n\r\nVer 3.5.1\r\nSQlLite version: 3.8.8.2\r\n\r\n\r\n"}}