[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-25 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

Jarosław Staniek  changed:

   What|Removed |Added

   Version Fixed In||3.0.1

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-25 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

--- Comment #12 from Jarosław Staniek  ---
OK Simeon, are you able to test the 3.0 and/or master branch?
Thanks.

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-25 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |FIXED
  Latest Commit||http://commits.kde.org/kdb/
   ||8f1a6ce31b7d12199669bff0eff
   ||b5925115663a4
 Status|ASSIGNED|RESOLVED

--- Comment #11 from Jarosław Staniek  ---
Git commit 8f1a6ce31b7d12199669bff0effb5925115663a4 by Jaroslaw Staniek.
Committed on 25/10/2016 at 18:01.
Pushed by staniek into branch 'master'.

Fix database cursors for PostgreSQL: remove use of uninitialized variable

M  +0-2src/KDbCursor.h
M  +1-1src/drivers/postgresql/PostgresqlCursor.cpp

http://commits.kde.org/kdb/8f1a6ce31b7d12199669bff0effb5925115663a4

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-25 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|--- |3.0.1

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-25 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|WAITINGFORINFO  |---
 Ever confirmed|0   |1
 Status|NEEDSINFO   |ASSIGNED

--- Comment #9 from Jarosław Staniek  ---
Good news. We had uninitialized variable just for the PostgreSQL driver. Will
be fixed today in master and 3.0 git branch so you can get it immediately. And
it will go to the 3.0.1 release.

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-21 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

--- Comment #7 from Jarosław Staniek  ---
Thanks for the report.
Binaries are not needed, at least I don't use them.

Before we find solution could you please try:
1. to use the SQLite db type for your work
2. to use the MySQL db type for your work

And tell me if you encounter any issues.

Please also try in you app KEXI_COMPATIBLE == true at
https://bitbucket.org/simeonKuran/kdb-test/src/5098cbad5d0a95694102fda03ab734cc6298fd7b/connection_widget.cpp?at=master=file-view-default

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-21 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

--- Comment #5 from Jarosław Staniek  ---
> sometimes one or the other DB calls seem to fail.

Is this KDbConnection::executeQuery() maybe?

On failure I recommend to use qDebug() << m_connection->result() so we know
what happens.
Similarly, KDbCursor also has result() method.

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-21 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

--- Comment #3 from Jarosław Staniek  ---
Simeon, you can also quickly email me zipped files, no problem.

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)

2016-10-20 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=371331

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDSINFO
 Resolution|--- |WAITINGFORINFO

--- Comment #1 from Jarosław Staniek  ---
Thanks Simeon. It would help if you link to your test app's code and place
where it fails. Having more public test apps is always a good idea.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 370090] Kexi crash when trying to add script in new project

2016-10-07 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=370090

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|WAITINGFORINFO  |UPSTREAM
 Status|NEEDSINFO   |RESOLVED

--- Comment #8 from Jarosław Staniek  ---
That experimental scripting is disabled in Kexi 3. I see possibility of adding
some extra checks to the GUI though, as it's probable that the same editor will
be used with the new scripting feature.

For 2.9 this bug can be closed as 2.9 would not receive this kind of fixes.
Doing that now.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 370090] Kexi crash when trying to add script in new project

2016-10-07 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=370090

--- Comment #7 from Jarosław Staniek  ---
> I read yesterday on Postgres wiki that Kexi can operate on existing DB.

Answered here https://forum.kde.org/viewtopic.php?f=221=136624

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 370090] Kexi crash when trying to add script in new project

2016-10-05 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=370090

--- Comment #4 from Jarosław Staniek  ---
By the way, if you're interesting in scripting, we're planning to have a
completely new Scripting module and the language will be Javascript;
functionally it would still use similar editor and approach.
The home page of Scripting development is
https://community.kde.org/Kexi/Plugins/Scripts.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 370090] Kexi crash when trying to add script in new project

2016-10-05 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=370090

--- Comment #3 from Jarosław Staniek  ---
> Unfortunately users of Arch Linux don't get pre-compiled packages with KDE 
> debug symbols.

Thanks. It would be good if the Arch maintainers know it's a misfeature/bug
that a kind of stays against our rules of development process and
contributions.

Yes, I do recommend compiling Kexi to get frequent updates. At least until
portable Kexi SNAP packages or alike are shipped. By the way, only Kexi 3 gets
updates now, so it makes more sense to compile Kexi 3 from kexi.git, not Kexi 2
from calligra.git.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 370090] Kexi crash when trying to add script in new project

2016-10-05 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=370090

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org
  Component|General |Scripting
 Status|UNCONFIRMED |NEEDSINFO
 Resolution|--- |WAITINGFORINFO

--- Comment #1 from Jarosław Staniek  ---
Hi, thanks for reporting, Wiktor.

I don't see a full backtrace (here's info how to get them:
https://userbase.kde.org/Asking_Questions#Reporting_KDE_Bugs), so these are
only guesses: you may miss a 3rd-party KTextEditor component that implements
text editor that we're using in the scripting window. The same component is
used in the SQL view of the Query Designer, it would be useful to hear from you
if it works for you or not. To test if you have the component, please try to
run Kate or KWrite app.

Of course Kexi should tell you about missing components instead of crashing,
I'll look at methods to do that.

(if this helps, please also note, scripting is experimental in Kexi 2 and also
2.9.11 is the last official release of Kexi 2)

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

Jarosław Staniek  changed:

   What|Removed |Added

 Status|CONFIRMED   |ASSIGNED
URL||https://phabricator.kde.org
   ||/T3901
   Assignee|kexi-b...@kde.org   |stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

--- Comment #4 from Jarosław Staniek  ---
Created attachment 101340
  --> https://bugs.kde.org/attachment.cgi?id=101340=edit
A form showing the format issues

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

--- Comment #3 from Jarosław Staniek  ---
Created attachment 101339
  --> https://bugs.kde.org/attachment.cgi?id=101339=edit
A table showing the format issues

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

--- Comment #2 from Jarosław Staniek  ---
Created attachment 101338
  --> https://bugs.kde.org/attachment.cgi?id=101338=edit
Test db file

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|--- |3.0
   Platform|Other   |Compiled Sources
 OS|Linux   |All
   Priority|NOR |HI

--- Comment #1 from Jarosław Staniek  ---
Similar topic: https://bugs.kde.org/show_bug.cgi?id=299865

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 299865] Dates not displayed correctly in forms text box

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=299865

Jarosław Staniek  changed:

   What|Removed |Added

Summary|dates not displayed |Dates not displayed
   |correctly in forms text box |correctly in forms text box

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369518] New: Input and display of Date/Time/Date Time values broken

2016-09-29 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369518

Bug ID: 369518
   Summary: Input and display of Date/Time/Date Time values broken
   Product: kexi
   Version: 3.0 Beta
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: major
  Priority: NOR
 Component: Tables
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

Input and display of Date/Time/Date Time values are broken in both forms and
tables.
This is a regression in Kexi 3.

Reproducible: Always

Steps to Reproduce:
1. Create table with Date/Time/Date Time types or use existing table having
these types
2. Try to display and enter values


Actual Results:  
No entry of value like 2016-09-29 or time possible. Instead of "-" only "_"
works.
Please see the screen shots attached for forms and tables, and the test
database file.

Expected Results:  
The functions should work like in Kexi 2.9.

This is possibly a defect in date/time formatters and validators, regression
related to porting to Qt 5.

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 369232] cmake fails on missing rcc, it's a runtime dep though

2016-09-24 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369232

--- Comment #3 from Jarosław Staniek  ---
"I cannot think of a single packaging environment where build environment ==
run environment."

This is stronger requirement Kexi does not have. No need to use this argument.

"The rcc being there at buildtime doesn't mean anything WRT runtime."

Yes but only in worst case, when the intent of person compiling is rather
wrong. Based on what I know packagers (with intent to ship properly) are rather
grateful for pointers they get from the configure time. And people that build
Kexi for the first time in order to start contributing. 
On top of that Kexi properly communicates what's required and recommended
dependency at configure time, that's the case since the older times of KOffice
and Calligra.

Thanks for double checking this.

Also I think we would change the subject "cmake fails on missing rcc" because
it's failure in doing something, not overlook, it's a programmed behaviour with
clear messages in English.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369230] kexi duplicates all breeze icons

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369230

--- Comment #5 from Jarosław Staniek  ---
"The Qt way is to ship the rcc with your app. Do that and I probably wouldn't
even care." 

I did in version 2.90 but in the meantime good thing happened, the rcc file is
generated by KF5 so  I don't need to.

Is shipping N copies of the rcc files with N variants of Kexi (or derivatives)
better in your opinion that declaring a runtime dependency to one, always the
same file?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369230] kexi duplicates all breeze icons

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369230

--- Comment #3 from Jarosław Staniek  ---
That's another discussion, I offered a space for contributions. The project
does not support theming in version 3.0.

The .rcc resources is official approach supported for Qt apps, truly cross
platform (eventually it works on Windows and Mac without "simulating" Linux
environment) and Kexi is more a Qt app since version 3 than it was before. We
have no KDE apps anymore as we say from time to time as well.

I also believe the summary of this report is a bit misleading because Kexi does
not duplicate anything, it uses official option for graphical resources. It
also adds very own files in its private resource file and uses that in an
official way via the icon loader.

"I do not see the link between only breeze being supported and the rcc file.
You can coerce a specific icon theme inside the application by telling
KIconLoader/QIcon which theme you want."

The rcc file allowed the control and it's a consistent approach to other
platforms so the effort is smaller. Also 3 kexi-derived libraries in separate
repos (kdb, kreport, kproperty) all use or will ultimately use the same approch
to avoid requiring 2*5100+ extra files at runtime by a 200KiB lib.

We need a linux-only patch and a whole testing effort before it's safe to
believe that things you mention work 100% works on Linux environments, not only
on Plasma 5. *Without* integration plugins. I think you agree that the
inconvenience you're reporting, while I see it as valid, is of lesser
importance than having actually running and usable app with icons as designed.

Thanks for understanding.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369230] kexi duplicates all breeze icons

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369230

Jarosław Staniek  changed:

   What|Removed |Added

Version|unspecified |3.0 Beta

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369232] cmake fails on missing rcc, it's a runtime dep though

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369232

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org

--- Comment #1 from Jarosław Staniek  ---
I understand the desire for purity. But we had to choose something closer to
good deployment practices and implemented without stressing the packagers
though so the packagers are able to deliver *working* packages. The problem is:
Kexi is being packaged without the .rcc file as a runtime dependency leads to
deployment failure. Then users are confused that Kexi refuses to start. 

It's hard to accept this approach in practice so I came up with the behaviour
as you explained. openSUSE package maintainer who collaborated with me on these
improvements was able to properly package the app and libs.

In the years of history it just happens that some packagers never actually run
the app, I don't even dream about them always running autotests (before
shipping). But in a pro world this is one of items on the check list.

If we have a way to ensure packager sets proper runtime dependencies, I'd
happily change the FATAL_ERROR to just a warning. For now warnings are pretty
much ignored by those deploying the software, and of course I am not surprised.

Requiring runtime dependencies at packaging time isn't something unusual if you
assume that before finalizing the process of building Kexi running autotests is
required (but still this cannot be forced because e.g. build systems lack
$DISPLAY). When tests are executed, the icons have to be accessible (and all
other runtime dependencies for that matter). This is why I am thinking there's
not much to fight for.

Those, in rare cases, who want to take responsibility of disabling the check
can patch the cmake script and then ensure ("by hand") that the runtime
requirements are in proper version. But let's realize that for example in the
KDb project in the future as we move on with features we would be checking
exact features of dependencies such as SQLite in exactly the same way: by
requiring the runtime deps at configure time. Some cmake's Find*.cmake actually
check the software by building and running apps at configure stage to really
know what features we have. So that's not a new thing.

Disclaimer: packagers are doing great work but just don't have the resources to
study internal of requirements in given software. App maintainer on the other
hand cannot accept software installation that are not working because of so
simple reason/mistake as described.

PS: it would be best if the check was exported as a cmake script in
breeze-icons.git.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369232] cmake fails on missing rcc, it's a runtime dep though

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369232

Jarosław Staniek  changed:

   What|Removed |Added

 OS|Linux   |All
Version|unspecified |3.0 Beta

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 369230] kexi duplicates all breeze icons

2016-09-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=369230

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org

--- Comment #1 from Jarosław Staniek  ---
Hello Harald,
The breeze-icons.rcc file comes from breeze-icons.git when
option(BINARY_ICONS_RESOURCE "Install a Qt binary resource file, containing
breeze icons") is ON.

It's officially supported. Intended approach for packagers shall be to package
the single file separately from the 3 times bigger archive with 5100 SVG files
and let app developers to choose.
(2 times more if also Dark variant is installed but that's another matter, Dark
variant should not exist if we eventually have colorizing).

Furthermore, another matter is what icon themes are supported by Kexi 3's
style. It's only Breeze for now, by design, on any OS. I am not hiding this
fact and am open for contributions of missing icons for other styles.

-- 
You are receiving this mail because:
You are watching all bug changes.

[www.kde.org] [Bug 368288] New: https://blogs.kde.org display images twice

2016-09-05 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=368288

Bug ID: 368288
   Summary: https://blogs.kde.org display images twice
   Product: www.kde.org
   Version: unspecified
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: normal
  Priority: NOR
 Component: general
  Assignee: kde-...@kde.org
  Reporter: stan...@kde.org

https://blogs.kde.org/2016/06/01/kexi-3. I know no way to overcome this.

Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[marble] [Bug 368219] Marble master f52af133e3f8 build error of shp2pn2_automoc.cpp (gcc 4.8)

2016-09-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=368219

--- Comment #2 from Jarosław Staniek  ---
BTW, Builds with gcc 4.9.2

-- 
You are receiving this mail because:
You are watching all bug changes.

[marble] [Bug 368219] Marble master f52af133e3f8 build error of shp2pn2_automoc.cpp (gcc 4.8)

2016-09-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=368219

Jarosław Staniek  changed:

   What|Removed |Added

Summary|Marble master f52af133e3f8  |Marble master f52af133e3f8
   |build error of  |build error of
   |shp2pn2_automoc.cpp |shp2pn2_automoc.cpp (gcc
   ||4.8)

-- 
You are receiving this mail because:
You are watching all bug changes.

[marble] [Bug 368219] Marble master f52af133e3f8 build error of shp2pn2_automoc.cpp

2016-09-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=368219

Jarosław Staniek  changed:

   What|Removed |Added

   Platform|Other   |openSUSE RPMs

--- Comment #1 from Jarosław Staniek  ---
(opensuse 13.2)

-- 
You are receiving this mail because:
You are watching all bug changes.

[marble] [Bug 368219] New: Marble master f52af133e3f8 build error of shp2pn2_automoc.cpp

2016-09-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=368219

Bug ID: 368219
   Summary: Marble master f52af133e3f8 build error of
shp2pn2_automoc.cpp
   Product: marble
   Version: unspecified
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: crash
  Priority: NOR
 Component: general
  Assignee: marble-b...@kde.org
  Reporter: stan...@kde.org

Hello,
I'm getting marble master f52af133e3f8 build error of shp2pn2_automoc.cpp as
below.
gcc version 4.8.3 20140627

[ 92%] Building CXX object
tools/shp2pn2/CMakeFiles/shp2pn2.dir/shp2pn2_automoc.cpp.o
In file included from /usr/include/c++/4.8/algorithm:62:0,
 from /usr/include/qt5/QtCore/qglobal.h:88,
 from /usr/include/qt5/QtCore/qalgorithms.h:37,
 from /usr/include/qt5/QtCore/qvector.h:37,
 from /usr/include/qt5/QtCore/QVector:1,
 from
/home/jarek/dev/src/marble/src/lib/marble/geodata/data/GeoDataLineString.h:16,
 from
/home/jarek/dev/src/marble/src/lib/marble/geodata/data/GeoDataLinearRing.h:17,
 from
/home/jarek/dev/src/marble/tools/osm-simplify/BaseClipper.h:16,
 from
/home/jarek/dev/src/marble/tools/osm-simplify/BaseClipper.cpp:13:
/usr/include/c++/4.8/bits/stl_algo.h: In instantiation of
‘_RandomAccessIterator std::__unguarded_partition(_RandomAccessIterator,
_RandomAccessIterator, const _Tp&, _Compare) [with _RandomAccessIterator =
QList::iterator; _Tp =
QSharedPointer; _Compare =
Marble::BaseClipper::clipPolyObject(const QPolygonF&, QVector&,
bool)::__lambda1]’:
/usr/include/c++/4.8/bits/stl_algo.h:2296:78:   required from
‘_RandomAccessIterator std::__unguarded_partition_pivot(_RandomAccessIterator,
_RandomAccessIterator, _Compare) [with _RandomAccessIterator =
QList::iterator; _Compare =
Marble::BaseClipper::clipPolyObject(const QPolygonF&, QVector&,
bool)::__lambda1]’
/usr/include/c++/4.8/bits/stl_algo.h:2337:62:   required from ‘void
std::__introsort_loop(_RandomAccessIterator, _RandomAccessIterator, _Size,
_Compare) [with _RandomAccessIterator =
QList::iterator; _Size = int; _Compare =
Marble::BaseClipper::clipPolyObject(const QPolygonF&, QVector&,
bool)::__lambda1]’
/usr/include/c++/4.8/bits/stl_algo.h:5490:44:   required from ‘void
std::sort(_RAIter, _RAIter, _Compare) [with _RAIter =
QList::iterator; _Compare =
Marble::BaseClipper::clipPolyObject(const QPolygonF&, QVector&,
bool)::__lambda1]’
/home/jarek/dev/src/marble/tools/osm-simplify/BaseClipper.cpp:454:14:  
required from here
/usr/include/c++/4.8/bits/stl_algo.h:2263:35: error: no match for call to
‘(Marble::BaseClipper::clipPolyObject(const QPolygonF&, QVector&,
bool)::__lambda1) (QSharedPointer&, const
QSharedPointer&)’
while (__comp(*__first, __pivot))
   ^
/home/jarek/dev/src/marble/tools/osm-simplify/BaseClipper.cpp:452:74: note:
candidates are:
 std::sort(intersectionsTop.begin(), intersectionsTop.end(),
[](QSharedPointer& A, QSharedPointer& B) {


Reproducible: Always

Steps to Reproduce:
Make libshp1 available, configure, build.

Actual Results:  
Build break

Expected Results:  
Builds, installs

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 366037] Data source indicator missing for labels

2016-07-24 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=366037

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |CONFIRMED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 366037] Data source indicator missing for labels

2016-07-24 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=366037

--- Comment #1 from Jarosław Staniek  ---
Created attachment 100270
  --> https://bugs.kde.org/attachment.cgi?id=100270=edit
Label has no indicator

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 366037] New: Data source indicator missing for labels

2016-07-24 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=366037

Bug ID: 366037
   Summary: Data source indicator missing for labels
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: normal
  Priority: NOR
 Component: Forms
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

On the attached screen shot both widgets (label and text box) have data source
assigned but the label lacks the [>] icon indicator. 

Reproducible: Always


Actual Results:  
The label also needs the indicator so user can see labels that are bound to
data source. Also the label text should be changed to data source name.


Based on this thread
https://forum.kde.org/viewtopic.php?f=221=135004=361296#p361296

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 365878] When define search column this is not saved

2016-07-20 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365878

--- Comment #2 from Jarosław Staniek  ---
For the record, to use C locale jsut for Kexi on linux/unix you use this
command:

LANG=C kexi

Or better "export LANG=C" in your local environment where you build and run
Kexi.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365878] When define search column this is not saved

2016-07-20 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365878

--- Comment #1 from Jarosław Staniek  ---
There's no "search column" , I guess you mean this pane:

http://wstaw.org/m/2016/07/20/plasma-desktopEP2868.png

I recommend changing locale to C or en_US while testing Kexi and communicating
messages. Also when posting screenshots. We're often looking for mentioned
strings in the source code and if you don't 100% accurately translate the
string, it's not convenient.

I guess you mean bound column or visible column?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365878] When define search column this is not saved

2016-07-20 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365878

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org
  Component|General |Tables

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365874] Crash in table view displaying images - KexiUtils::loadPixmapFromData()

2016-07-20 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365874

Jarosław Staniek  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

--- Comment #4 from Jarosław Staniek  ---
Thanks Juan.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365874] Crash in table view displaying images - KexiUtils::loadPixmapFromData()

2016-07-19 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365874

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |CONFIRMED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365874] Crash in table view displaying images - KexiUtils::loadPixmapFromData()

2016-07-19 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365874

Jarosław Staniek  changed:

   What|Removed |Added

Summary|Error creating foreing key  |Crash in table view
   ||displaying images -
   ||KexiUtils::loadPixmapFromDa
   ||ta()

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365874] Error creating foreing key

2016-07-19 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365874

--- Comment #1 from Jarosław Staniek  ---
Thanks. I've got this last evening and tried to fix with commit
48ae7f140e576e9d2. Do you have this one? This is related to displaying Object
(image / BLOB) objects in data view, probably not to creating relations.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365874] Error creating foreing key

2016-07-19 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365874

Jarosław Staniek  changed:

   What|Removed |Added

Version|unspecified |3.0 Alpha
 CC||stan...@kde.org
   Target Milestone|--- |3.0
  Component|General |Tables

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 159170] Show the relational model of the global database

2016-07-19 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=159170

Jarosław Staniek  changed:

   What|Removed |Added

Summary|Show the relational model   |Show the relational model
   |of  the global database.|of  the global database
 CC||stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kde-windows] [Bug 318650] Unknown CMake command "check_function_exists"

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=318650

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|FIXED   |INVALID

-- 
You are receiving this mail because:
You are watching all bug changes.

[kde-windows] [Bug 318650] Unknown CMake command "check_function_exists"

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=318650

Jarosław Staniek  changed:

   What|Removed |Added

   Assignee|kde-wind...@kde.org |stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kde-windows] [Bug 318650] Unknown CMake command "check_function_exists"

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=318650

Jarosław Staniek  changed:

   What|Removed |Added

   Platform|MS Windows  |Compiled Sources
 OS|MS Windows  |All

-- 
You are receiving this mail because:
You are watching all bug changes.

[kde-windows] [Bug 318650] Unknown CMake command "check_function_exists"

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=318650

--- Comment #3 from Jarosław Staniek  ---
@Juan 
Assuming you have executed:

cd $HOME/kde/src
git clone kde:kexi

and based on https://community.kde.org/Calligra/Building/3#Build_Calligra, you
need:

cd $HOME/kde/build/kexi

cmake -DCMAKE_INSTALL_PREFIX=$HOME/kde/inst5 $HOME/kde/src/kexi
-DCMAKE_BUILD_TYPE=RelWithDebInfo

Of course this won't end with success if you miss dependencies, and I guess you
do so far :)

-- 
You are receiving this mail because:
You are watching all bug changes.

[kde-windows] [Bug 318650] Unknown CMake command "check_function_exists"

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=318650

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org
 Resolution|--- |FIXED
 Status|UNCONFIRMED |RESOLVED

--- Comment #2 from Jarosław Staniek  ---
@Juan

What is the  $HOME/kexi/src/ dir?

I guess you're not pointing to the root dir of kexi.git's sources but to
kexi.git/src/. This will never work.

I see you might understood  '/src'  subdir of kexi as the source dir but it's
not. Source code also exists in the / dir of the git tree.


The same answer goes the original author, Chris:  kioslave/fish is a subdir,
don't build subdirs :)

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Jarosław Staniek  changed:

   What|Removed |Added

 Status|CLOSED  |RESOLVED
  Latest Commit|http://commits.kde.org/kdb/ |http://commits.kde.org/kdb/
   |75d1b25be0ec92bfee6693fad15 |f4371019f27be94a28390ffb2b9
   |3d4eb6fa525d9   |ef4f0199f1abe

--- Comment #6 from Jarosław Staniek  ---
Git commit f4371019f27be94a28390ffb2b9ef4f0199f1abe by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:17.
Pushed by staniek into branch 'master'.

KDbSQL: Handle escape sequences in string literals

Handle escape sequences in string literals: \" \' \n \r \0 etc.

Also:
- \xhh -> character
- \u -> 16-bit unicode character
- \u{xx} -> 24-bit unicode "code point" character, known from JavaScript
(ECMAScript 6)
- Add autotests

M  +165  -0autotests/KDbTest.cpp
M  +4-0autotests/KDbTest.h
M  +203  -1src/KDb.cpp
M  +65   -3src/KDb.h
M  +15   -4src/parser/KDbSqlScanner.l

http://commits.kde.org/kdb/f4371019f27be94a28390ffb2b9ef4f0199f1abe

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

--- Comment #4 from Jarosław Staniek  ---
Git commit c7111e0cf2335ac24bccd249284cfd1116bf2a1b by Jaroslaw Staniek.
Committed on 18/07/2016 at 07:57.
Pushed by staniek into branch 'master'.

KDbConnection::lastInsertedAutoIncValue: escape  and  in "SELECT
. FROM "

>From calligra.git 69b8f18d4b1102fe

M  +3-2src/KDbConnection.cpp

http://commits.kde.org/kdb/c7111e0cf2335ac24bccd249284cfd1116bf2a1b

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-07-18 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

--- Comment #5 from Jarosław Staniek  ---
Git commit af59e5798139cb917371fa3394146d395a067ea4 by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:17.
Pushed by staniek into branch 'master'.

GIT_SILENT Update generated scanner code

M  +240  -224  src/parser/generated/sqlscanner.cpp

http://commits.kde.org/kdb/af59e5798139cb917371fa3394146d395a067ea4

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|--- |3.0
   Version Fixed In||3.0.0
 Status|RESOLVED|CLOSED

--- Comment #8 from Jarosław Staniek  ---
Fixed in Kexi 3.0

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

Jarosław Staniek  changed:

   What|Removed |Added

   Assignee|kexi-b...@kde.org   |stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |FIXED
 Status|CONFIRMED   |RESOLVED
  Latest Commit||http://commits.kde.org/kdb/
   ||4eca476f22dd1c5a1046daffc3b
   ||51de0c00590c2

--- Comment #7 from Jarosław Staniek  ---
Git commit 4eca476f22dd1c5a1046daffc3b51de0c00590c2 by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:17.
Pushed by staniek into branch 'master'.

Don't support "unsigned" property for fields that are not of integer types

M  +3-0src/KDbField.cpp
M  +2-1src/KDbNativeStatementBuilder.cpp

http://commits.kde.org/kdb/4eca476f22dd1c5a1046daffc3b51de0c00590c2

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

--- Comment #5 from Jarosław Staniek  ---
Git commit 0486e8c17877ce1f964a086c8f71dc4210877217 by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:14.
Pushed by staniek into branch 'master'.

Hide "unsigned" property for fields in Table Designer for non-integer types

Not much sense for FP types

M  +1-1src/plugins/tables/kexitabledesignerview_p.cpp

http://commits.kde.org/kexi/0486e8c17877ce1f964a086c8f71dc4210877217

--- Comment #6 from Jarosław Staniek  ---
Git commit 4ffa6af5e60263b09087303008777b325d9bc99c by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:14.
Pushed by staniek into branch 'master'.

Table Designer: don't set unsigned/maxLength/precision/scale for incompatible
field types

M  +7-3src/plugins/tables/kexitabledesignerview.cpp

http://commits.kde.org/kexi/4ffa6af5e60263b09087303008777b325d9bc99c

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

--- Comment #5 from Jarosław Staniek  ---
Git commit 0486e8c17877ce1f964a086c8f71dc4210877217 by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:14.
Pushed by staniek into branch 'master'.

Hide "unsigned" property for fields in Table Designer for non-integer types

Not much sense for FP types

M  +1-1src/plugins/tables/kexitabledesignerview_p.cpp

http://commits.kde.org/kexi/0486e8c17877ce1f964a086c8f71dc4210877217

--- Comment #6 from Jarosław Staniek  ---
Git commit 4ffa6af5e60263b09087303008777b325d9bc99c by Jaroslaw Staniek.
Committed on 14/07/2016 at 22:14.
Pushed by staniek into branch 'master'.

Table Designer: don't set unsigned/maxLength/precision/scale for incompatible
field types

M  +7-3src/plugins/tables/kexitabledesignerview.cpp

http://commits.kde.org/kexi/4ffa6af5e60263b09087303008777b325d9bc99c

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365469] Error while creating table with field type that does not support UNSIGNED but has it set to TRUE

2016-07-14 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365469

--- Comment #4 from Jarosław Staniek  ---
On Thursday, 14 July 2016, Juan José Morales via KDE Bugzilla <
bugzilla_nore...@kde.org> wrote:
> Comment # 3 on bug 365469 from Juan José Morales
>
> Thank you for your response.
> Im trying to involve in the project. I hope i can help improving the
product.
> For now Im learning Qt for help solving bugs and reporting bugs i found.
>

Thanks Juan, that's good news! Have you tried to compile Kexi 3?
Regardless of programming skills bug and wish reporting is welcome. We are
also planning to have distribution-independent Kexi releases.

Cheers.

> Greetings
>
> 
> You are receiving this mail because:
>
> You are on the CC list for the bug.
> You are watching someone on the CC list of the bug.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 365160] Add multi-cell selection like in spreadsheets

2016-07-06 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=365160

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
   Severity|normal  |wishlist
Version|unspecified |3.0 Beta
  Component|Usability   |Tables
 CC||stan...@kde.org
Summary|Can't select and copy   |Add multi-cell selection
   |several records or several  |like in spreadsheets
   |cells from table? Is there  |
   |any way to do it using  |
   |shift , control or any  |
   |other keys? Is there any|
   |ability to use filters in   |
   |columns as in ms access?|
 Status|UNCONFIRMED |CONFIRMED

--- Comment #1 from Jarosław Staniek  ---
Thanks for the report, Petr.

There is no support for multi-selection in Tabular View indeed. Changing the
summary to this topic as the feature would enable copying as you explained.

It would be a spreadsheet-like multi-cell selection, so this would work:
- selecting with  Control 
- selecting with Shift
- selecting entire column(s)
- selecting entire record(s)
- selecting entire data
- inverting the current selection
- editing/searching/clipboard actions would work for the current selection
- (I bet more is possible, a study based on spreadsheets and MSA/Filemaker is
welcome!)

Regarding filters, a wish is filed at
https://bugs.kde.org/show_bug.cgi?id=277573, so removing this part from this
summary.

Please let me know if we can add more wishes or correct something.

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-07-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Jarosław Staniek  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-07-02 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

--- Comment #3 from Jarosław Staniek  ---
Git commit 729e2937e426bb9b715f0152aed66b5b11d2676a by Jaroslaw Staniek.
Committed on 03/07/2016 at 00:12.
Pushed by staniek into branch 'escape-sequences-staniek'.

KDbConnection::lastInsertedAutoIncValue: escape  and  in "SELECT
. FROM "

>From calligra.git 69b8f18d4b1102fe

M  +3-2src/KDbConnection.cpp

http://commits.kde.org/kdb/729e2937e426bb9b715f0152aed66b5b11d2676a

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-07-01 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |FIXED
  Latest Commit||http://commits.kde.org/kdb/
   ||75d1b25be0ec92bfee6693fad15
   ||3d4eb6fa525d9
 Status|ASSIGNED|RESOLVED

--- Comment #3 from Jarosław Staniek  ---
Git commit 75d1b25be0ec92bfee6693fad153d4eb6fa525d9 by Jaroslaw Staniek.
Committed on 01/07/2016 at 09:12.
Pushed by staniek into branch 'escape-sequences-staniek'.

KDbSQL: Handle escape sequences in string literals

Handle escape sequences in string literals: \" \' \n \r \0 etc.

Also:
- \xhh -> character
- \u -> 16-bit unicode character
- \u{xx} -> 24-bit unicode "code point" character, known from JavaScript
(ECMAScript 6)
- Add autotests

M  +165  -0autotests/KDbTest.cpp
M  +4-0autotests/KDbTest.h
M  +203  -1src/KDb.cpp
M  +65   -3src/KDb.h
M  +15   -4src/parser/KDbSqlScanner.l

http://commits.kde.org/kdb/75d1b25be0ec92bfee6693fad153d4eb6fa525d9

--- Comment #4 from Jarosław Staniek  ---
Git commit 172580d30f59f8a14fa9837dab567a257ad2a94f by Jaroslaw Staniek.
Committed on 01/07/2016 at 09:13.
Pushed by staniek into branch 'escape-sequences-staniek'.

GIT_SILENT Update generated scanner code

M  +240  -224  src/parser/generated/sqlscanner.cpp

http://commits.kde.org/kdb/172580d30f59f8a14fa9837dab567a257ad2a94f

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-07-01 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |FIXED
  Latest Commit||http://commits.kde.org/kdb/
   ||75d1b25be0ec92bfee6693fad15
   ||3d4eb6fa525d9
 Status|ASSIGNED|RESOLVED

--- Comment #3 from Jarosław Staniek  ---
Git commit 75d1b25be0ec92bfee6693fad153d4eb6fa525d9 by Jaroslaw Staniek.
Committed on 01/07/2016 at 09:12.
Pushed by staniek into branch 'escape-sequences-staniek'.

KDbSQL: Handle escape sequences in string literals

Handle escape sequences in string literals: \" \' \n \r \0 etc.

Also:
- \xhh -> character
- \u -> 16-bit unicode character
- \u{xx} -> 24-bit unicode "code point" character, known from JavaScript
(ECMAScript 6)
- Add autotests

M  +165  -0autotests/KDbTest.cpp
M  +4-0autotests/KDbTest.h
M  +203  -1src/KDb.cpp
M  +65   -3src/KDb.h
M  +15   -4src/parser/KDbSqlScanner.l

http://commits.kde.org/kdb/75d1b25be0ec92bfee6693fad153d4eb6fa525d9

--- Comment #4 from Jarosław Staniek  ---
Git commit 172580d30f59f8a14fa9837dab567a257ad2a94f by Jaroslaw Staniek.
Committed on 01/07/2016 at 09:13.
Pushed by staniek into branch 'escape-sequences-staniek'.

GIT_SILENT Update generated scanner code

M  +240  -224  src/parser/generated/sqlscanner.cpp

http://commits.kde.org/kdb/172580d30f59f8a14fa9837dab567a257ad2a94f

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364969] New: Add support for patching/merging of SQLite databases

2016-07-01 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364969

Bug ID: 364969
   Summary: Add support for patching/merging of SQLite databases
   Product: KDb
   Version: unspecified
  Platform: Other
OS: All
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: General
  Assignee: stan...@kde.org
  Reporter: stan...@kde.org

SQLite 3.13.0 introduced a Session Extension feature:
http://www.sqlite.org/sessionintro.html

"Suppose SQLite is used as the the application file format for a particular
design application. Two users, Alice and Bob, each start with a baseline design
that is about a gigabyte in size. They work all day, in parallel, each making
their own customizations and tweaks to the design. At the end of the day, they
would like to merge their changes together into a single unified design. "

Support for it could be reflected in KDb. The would be probably
SQLite-driver-only feature at least initially.

Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-06-30 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

--- Comment #2 from Jarosław Staniek  ---
(In reply to Jarosław Staniek from comment #1)
> Example: "SELECT \x49\x20\u2665\x20\x53\x51\x4c" returns "I ♥ SQL" :)

Should be: SELECT "\x49\x20\u2665\x20\x53\x51\x4c"

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] SQL: Handle escape sequences in string literals

2016-06-30 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |CONFIRMED

--- Comment #1 from Jarosław Staniek  ---
Example: "SELECT \x49\x20\u2665\x20\x53\x51\x4c" returns "I ♥ SQL" :)

-- 
You are receiving this mail because:
You are watching all bug changes.

[KDb] [Bug 364950] New: SQL: Handle escape sequences in string literals

2016-06-30 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364950

Bug ID: 364950
   Summary: SQL: Handle escape sequences in string literals
   Product: KDb
   Version: 3.0
  Platform: Other
OS: All
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: General
  Assignee: stan...@kde.org
  Reporter: stan...@kde.org

Handle escape sequences in string literals: \" \' \n \r \0 etc.

Also:
- \xhh -> character
- \u -> 16-bit unicode character
- \u{xx} -> 24-bit unicode "code point"  character, known from JavaScript
(ECMAScript 6)

Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Jarosław Staniek  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |FIXED
  Latest Commit||http://commits.kde.org/call
   ||igra/69b8f18d4b1102fed1d06d
   ||e07f6d1c953e00e617
 Status|ASSIGNED|RESOLVED

--- Comment #2 from Jarosław Staniek  ---
Git commit 69b8f18d4b1102fed1d06de07f6d1c953e00e617 by Jaroslaw Staniek.
Committed on 27/06/2016 at 12:20.
Pushed by staniek into branch 'calligra/2.9'.

CalligraDB: Connection::lastInsertedAutoIncValue: escape  and  in
"SELECT . FROM "

M  +2-1libs/db/connection.cpp

http://commits.kde.org/calligra/69b8f18d4b1102fed1d06de07f6d1c953e00e617

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364811] Error opening table with missing visible column of lookup filed

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364811

--- Comment #1 from Jarosław Staniek  ---
Created attachment 99723
  --> https://bugs.kde.org/attachment.cgi?id=99723=edit
A file that fails

table.b is misconfigured (no visible column set) and causes the error

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364811] Error opening table with missing visible column of lookup filed

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364811

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |ASSIGNED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364811] New: Error opening table with missing visible column of lookup filed

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364811

Bug ID: 364811
   Summary: Error opening table with missing visible column of
lookup filed
   Product: kexi
   Version: 2.9.11
  Platform: Other
   URL: https://forum.kde.org/viewtopic.php?f=221=133426
OS: Linux
Status: UNCONFIRMED
  Severity: normal
  Priority: NOR
 Component: KexiDB
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

Error opening table with missing visible column of lookup filed.

Reproducible: Always

Steps to Reproduce:
1. Create table that misses at least visible column in its lookup field but has
bound column set
2. Go to the data view

Actual Results:  
"Switching to other view failed (Data View). Unspecified error encountered. SQL
statement: SELECT o_id, o_type, o_name, o_caption, o_desc FROM kexi__objects
WHERE o_name='' AND o_type=1 LIMIT 1"

Expected result: the table should be open, the misconfigured lookup should just
fail to work, but there should be no fatal error. When bound column is missing
things work exactly this way.

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

--- Comment #1 from Jarosław Staniek  ---
Created attachment 99722
  --> https://bugs.kde.org/attachment.cgi?id=99722=edit
Test file that fails

Try to insert records into "table" and "index" tables.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Jarosław Staniek  changed:

   What|Removed |Added

   Target Milestone|--- |2.9.12

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |ASSIGNED
URL||https://forum.kde.org/viewt
   ||opic.php?f=221=133426
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Jarosław Staniek  changed:

   What|Removed |Added

   Assignee|kexi-b...@kde.org   |stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 364810] New: Error while inserting rows into table with schema containing reserved words

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=364810

Bug ID: 364810
   Summary: Error while inserting rows into table with schema
containing reserved words
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: normal
  Priority: NOR
 Component: KexiDB
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

Error while inserting rows into table with schema containing reserved words,
e.g. table name == "table" or field name "from". 

Solution: escape identifiers in any place where necessary. 


Reproducible: Always

Steps to Reproduce:
1. Create table such as "CREATE TABLE "TABLE" ("FROM" INTEGER)
2. Go to the data view and try to insert one record


Actual Results:  
"Record inserting failed"



In fact records get inserted but retrieving autoincremented values fails.

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 363068] Data type "time" is not available in forms and reports

2016-06-27 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=363068

Jarosław Staniek  changed:

   What|Removed |Added

Summary|Data-typ "time" is not  |Data type "time" is not
   |evailable in form and   |available in forms and
   |report  |reports
 CC||stan...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 362731] Add support for akonadi addressbooks

2016-05-06 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=362731

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1
 CC||stan...@kde.org

--- Comment #1 from Jarosław Staniek  ---
Definitely, it will be valuable. CRM is also a good topic for example database
we would ship with Kexi.

Thanks

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 327993] Records in reports not sorted according to the sorting of the query

2016-04-11 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=327993

--- Comment #5 from Jarosław Staniek  ---
This may be related to a different issue. Do you have the same name used for
the query and table? If so perhaps renaming the query (and reassigning it to
the report) helps?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361363] Add support for pagination mode for table view

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361363

--- Comment #2 from Jarosław Staniek  ---
Other benefit: a way to discrete jump between "pages", like "Record 1-10",
"Record 11-20".

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361363] Add support for pagination mode for table view

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361363

--- Comment #1 from Jarosław Staniek  ---
Created attachment 98225
  --> https://bugs.kde.org/attachment.cgi?id=98225=edit
A (web) table view example with pagination

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361363] Add support for pagination mode for table view

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361363

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361363] New: Add support for pagination mode for table view

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361363

Bug ID: 361363
   Summary: Add support for pagination mode for table view
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: Tables
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

By default the table view is scrolled and loads all available data (for now,
this can be optimized later).
Pagination option is known from web UIs, see the attachment. Differences:
- no need for vertical scrollbar
- data loading limited to only one "page" -> speed and smaller memory
consumption
- would be used for mobile/embedded mode by default

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 361362] Add support for reordering rows in table view's spreadsheet mode

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361362

--- Comment #2 from Jarosław Staniek  ---
First use cases for this feature would be: table and query designers.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361362] Add support for reordering rows in table view's spreadsheet mode

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361362

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |CONFIRMED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361362] Add support for reordering rows in table view's spreadsheet mode

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361362

--- Comment #1 from Jarosław Staniek  ---
Created attachment 98224
  --> https://bugs.kde.org/attachment.cgi?id=98224=edit
Reordering rows

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 361362] New: Add support for reordering rows in table view's spreadsheet mode

2016-04-03 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361362

Bug ID: 361362
   Summary: Add support for reordering rows in table view's
spreadsheet mode
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: Tables
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

Add support for reordering rows in table view's spreadsheet mode. Possible
solution: a "drag" column as presented in the screenshot and at
http://okfnlabs.org/recline/demos/multiview/


Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 361114] Map-window with OSM - scroll-wheel changes coordinates

2016-03-28 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=361114

Jarosław Staniek  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 CC||stan...@kde.org
 Ever confirmed|0   |1

--- Comment #1 from Jarosław Staniek  ---
Thanks Albrecht. Confirmed by comparing to the Marble app itself. When I
mouse-scroll (vertical wheel) using in Marble the white cross (as in
https://marble.kde.org/img/gallery/marble-desktop-satellite-clouds.png) changes
position while scrolling and goes back to the center point afterwards. In forms
it stays in a new position so on data editing starts and saving the changes
saves the new coordinates. Is that what you found too?

A side note is also that zooming (changing altitude) in form maps  starts
editing. This is the case because altitude is part of the data. Maybe we don't
want to have that always and in some cases we want to lock altitude and only
allow to change coordinates.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360906] Linking a form to a query shows in all records th same pictures

2016-03-23 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360906

Jarosław Staniek  changed:

   What|Removed |Added

 CC||stan...@kde.org
   Target Milestone|--- |2.9.12
 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

--- Comment #1 from Jarosław Staniek  ---
Thanks a lot Albrecht. Confirmed.

For the record: query data view and reports don't have this problem, only forms
have.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360311] Missing tool tip when placing mouse over the table cell

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360311

Jarosław Staniek  changed:

   What|Removed |Added

   See Also||https://bugs.kde.org/show_b
   ||ug.cgi?id=360312

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360067] Vertical alignment in a field shows opposed properties

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360067

Jarosław Staniek  changed:

   What|Removed |Added

 Status|RESOLVED|CLOSED

--- Comment #14 from Jarosław Staniek  ---
Added related wishes:
https://bugs.kde.org/show_bug.cgi?id=360311
https://bugs.kde.org/show_bug.cgi?id=360312

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360312] Missing tool tip when placing mouse over a form data widget

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360312

Jarosław Staniek  changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |CONFIRMED

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360312] Missing tool tip when placing mouse over a form data widget

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360312

Jarosław Staniek  changed:

   What|Removed |Added

   See Also||https://bugs.kde.org/show_b
   ||ug.cgi?id=360311

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360312] New: Missing tool tip when placing mouse over a form data widget

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360312

Bug ID: 360312
   Summary: Missing tool tip when placing mouse over a form data
widget
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: Forms
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

We don't display tool tips when moving mouse over contents of a form data
widget (in data view) when it cannot fit (vertically or horizontally).

Like https://bugs.kde.org/show_bug.cgi?id=360311


Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 360311] New: Missing tool tip when placing mouse over the table cell

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360311

Bug ID: 360311
   Summary: Missing tool tip when placing mouse over the table
cell
   Product: kexi
   Version: 2.9.11
  Platform: Other
OS: Linux
Status: UNCONFIRMED
  Severity: wishlist
  Priority: NOR
 Component: Tables
  Assignee: kexi-b...@kde.org
  Reporter: stan...@kde.org
CC: a...@piggz.co.uk, in...@fables.co.za

We don't display tool tips when moving mouse over contents of a cell then it
cannot fit in the cell (vertically or horizontally). This is a thing to add.
(We had this in Kexi 1.x)


Reproducible: Always

-- 
You are receiving this mail because:
You are watching all bug changes.


[kexi] [Bug 360067] Vertical alignment in a field shows opposed properties

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360067

Jarosław Staniek  changed:

   What|Removed |Added

 Resolution|--- |INVALID
 Status|UNCONFIRMED |RESOLVED

--- Comment #13 from Jarosław Staniek  ---
It seems you ha​d no way to know the text is multi-line.

I think we don't display tool tips when moving mouse over the text then it
cannot fit in the cell (vertically or horizontally). This is a thing to add.
(We had this in Kexi 1.x)

Setting this bug as Invalid then.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kexi] [Bug 360067] Vertical alignment in a field shows opposed properties

2016-03-09 Thread Jarosław Staniek via KDE Bugzilla
https://bugs.kde.org/show_bug.cgi?id=360067

--- Comment #12 from Jarosław Staniek  ---
Created attachment 97791
  --> https://bugs.kde.org/attachment.cgi?id=97791=edit
Screenshot fro msqliteman

OK, not a bug but annoyance. Look e.g. using the sqliteman program: the value
contains new-line at the end.

-- 
You are receiving this mail because:
You are watching all bug changes.

  1   2   3   4   >