Description: Error with Calc, when add data as result exec select-query for table FireBird Steps to Reproduce: 1. Create in GUI form FIREBIRD table (simple): id intger autoinc , name varchar 100 2. add record on table (in DB-form ) 3. Create query: SELECT * FROM "table111" WHERE "id" > 3 4. drug and drop Query from DB-form on Calc-form Actual Results: Невозможно обновить содержимое данных firebird_sdbc error: *Dynamic SQL Error *SQL error code = -206 Column unnoun *id *At line 1, column 26 caused by 'isc_dsql_prepare' Expected Results: ID NAME 4 bgb 5 bgbg 6 bgbgbb 7 bgb Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: ru Module: OfficeDatabaseDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
Created attachment 141792 [details] screenshot of error screenshot of error
Have tested this one with Version: 6.1.0.0.alpha1 Build-ID: cb47f0d320994e001bc38dc2ee9b7d957b15e6ab CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4; Gebietsschema: de-DE (de_DE.UTF-8); Calc: group No problems to import data from an internal Firebird-database to Calc. Used the same table-structure ("id" INTEGER, "Name" VARCHAR). Used the same query. Works. The error says: The column "id" is unknown. Does the query run without problems in Firebird?
Thank you for your attention to the request! The problem was solved by changing the query, the field name was written in uppercase "ID", not "id", as before. Expected the query to be case insensitive in field names.
(In reply to Al Ko from comment #3) > Thank you for your attention to the request! > > The problem was solved by changing the query, the field name was written in > uppercase "ID", not "id", as before. > Expected the query to be case insensitive in field names. Seems this doesn't happen with the internal Firebird database. I will set this one to WORKSFORME, because this isn't a problem of copy and paste to Calc. Feel free to report a new bug for case insensitive field names. I don't know if case-sensitive fieldnames are standard for Firebird 3.0. Don't think it is a bug if LO will work with case sensitive fieldnames.
This problem not related with LO Calc, perhaps with DBMS FireBird