Bug 94750 - EDITING Creating boolean field : always give NULL default value even if FALSE is asked
Summary: EDITING Creating boolean field : always give NULL default value even if FALSE...
Status: RESOLVED DUPLICATE of bug 45606
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-04 09:07 UTC by moebius20
Modified: 2015-10-06 13:33 UTC (History)
1 user (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 moebius20 2015-10-04 09:07:01 UTC 
When creating a boolean field in a table, LO offers option for default value of the field : YES, NO or <nothing> (in french : OUI, NON, <aucun> ).

But selecting YES, NO or selecting <nothing> produces always <nothing> ; it's not possible to obtain NO or YES for default value.
Comment 1 Alex Thurgood 2015-10-06 11:38:18 UTC 
@moebius20 :
- which database engine ?
- which version of LibreOffice ? (distrib provided or TDF download) ?
- depending on db backend - how are you accessing the db ? (driver type and version)
Comment 2 Alex Thurgood 2015-10-06 11:41:16 UTC 
Seems like a duplicate of either bug 45606 or bug 56612
Comment 3 moebius20 2015-10-06 11:53:31 UTC 
(In reply to Alex Thurgood from comment #1)
> @moebius20 :
> - which database engine ?
> - which version of LibreOffice ? (distrib provided or TDF download) ?
> - depending on db backend - how are you accessing the db ? (driver type and
> version)

I use the default integrated database engine of LO, don't know the name.
LO is 5.02 got directly from libreoffice.org.
Db backend ? I don't know how to obtain this information.

In LO-BASE, after opening the database I use, in Edit/Databases menu, the properties and connexion types options are greyed.
Comment 4 Alex Thurgood 2015-10-06 13:33:14 UTC 
(In reply to moebius20 from comment #3)


> 
> I use the default integrated database engine of LO, don't know the name.
> LO is 5.02 got directly from libreoffice.org.
> Db backend ? I don't know how to obtain this information.
> 

Thanks, you are using embedded HSQLDB, the default db engine.

*** This bug has been marked as a duplicate of bug 45606 ***