[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Robert Großkopf  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||3769

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

--- Comment #8 from Terrence Enger  ---
FWIW, I see the bug is fixed in daily Linux dbgutil bibisect
repository version 2018-01-04.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Julien Nabet  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||t...@iki.fi
 Resolution|--- |FIXED

--- Comment #7 from Julien Nabet  ---
Fixed with
https://cgit.freedesktop.org/libreoffice/core/commit/?id=ee29c944868a578b002103bb58595029bf385473

I think it could be useful to cherry-pick this patch on 6.0 branch. If everyone
is ok, I may do it.
Any opinion?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Terrence Enger  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||lo_b...@iseries-guru.com
 Ever confirmed|0   |1

--- Comment #6 from Terrence Enger  ---
I see the error in daily dbgutil bibisect repository version
2017-02-05 running on debain-stretch.  Setting bug status NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

--- Comment #5 from Alex Thurgood  ---
No repro with

Version: 5.4.0.0.alpha0+
Build ID: 8b93a951214b64fb166e14477f370657ebf67c0d
CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group

which is a few days older than the one you tested, I think.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Julien Nabet  changed:

   What|Removed |Added

 CC||btom...@gmail.com,
   ||lio...@mamane.lu

--- Comment #4 from Julien Nabet  ---
Tamas/Lionel: thought you might be interested in this one.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

--- Comment #3 from Julien Nabet  ---
If I click Finish just after having selected Notes field, SQL contains 65000
If I click Next and see details of Notes field length 32765, SQL contains 32765
Anyway, both cases fail, impossible to create a table with 32765 length.
Idem when trying SQL command directly (so not related to wizard except
65000/32765 pb):
CREATE TABLE "Tasks" ("ID" INTEGER NOT NULL,"Notes" VARCHAR(32765), PRIMARY KEY
 ("ID"))

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Julien Nabet  changed:

   What|Removed |Added

   Keywords||haveBacktrace

--- Comment #2 from Julien Nabet  ---
Putting a break shows a value to 65000 ! (not 32765)

#0  connectivity::firebird::StatusVectorToString (rStatusVector=...,
rCause="isc_dsql_prepare") at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Util.cxx:52
#1  0x2aaafac11631 in connectivity::firebird::evaluateStatusVector
(rStatusVector=..., rCause="isc_dsql_prepare", _rxContext=
uno::Reference to (connectivity::firebird::OStatement *) 0x5b171560) at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Util.cxx:62
#2  0x2aaafac08b9f in
connectivity::firebird::OStatementCommonBase::prepareAndDescribeStatement
(this=this@entry=0x5b171560, 
sql="CREATE TABLE \"Tasks\" (\"ID\" INTEGER NOT NULL,\"Notes\"
VARCHAR(65000), PRIMARY KEY  (\"ID\"))", pOutSqlda=@0x5b171700:
0x5b25d970, 
pInSqlda=pInSqlda@entry=0x0) at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/StatementCommonBase.cxx:165
#3  0x2aaafac07807 in connectivity::firebird::OStatement::executeQuery
(this=0x5b171560, 
sql="CREATE TABLE \"Tasks\" (\"ID\" INTEGER NOT NULL,\"Notes\"
VARCHAR(65000), PRIMARY KEY  (\"ID\"))")
at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Statement.cxx:115
#4  0x2aaafac07564 in connectivity::firebird::OStatement::execute
(this=, sql=...)
at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Statement.cxx:150
#5  0x2aaafac0f69f in connectivity::firebird::Tables::appendObject
(this=0x5b97f480, rName="Tasks", rDescriptor=...)
at
/home/julien/lo/libreoffice/connectivity/source/drivers/firebird/Tables.cxx:170
#6  0x2aaabc7e6976 in connectivity::sdbcx::OCollection::appendByDescriptor
(this=0x5b97f480, 
descriptor=uno::Reference to (dbaccess::ODBTableDecorator *)
0x577f44d0) at
/home/julien/lo/libreoffice/connectivity/source/sdbcx/VCollection.cxx:367
#7  0x2aaaf99cb00a in dbaccess::OTableContainer::appendObject
(this=0x5789e4f0, _rForName="Tasks", 
descriptor=uno::Reference to (dbaccess::ODBTableDecorator *)
0x577f44d0) at
/home/julien/lo/libreoffice/dbaccess/source/core/api/tablecontainer.cxx:282
#8  0x2aaabc7e6976 in connectivity::sdbcx::OCollection::appendByDescriptor
(this=0x5789e4f0, 
descriptor=uno::Reference to (dbaccess::ODBTableDecorator *)
0x577f44d0) at
/home/julien/lo/libreoffice/connectivity/source/sdbcx/VCollection.cxx:367

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 105604] Firebird error when creating a table containing a VARCHAR with by default value 32765

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=105604

Julien Nabet  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org//show_bug.cgi?id=7
   ||1251

--- Comment #1 from Julien Nabet  ---
tdf#71251 had been fixed by putting max value from 32767 to 32765. I tested
again and now the max length value is 8191 for a varchar

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs