https://bugs.freedesktop.org/show_bug.cgi?id=65619
Priority: medium
Bug ID: 65619
Assignee: [email protected]
Summary: segfault in "Create Query in SQL View...", sqlnode.cxx
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.1.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Created attachment 80645
--> https://bugs.freedesktop.org/attachment.cgi?id=80645&action=edit
.csv of Bugzilla query, Product = "LibreOffice", and Keyword = "regression" or
Whiteboard contains the string bibisect. 1641 data rows.
To reproduce ...
( 1) Download attached .csv file to a convenient location.
( 2) Run LibreOffice with a command something like
soffice --norestore --base
Program presents Database Wizard step 1 "Select database".
( 3) Click "Connect to an existing database" and in the dropdown list
click on Spreadsheet.
( 4) Click <Next>. Program displays Database Wizard step 2 "Set up
Spreadsheet connection".
( 5) Click <Browse>. Program displays Open diaplog.
( 6) Navigate to the file you downloaded and click <Open>. Program
returns focus to Database Wizard step 2 with "Location and file
name" filled in.
( 7) Click <Next>. Program displays Database Wizard step 3 "Save and
proceed".
( 8) Select "No, do not register the database" and "Open the database
for editing" and click <Finish>. Program displays Save dialog
with field Name selected.
( 9) Type /tmp/thing1 and click <Save>. Program displays window
thing1.odb; the left pane has <Tables> selected and the lower
right pane shows Sheet1.
(10) In the left pane, click <Queries>. Program displays options in
the Tasks pane at the upper right.
(11) In the Tasks pane, click "Create Query in SQL View...". Program
displays window "thing1.odb: Query 1".
(12) In the entry area, type
select count( * )
from Sheet1
where Keywords like 'regression' and
Status = 'UNCONFIRMED'
and type <F5>.
Program action expected: I was guessing at the syntax for the
select statement, so I would have been happy with either a number
or a report of a syntax error.
Program action actual: segmentation fault
For comparison, I have seen the crash in 4.1.0.0.beta2 but 3.6.4.3
displays a number. The same SQL query crashes master when the backend
is an .ods file.
My LibreOffice in the soon-to-be-attached typescript is master 45abf35
pulled 2013-05-29 configured with
--enable-option-checking
--enable-dbgutil
--enable-crashdump
--disable-build-mozilla
--without-system-postgresql
--without-myspell-dicts
--without-help
--with-extra-buildid
built and executing on ubuntu-natty 32-bit (11.04)
$ uname -a
Linux cougar-natty 2.6.38-16-generic #67-Ubuntu SMP Thu Sep 6 18:00:43 UTC
2012 i686 athlon i386 GNU/Linux
$ gcc --version
gcc (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
$ java -version
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.5)
(6b24-1.11.5-0ubuntu1~11.04.1)
OpenJDK Client VM (build 20.0-b12, mixed mode, sharing)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
