Issue 100012 - TOOLS/SQL crash OOo when insert (")or(') as first letter in row
Summary: TOOLS/SQL crash OOo when insert (")or(') as first letter in row
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO310m4
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: OOo 3.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks: 95768
  Show dependency tree
 
Reported: 2009-03-07 21:22 UTC by ud
Modified: 2009-04-01 04:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description ud 2009-03-07 21:22:27 UTC
Tested with OOODEV310_m4 on Windows XP and HSQLDB

If i change the SQL Statement and set (") or (') as the first letter
in a row Openoffice OOODEV310_m4 crashes almost every time.

-open a new database
-open Tools/SQL
-copy the following SQL statemnet in the "Command to execute Box"
 like it is

CREATE TABLE kunden
(
id INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(50),
vorname VARCHAR(50)
);

-change id in "id when you set the courser in front of id
 and insert "id"
=> In 99% the crash manager will come after insert the first (")

-set the courser in front of id and use backwards Key to have a
 statement like this

CREATE TABLE kunden
(id INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(50),
vorname VARCHAR(50)
);
-if you now insert "id" it works so long as i try to do the same
 with name. "name will crash OOo again.

In 3.0.1 it works allways well.
Comment 1 ud 2009-03-07 21:30:06 UTC
Forgot the OS
Comment 2 Frank Schönheit 2009-03-09 13:23:25 UTC
confirming, grabbing, nominating as 3.1 blocker, adding regression keyword
Comment 3 Frank Schönheit 2009-03-09 13:35:39 UTC
fixed in CWS dba31j

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31j
Comment 4 max.odendahl 2009-03-10 00:13:26 UTC
mod->fs: thanks!
Comment 5 Frank Schönheit 2009-03-11 20:20:08 UTC
fs->msc: please verify in CWS dba31j
Comment 6 marc.neumann 2009-03-17 10:43:16 UTC
verified in cws dba31j on windows
Comment 7 vladimir_hitekschool 2009-03-31 08:47:22 UTC
Issue 100012 has been fixed in master version OOo-dev 3.1 .0 (OOO310m7 Build:9393) 
for Windows XP and can be closed.
Comment 8 oleghitekschool 2009-04-01 04:53:11 UTC
Checked by HitekSchool Group 1 interns within Bug Hunting Party. Fixed.