Issue 100012

Summary: TOOLS/SQL crash OOo when insert (")or(') as first letter in row
Product: Base Reporter: ud <ulger>
Component: codeAssignee: marc.neumann
Status: CLOSED FIXED QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P2 CC: issues, max.odendahl
Version: OOO310m4Keywords: regression
Target Milestone: OOo 3.1   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 95768    

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.