[GitHub] bbs2009 opened a new issue #6242: sqlab + firebird 2.5 -> error

[GitBox <gi...@apache.org>]

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:
   
   ![default](https://user-images.githubusercontent.com/11568424/47778573-d732c500-dcff-11e8-8360-ce3cee5ffc64.png)
   
   I can see table from firebird
   
   ![default](https://user-images.githubusercontent.com/11568424/47778695-13febc00-dd00-11e8-8f4e-1c049478198e.png)
   
   when  I tried to make a simple query in the sql lab(select * from users) but an error occurred.
   ![default](https://user-images.githubusercontent.com/11568424/47778795-44def100-dd00-11e8-8189-c7cb312a2425.png)
   
   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:XXXXXXXXXX@192.168.2.15: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.
   
   ![default](https://user-images.githubusercontent.com/11568424/47779101-fbdb6c80-dd00-11e8-8114-e4021f770f5a.png)
   
   when i click View query
   ![default](https://user-images.githubusercontent.com/11568424/47779270-6391b780-dd01-11e8-87a7-05289348ba64.png)
   
   i see
   
   `SELECT FIRST 10 u2 AS u2
   FROM "USERS";`
   
   This request returns an error
   ![default](https://user-images.githubusercontent.com/11568424/47779433-c1260400-dd01-11e8-8234-0545c473fbfd.png)
   
   if a little change - an error is returned again
   ![default](https://user-images.githubusercontent.com/11568424/47779510-eca8ee80-dd01-11e8-8f28-229c63636ce1.png)
   
   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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org