bbs2009 opened a new issue #6242: sqlab + firebird 2.5 -> error URL: https://github.com/apache/incubator-superset/issues/6242 Greetings to all. I'm having a problem with the firebird database. - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [ ] I have checked the issue tracker for the same issue and I haven't found one similar. #2452 ### Superset version - latest I'm add connection:  I can see table from firebird  when I tried to make a simple query in the sql lab(select * from users) but an error occurred.  from terminal logs `2018-10-31 09:29:23,709:INFO:root:Parsing with sqlparse statement select * from users 2018-10-31 09:29:23,718:INFO:root:Set query to 'running' 2018-10-31 09:29:23,742:INFO:root:Database.get_sqla_engine(). Masked URL: firebird+fdb://MKP:[email protected]:3050/C:/BD/BD 2018-10-31 09:29:23,964:INFO:root:Running query: select * from users LIMIT 100000 2018-10-31 09:29:23,965:INFO:root:select * from users LIMIT 100000 2018-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) Traceback (most recent call last): File "/work/superset/lib/python3.6/site-packages/superset/sql_lab.py", line 182, in execute_sql db_engine_spec.execute(cursor, query.executed_sql, async_=True) File "/work/superset/lib/python3.6/site-packages/superset/db_engine_specs.py", line 385, in execute cursor.execute(query) File "/work/superset/lib/python3.6/site-packages/fdb/fbcore.py", line 3626, in execute self._ps = PreparedStatement(operation, self, True) File "/work/superset/lib/python3.6/site-packages/fdb/fbcore.py", line 2254, in __init__ "Error while preparing SQL statement:") fdb.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) ` But! I can create a table, and then a chart.  when i click View query  i see `SELECT FIRST 10 u2 AS u2 FROM "USERS";` This request returns an error  if a little change - an error is returned again  Have ideas how to correct it? Thanks for the help.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
