Download it now!
Bug 121209 - TABLEWIZARD: Field type isn't correctly recognized for Integer and Boolean using automatic field type recognition
Summary: TABLEWIZARD: Field type isn't correctly recognized for Integer and Boolean us...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
 
Reported: 2018-11-06 15:00 UTC by Robert Großkopf
Modified: 2019-12-06 18:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screenshots shows wrong typedetection of Integer (49.06 KB, image/png)
2018-11-06 15:00 UTC, Robert Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2018-11-06 15:00:33 UTC
Created attachment 146361 [details]
Screenshots shows wrong typedetection of Integer

See bug 121208 for starting the tablewizard in Base. The table you are copying should have a field with Integer-values and also a field with Boolean-values.

In step "Type formatting" press "Auto". Most fields will be recognized right in "Field type", but Integer-fields and Boolean-fields (1|0] are always set wrong to "Double".

Tested this with LO 6.1.3.2 64bit rpm Linux.
Comment 1 Alex Thurgood 2018-11-06 18:28:06 UTC
Confirming for integer values with

Version: 6.1.2.1
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
Threads CPU : 8; OS : Mac OS X 10.14; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded

The boolean recognition very much depends on the values you use for the boolean state in your Calc sheet.

When I tried Y/N, the auto recognition suggested Text(VARCAHR).

Which values were you using for boolean in your Calc sheet ?
Comment 2 Robert Großkopf 2018-11-06 18:40:33 UTC
(In reply to Alex Thurgood from comment #1)
> 
> When I tried Y/N, the auto recognition suggested Text(VARCAHR).

Right. It is the same as I tried, also with "false" and "true"
> 
> Which values were you using for boolean in your Calc sheet ?

I tried with '1' and '0' instead and this leads to "Double".
Comment 3 Alex Thurgood 2018-11-07 12:31:51 UTC
Confirming also for boolean values, either Y/N or 1/0.
Comment 4 Alex Thurgood 2018-11-07 12:32:33 UTC
Seems to me that this bug is actually quite old...would need to test with earlier versions.
Comment 5 Julien Nabet 2018-11-10 20:59:53 UTC
No idea where the type is automatically guessed, uncc myself.
Comment 6 QA Administrators 2019-12-06 04:18:26 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2019-12-06 18:23:40 UTC
Bug is the same in LO 6.3.3.2 on OpenSUSE 15.1 64bit rpm Linux