Bug 155908 - SQL window does not receive text field content from Writer
Summary: SQL window does not receive text field content from Writer
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency tree / graph
 
Reported: 2023-06-18 10:08 UTC by Andreas Säger
Modified: 2024-12-23 07:37 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Säger 2023-06-18 10:08:49 UTC 
Description:
When you copy SQL with text fields (variables, placeholders) from Writer into Base's SQL window (Tools>SQL...), the fields are left out.
When you paste the same clipboard content into a text editor, the full SQL statement is pasted, regardless if the text fields are displayed as names or content.

Steps to Reproduce:
1. Download https://forum.openoffice.org/en/forum/download/file.php?id=47267
2. Copy the frame content as is.
3. Get some HSQL database, call Tools>SQL and paste

Actual Results:
CREATE TABLE "" ("" VARCHAR(32) NOT NUll ...

Expected Results:
CREATE TABLE "TBL_A" ("Name" VARCHAR(32) NOT NUll ...


Reproducible: Always


User Profile Reset: No

Additional Info:
Works with AOO4
Comment 1 m_a_riosv 2023-06-18 23:47:08 UTC 
Reproducible
Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 069c7dc4e9706b40ca12d83d83f90f41cec948f8
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Comment 2 Robert Großkopf 2023-06-19 06:53:01 UTC 
Tested with older versions. It's the same buggy behavior in every version I could test here. Have set it to LO 6.4.7.2, because I have reproduced it there also.