{"action":"created","issue":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/6242","repository_url":"https://api.github.com/repos/apache/incubator-superset","labels_url":"https://api.github.com/repos/apache/incubator-superset/issues/6242/labels{/name}","comments_url":"https://api.github.com/repos/apache/incubator-superset/issues/6242/comments","events_url":"https://api.github.com/repos/apache/incubator-superset/issues/6242/events","html_url":"https://github.com/apache/incubator-superset/issues/6242","id":375876648,"node_id":"MDU6SXNzdWUzNzU4NzY2NDg=","number":6242,"title":"sqlab + firebird 2.5 -> error","user":{"login":"bbs2009","id":11568424,"node_id":"MDQ6VXNlcjExNTY4NDI0","avatar_url":"https://avatars0.githubusercontent.com/u/11568424?v=4","gravatar_id":"","url":"https://api.github.com/users/bbs2009","html_url":"https://github.com/bbs2009","followers_url":"https://api.github.com/users/bbs2009/followers","following_url":"https://api.github.com/users/bbs2009/following{/other_user}","gists_url":"https://api.github.com/users/bbs2009/gists{/gist_id}","starred_url":"https://api.github.com/users/bbs2009/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bbs2009/subscriptions","organizations_url":"https://api.github.com/users/bbs2009/orgs","repos_url":"https://api.github.com/users/bbs2009/repos","events_url":"https://api.github.com/users/bbs2009/events{/privacy}","received_events_url":"https://api.github.com/users/bbs2009/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-31T09:44:51Z","updated_at":"2018-11-01T16:50:55Z","closed_at":null,"author_association":"NONE","body":"Greetings to all.\r\nI'm having a problem with the firebird database.\r\n\r\n- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.\r\n- [x] I have reproduced the issue with at least the latest released version of superset.\r\n- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.\r\n#2452\r\n\r\n### Superset version - latest\r\n\r\nI'm add connection:\r\n\r\n![default](https://user-images.githubusercontent.com/11568424/47778573-d732c500-dcff-11e8-8360-ce3cee5ffc64.png)\r\n\r\nI can see table from firebird\r\n\r\n![default](https://user-images.githubusercontent.com/11568424/47778695-13febc00-dd00-11e8-8f4e-1c049478198e.png)\r\n\r\nwhen  I tried to make a simple query in the sql lab(select * from users) but an error occurred.\r\n![default](https://user-images.githubusercontent.com/11568424/47778795-44def100-dd00-11e8-8189-c7cb312a2425.png)\r\n\r\nfrom terminal logs\r\n`2018-10-31 09:29:23,709:INFO:root:Parsing with sqlparse statement select * from users\r\n2018-10-31 09:29:23,718:INFO:root:Set query to 'running'\r\n2018-10-31 09:29:23,742:INFO:root:Database.get_sqla_engine(). Masked URL: firebird+fdb://MKP:XXXXXXXXXX@192.168.2.15:3050/C:/BD/BD\r\n2018-10-31 09:29:23,964:INFO:root:Running query:\r\nselect * from users LIMIT 100000\r\n2018-10-31 09:29:23,965:INFO:root:select * from users LIMIT 100000\r\n2018-10-31 09:29:24,017:ERROR:root:('Error while preparing SQL statement:\\n- SQLCODE: -104\\n- Dynamic SQL Error\\n- SQL error code = -104\\n- Token unknown - line 1, column 27\\n- 100000', -104, 335544569)\r\nTraceback (most recent call last):\r\n  File \"/work/superset/lib/python3.6/site-packages/superset/sql_lab.py\", line 182, in execute_sql\r\n    db_engine_spec.execute(cursor, query.executed_sql, async_=True)\r\n  File \"/work/superset/lib/python3.6/site-packages/superset/db_engine_specs.py\", line 385, in execute\r\n    cursor.execute(query)\r\n  File \"/work/superset/lib/python3.6/site-packages/fdb/fbcore.py\", line 3626, in execute\r\n    self._ps = PreparedStatement(operation, self, True)\r\n  File \"/work/superset/lib/python3.6/site-packages/fdb/fbcore.py\", line 2254, in __init__\r\n    \"Error while preparing SQL statement:\")\r\nfdb.fbcore.DatabaseError: ('Error while preparing SQL statement:\\n- SQLCODE: -104\\n- Dynamic SQL Error\\n- SQL error code = -104\\n- Token unknown - line 1, column 27\\n- 100000', -104, 335544569)\r\n`\r\n\r\nBut! I can create a table, and then a chart.\r\n\r\n![default](https://user-images.githubusercontent.com/11568424/47779101-fbdb6c80-dd00-11e8-8114-e4021f770f5a.png)\r\n\r\nwhen i click View query\r\n![default](https://user-images.githubusercontent.com/11568424/47779270-6391b780-dd01-11e8-87a7-05289348ba64.png)\r\n\r\ni see\r\n\r\n`SELECT FIRST 10 u2 AS u2\r\nFROM \"USERS\";`\r\n\r\nThis request returns an error\r\n![default](https://user-images.githubusercontent.com/11568424/47779433-c1260400-dd01-11e8-8234-0545c473fbfd.png)\r\n\r\nif a little change - an error is returned again\r\n![default](https://user-images.githubusercontent.com/11568424/47779510-eca8ee80-dd01-11e8-8f28-229c63636ce1.png)\r\n\r\nHave ideas how to correct it?\r\nThanks for the help.\r\n"},"comment":{"url":"https://api.github.com/repos/apache/incubator-superset/issues/comments/435106457","html_url":"https://github.com/apache/incubator-superset/issues/6242#issuecomment-435106457","issue_url":"https://api.github.com/repos/apache/incubator-superset/issues/6242","id":435106457,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNTEwNjQ1Nw==","user":{"login":"mistercrunch","id":487433,"node_id":"MDQ6VXNlcjQ4NzQzMw==","avatar_url":"https://avatars1.githubusercontent.com/u/487433?v=4","gravatar_id":"","url":"https://api.github.com/users/mistercrunch","html_url":"https://github.com/mistercrunch","followers_url":"https://api.github.com/users/mistercrunch/followers","following_url":"https://api.github.com/users/mistercrunch/following{/other_user}","gists_url":"https://api.github.com/users/mistercrunch/gists{/gist_id}","starred_url":"https://api.github.com/users/mistercrunch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mistercrunch/subscriptions","organizations_url":"https://api.github.com/users/mistercrunch/orgs","repos_url":"https://api.github.com/users/mistercrunch/repos","events_url":"https://api.github.com/users/mistercrunch/events{/privacy}","received_events_url":"https://api.github.com/users/mistercrunch/received_events","type":"User","site_admin":false},"created_at":"2018-11-01T16:50:55Z","updated_at":"2018-11-01T16:50:55Z","author_association":"CONTRIBUTOR","body":"What does your connection string look like? Are you not specifying a database?"}}
{"actor":{"display_login":"mistercrunch"}}