307479 2012-09-27 12:25:14 +0000 Kexi refuses to delete imported tables 2014-02-12 10:29:50 +0000 1 1 2 Applications KEXI General 2.5.2 openSUSE Linux CLOSED FIXED NOR major 2.5 0 guido staniek http://commits.kde.org/calligra/c8d4eb10b5d8256c74c02a54d313ceb5ce5db671 2.5.3 0 oldest_to_newest 1301030 0 guido 2012-09-27 12:25:14 +0000 I imported a couple of simple tables (all empty). It is not possible to delete them. When I try I always get a message "Could not remove object." Deleting a table I created using Kexi works. Reproducible: Always Steps to Reproduce: 1. Import tables from a distant MySQL-server into another db on the same server. 2. Select a table. 3. Press the delete-button. 4. Confirm the delete-warning. Actual Results: The error-message "Could not remove object." appears. Expected Results: The table should get deleted. If this is not possible because of any dependencies that have to be removed first (although I think in my case there aren't any) the message should point to them or - even better - offer to remove them too. 1301156 1 staniek 2012-09-27 21:12:49 +0000 Thanks for reporting. Could you please attach a sample database having the issue (below)? Can be the one with empty table(s). 1301507 2 74230 guido 2012-09-29 13:46:16 +0000 Created attachment 74230 Database with two undeletable tables The attached kexi-db contains two tables I managed to import (see bug #307575) from the db attached to bug #307571. 1303137 3 staniek 2012-10-04 22:35:07 +0000 Git commit 6e43601ab185afbbab8d18e78bf73214a17c3e64 by Jaroslaw Staniek. Committed on 04/10/2012 at 22:13. Pushed by staniek into branch 'calligra/2.5'. Fix the lowercase fix and db import KexiDB *A fix for the lowercase fix: keep table names in original format but compare them in case-insensitive way when needed **This way importing from databases with tables upper-case characters works Migration *Fix invalid SQL generation for database import *Fix importing from databases with tables upper-case characters Related: bug 306523 REVIEW:106726 M +5 -11 kexi/core/kexiproject.cpp M +14 -11 kexi/kexidb/connection.cpp M +1 -1 kexi/kexidb/expression.cpp M +1 -1 kexi/kexidb/tableschema.cpp M +26 -24 kexi/migration/keximigrate.cpp M +4 -3 kexi/migration/mysql/mysqlmigrate.cpp http://commits.kde.org/calligra/6e43601ab185afbbab8d18e78bf73214a17c3e64 1303140 4 staniek 2012-10-04 22:35:59 +0000 Git commit 420a12d13746f5d5cebd9a10d140fd66b141ab59 by Jaroslaw Staniek. Committed on 04/10/2012 at 22:13. Pushed by staniek into branch 'master'. Fix the lowercase fix and db import KexiDB *A fix for the lowercase fix: keep table names in original format but compare them in case-insensitive way when needed **This way importing from databases with tables upper-case characters works Migration *Fix invalid SQL generation for database import *Fix importing from databases with tables upper-case characters Related: bug 306523 M +5 -11 kexi/core/kexiproject.cpp M +26 -24 kexi/migration/keximigrate.cpp M +4 -3 kexi/migration/mysql/mysqlmigrate.cpp M +14 -11 libs/db/connection.cpp M +1 -1 libs/db/expression.cpp M +1 -1 libs/db/tableschema.cpp http://commits.kde.org/calligra/420a12d13746f5d5cebd9a10d140fd66b141ab59 1303141 5 staniek 2012-10-04 22:37:52 +0000 Importing issues have been fixed too by the way. 1303173 6 staniek 2012-10-04 23:44:49 +0000 Git commit c8d4eb10b5d8256c74c02a54d313ceb5ce5db671 by Jaroslaw Staniek. Committed on 04/10/2012 at 22:13. Pushed by staniek into branch 'kexi-altertable-staniek'. Fix the lowercase fix and db import KexiDB *A fix for the lowercase fix: keep table names in original format but compare them in case-insensitive way when needed **This way importing from databases with tables upper-case characters works Migration *Fix invalid SQL generation for database import *Fix importing from databases with tables upper-case characters Related: bug 306523 M +5 -11 kexi/core/kexiproject.cpp M +26 -24 kexi/migration/keximigrate.cpp M +4 -3 kexi/migration/mysql/mysqlmigrate.cpp M +11 -8 libs/db/connection.cpp M +1 -1 libs/db/expression.cpp M +1 -1 libs/db/tableschema.cpp http://commits.kde.org/calligra/c8d4eb10b5d8256c74c02a54d313ceb5ce5db671 1410734 7 staniek 2013-11-11 23:28:55 +0000 Git commit 676b32b8e2f506721ce3b6573f51673b84ba998c by Jaroslaw Staniek. Committed on 23/10/2013 at 20:20. Pushed by staniek into branch 'master'. Fix of handling case sensitivity of object names *A fix for the lowercase fix: keep table names in original format but compare them in case-insensitive way when needed **This way importing from databases with tables upper-case characters works Related: bug 306523 from Calligra master 420a12d13746f5d5ce M +14 -10 Predicate/Connection.cpp M +1 -1 Predicate/TableSchema.cpp M +0 -1 Predicate/expression/VariableExpression.cpp http://commits.kde.org/predicate/676b32b8e2f506721ce3b6573f51673b84ba998c 74230 2012-09-29 13:46:16 +0000 2012-09-29 13:46:16 +0000 Database with two undeletable tables auftrag_test_kexi_import.sql.bz2 application/x-bzip 1491 guido QlpoNDFBWSZTWYu9UjkAAprfgAAQcP//+n/v//D////wYAc/B5aNfQAA+dgAAoeGlT0nqeoNGIDI DQAAAADIGmjJocZMmjEMTTAQMCaYIwTE000AGEGp6Eo0jIxNNDTJgCYjTIyYQMAAINPUqeUzQRqA aBoAAAyAAAAAZSQD1A9RoyaAAANNAAAAAAVJICBMIZBNTxT1DU9J6am0nppqYCZpqA006k4DXaS6 rE47I00qpCpUVUpR6ailKqRrP9PO9sTTF1Boi1fh89h1bPhlZVSoleSyI8dkkjUPbVKqm/6Pq4VV tgyE3VBso/b5Xjp8X465xLy0jg7FHV+NCqlUVTblRYYiz0ix0FfQMGUoqrk3QqRKiU1NKVbNZbst 1JISUJJYLMgKJxlUAAAAAAEICMDp3dxDuneCUBgZgQIABdvVy7isz76qlVXNgk8muxi/DDBkP8k5 8m8KmIAIOVwiUwS2bQENc6qiWRclvziBNP77LAJGMDfCJB882jRn4S7tV9i+rltW8hwKRSh6JJpS UmAWWtRcOo+qd/RLKqqTAValKvOP8qqjlDzqqKSlfVJpk+m/ZUHjSqjpuuuqvFIp2V25S71LC6hF KPDZHCRndOzO7sz0J5xMM0raWrHRitZV6XO+rr2S6orCSzgh5SROiSIuAFgAYfUlpLoxUIXdkoa+ LEJJsVyUky1KjgqAEy+u6TlJvwy+ZUmbEXnxWKRfJQui1Rd7a57mCX2qwWystVF1tWXSLvbJxC2v JmsF2qKq/4aqNdGzLi8nH2bs/j6fW3Sq8VqXJff6/KPV9drWuFw4T3SsaqquH5j9Iy/EPuNA857k k0D4dfr+kfgLnpUpW/Flay0Ki1Wo+ccwyGs/Oewe7NJNqUlDoHNoHQKLJJYYDNwFPhyMx7zDIvhM h+phmOZJOfWMf0D8rf2+b7+BeOY5D9R1F5zj4DwFxmn7VBOtPeNx0yEuKQeaMeHE4i/dxejQbMg5 GYvL5D5MC8lF0hL4y4HT296bzMoo2ayMoeWpNMdytw0BmbzbeKKKGFGhFU0miTqbRoFzYMjO5kuj iK3jMta6opSiVSqqiy9FDAahsJRedMMW0UyGQ01dGMhMkkxKhea6xyJqL9XebSmkuGrLAyF+H2EZ v5vV5KqlLiy5cUAqKLKJh/ShUo8KxViilmDIiQg5QCAQ8N9KhLwwhh3tAlSo85iELmRApYqXLkDn vYa2dBE8p7Sh8ylCkToVxC3pknmlRGU9RMnoqohEcDMZuepVSRKlClCsYjkKV2+r3vPzczbS83fu 29lC4b4N0mEGnJoOO/gO/Zu3dbXOv980dmWTOS1qrFL5I09q5d412F2GEmcHdNa5jPjzl8JsFDEj M7Wa5rLJ3aljHZpwOuiYikdM5q2dK0lqtVU9Jxn+/e0P+Qmocn8TomcnQWTufv7OCzr1vP4ScGhs pVq5rp0YT3V0tN7bs8+mNDfxqpr3CLy++rQ8xHc7o7ifl9u14ax39UlWVwFk1vlg1KnP0tn8INs1 eOnQl1rrpdRg+QuvGM9GvzRqKNST0NzBnVKilKqVUmo0m1qkwTfIcUzMZ0yfNJyIqbKq9loM0jgr RcnRLpl76L185MXKaWzqz1TZzZs1FVVSuiYTtZWmoauO/OhVNtQ15Gupd5hhtyNKYF56x2jAvjAU shwnlLOZiNcRhrSi+Q82JHyXlo62DFiT5dClVVzfJe+/nmVT2U5vr6ujvv4Q3urmPA6V3VpM9Mzm /Tpd0mi9XEvU81VJrW191yTUjCClkqNpVwlzsHBllfJidZlMl8udBnBbGL5iWaCQ2LB7SFev34IE 4nEWnCCVdbyimV5ldVDNGqkvbxv8F/ho3FtO+q0Bkwkwo4qLcmcNRNu3FwmSbpOW7wOUKaZq3GUq KpTo7mlHPhstVVVVzuy4XNhjYcHu/hsNE9UYWqlbRzDSt9ostBpslj6OXK1dhIxfTofFrWMJp/i7 kinChIRd6pHI