https://bugs.documentfoundation.org/show_bug.cgi?id=148266
Bug ID: 148266
Summary: Firebird, entering several SQL commands directly
together
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
In HSQLDB I could enter several commands directly in Tools > SQL:
ALTER TABLE "Adresse" ADD "Vorname" VARCHAR(25) BEFORE "Name"
ALTER TABLE "Adresse" ADD "email" VARCHAR(50) BEFORE "Name"
All were executed together at once.
In Firebird only one command can be entered and executed.
Several commands:
ALTER TABLE table_name ALTER field_name POSITION 1
ALTER TABLE table_name ALTER field_name2 POSITION 2
ALTER TABLE table_name ALTER field_name3 POSITION 3
or
ALTER TABLE table_name ALTER field_name POSITION 1;
ALTER TABLE table_name ALTER field_name2 POSITION 2;
ALTER TABLE table_name ALTER field_name3 POSITION 3
or
ALTER TABLE table_name ALTER field_name POSITION 1,
ALTER TABLE table_name ALTER field_name2 POSITION 2,
ALTER TABLE table_name ALTER field_name3 POSITION 3
result in this error message:
*Token unknown - line 2, column 1
*ALTER
caused by
'isc_dsql_prepare'
It is time consuming to enter each command separately.
Steps to Reproduce:
1. enter in Tools > SQL:
ALTER TABLE table_name ALTER field_name POSITION 1
ALTER TABLE table_name ALTER field_name2 POSITION 2
ALTER TABLE table_name ALTER field_name3 POSITION 3
or
ALTER TABLE table_name ALTER field_name POSITION 1;
ALTER TABLE table_name ALTER field_name2 POSITION 2;
ALTER TABLE table_name ALTER field_name3 POSITION 3
or
ALTER TABLE table_name ALTER field_name POSITION 1,
ALTER TABLE table_name ALTER field_name2 POSITION 2,
ALTER TABLE table_name ALTER field_name3 POSITION 3
Actual Results:
error message:
*Token unknown - line 2, column 1
*ALTER
caused by
'isc_dsql_prepare'
Expected Results:
1:
Reproducible: Always
User Profile Reset: Yes
Additional Info:
no other info
--
You are receiving this mail because:
You are the assignee for the bug.
