Auto-increment field data can be changed

Bug #318341 reported by kentmcmartin on 2009-01-18
4
Affects Status Importance Assigned to Milestone
OpenOffice
Confirmed
Unknown
libreoffice (Ubuntu)
Undecided
Unassigned
openoffice.org (Ubuntu)
Low
Unassigned

Bug Description

Binary package hint: openoffice.org-base

ubuntu 8.04
1:2.4.1-ubuntu2.1
openoffice 2.4.1
oobase
opened a table and designated ID as a primary integer autoincremented field
Did not expect to be able to edit the value
Went in to edit the table and the ID field while listed as an integer indicates an integer length of 0 instead of the original 10.

rebooted etc., no change
deleted table and tried again, same issue.

ProblemType: Bug
Architecture: i386
Date: Sat Jan 17 18:21:35 2009
DistroRelease: Ubuntu 8.04
Package: openoffice.org-core 1:2.4.1-1ubuntu2.1
PackageArchitecture: i386
ProcEnviron:
 PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.24-19-generic i686

kentmcmartin (kent-mtaonline) wrote :
Chris Cheney (ccheney) on 2009-01-18
Changed in openoffice.org:
importance: Undecided → Medium
status: New → Triaged
Changed in openoffice:
status: Unknown → Confirmed
Chris Cheney (ccheney) on 2010-05-13
tags: added: hardy

kentmcmartin, could you please attach a Base file that demonstrates this problem? Does LibreOffice Base work for you?

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy libreoffice-base
libreoffice-base:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

Changed in libreoffice (Ubuntu):
status: New → Incomplete
summary: - autoincrement field data can be changed
+ [Upstream] auto-increment field data can be changed

I switched to Access database so don't know if the problem still occurs.

On Sat, 2011-06-04 at 14:08 +0000, Christopher M. Penalver wrote:
> kentmcmartin, could you please attach a Base file that demonstrates this
> problem? Does LibreOffice Base work for you?
>
> lsb_release -rd
> Description: Ubuntu 11.04
> Release: 11.04
>
> apt-cache policy libreoffice-base
> libreoffice-base:
> Installed: 1:3.3.2-1ubuntu5
> Candidate: 1:3.3.2-1ubuntu5
> Version table:
> *** 1:3.3.2-1ubuntu5 0
> 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
> 100 /var/lib/dpkg/status
> 1:3.3.2-1ubuntu4 0
> 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
>
> ** Also affects: libreoffice (Ubuntu)
> Importance: Undecided
> Status: New
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

Changed in libreoffice (Ubuntu):
status: Incomplete → New
Changed in libreoffice (Ubuntu):
status: New → Incomplete
Changed in openoffice.org (Ubuntu):
importance: Medium → Low
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

summary: - [Upstream] auto-increment field data can be changed
+ Auto-increment field data can be changed
Bryan Quigley (bryanquigley) wrote :

Thank you for reporting this bug to Ubuntu. This Ubuntu release has reached EOL for Desktops.
See this document for currently supported Ubuntu releases: https://wiki.ubuntu.com/Releases

Since this bug hasn't been touched in a while and the Incomplete autoclose didn't work, I'm going to close it.

If you can still reproduce on a new version of Ubuntu, please reopen it.

Changed in libreoffice (Ubuntu):
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.