[dba-issues] [Issue 116509] first records ignored with a certain connection types

2011-02-03 Thread fdany
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116509





--- Additional comments from fd...@openoffice.org Fri Feb  4 07:30:53 + 
2011 ---
But type differencies are the same in OO 4.2.1

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116509] first records ignored with a certain connection types

2011-02-03 Thread fdany
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116509





--- Additional comments from fd...@openoffice.org Fri Feb  4 07:22:26 + 
2011 ---
ID types

ADO   ODBC
texte [nchar] texte [varchar]
texte (fixe) [text]   texte (fixe) [char] 
SQL Null []   Memo [Text]
Date/Heure [DateTime] Date/Heure [SmallDateTime]

The values with ODBC are the right ones.
With ODBC, the types as defined in SQLServer are mentionned. With ADO, it's not
the case

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116795] build broken in ConnectivityComplexTests

2011-02-03 Thread andyrtr
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116795
 Issue #|116795
 Summary|build broken in ConnectivityComplexTests
   Component|Database access
 Version|DEV300m99
Platform|Opteron/x86_64
 URL|
  OS/Version|Linux
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P3
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|andyrtr





--- Additional comments from andy...@openoffice.org Fri Feb  4 06:38:21 
+ 2011 ---
Build breaks here in m99:

Making:ConnectivityComplexTests.dpj
rm -f ../../../unxlngx6.pro/misc/ConnectivityTools_dummy.java
../../unxlngx6.pro/misc/stripped_sqlbison.y: conflicts: 20 shift/reduce, 17
reduce/reduce
...
...
Making:conn_shared_res.srs
: &&
LD_LIBRARY_PATH=/build/src/DEV300_m99/solver/300/unxlngx6.pro/lib${LD_LIBRARY_PATH:+:${LD_LIBRARY_PATH}}
 /build/src/DEV300_m99/solver/300/unxlngx6.pro/bin/rsc -presponse -verbose
@/tmp/mkXEAARq
Making:salapp.lib
Compiling: vcl/source/window/introwin.cxx
complex/connectivity/HsqlDriverTest.java:38: package org.hsqldb.lib does not 
exist
...
...
mkdir -p  ../../unxlngx6.pro/misc/connectivity
: &&
LD_LIBRARY_PATH=/build/src/DEV300_m99/solver/300/unxlngx6.pro/lib${LD_LIBRARY_PATH:+:${LD_LIBRARY_PATH}}
/build/src/DEV300_m99/solver/300/unxlngx6.pro/bin/transex3 -p connectivity -i
conn_log_res.src -o ../../unxlngx6.pro/misc/cnr/conn_log_res.src.unxlngx6.pro -m
/build/src/DEV300_m99/l10n/unxlngx6.pro/misc/sdf/connectivity/source/resource/localize.sdf
-l all
complex/connectivity/HsqlDriverTest.java:114: cannot find symbol
symbol  : class StopWatch
location: class complex.connectivity.HsqlDriverTest
StopWatch sw   = new StopWatch();  
^
complex/connectivity/HsqlDriverTest.java:114: cannot find symbol
symbol  : class StopWatch
...
dmake:  Error code 1, while making
'../unxlngx6.pro/misc/ConnectivityComplexTests_dummy.java'

build options:
checking which hsqldb to use... external
checking for /usr/share/java/hsqldb.jar... yes
checking whether hsqldb is 1.8.0.x... yes

package versions:
hsqldb-java 1.8.0.10-1
gcc 4.5.2-6
openjdk6 6.b20_1.9.5-1

Any idea?

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116695] [Regression] MozAB query: operator LIKE broken

2011-02-03 Thread fuege
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116695


User fuege changed the following:

What|Old value |New value

  Status|RESOLVED  |VERIFIED





--- Additional comments from fu...@openoffice.org Fri Feb  4 03:13:28 + 
2011 ---
Exchanging the MozAB libraries

mozabdrvmi.dll
mozabmi.dll

in my OOo 3.3.0 installation with those of the DEV300m99, it works (again).

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116509] first records ignored with a certain connection types

2011-02-03 Thread r4zoli
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116509


User r4zoli changed the following:

What|Old value |New value

 Summary|first result ignored with |first records ignored with
|a certain form of outer jo| a certain connection type
|in in a request   |s





--- Additional comments from r4z...@openoffice.org Thu Feb  3 15:18:16 
+ 2011 ---
Changed summary.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116509] first result ignored with a certain form of outer join in a request

2011-02-03 Thread r4zoli
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116509


User r4zoli changed the following:

What|Old value |New value

 Assigned to|dbaneedsconfirm   |oj

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from r4z...@openoffice.org Thu Feb  3 15:17:09 
+ 2011 ---
I confirm it I found similar or same problem with different MS drivers to MS
accees files fails with ADO, and mdb driwer works with ODBC.

I investigated with other MS connected product and find that the mdb driver for
msaccess nwind.mdb example file has a same problem, with first records.

Download Northwind example file, unpack it:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C6661372-8DBE-422B-8676-C632D66C529C&displaylang=EN

Create connection to this nwind.mdb file through New>database>connect to
existing database>Microsoft Access, open Product table -> Missing record to
ProductID=1. The mdb driver recognize ProductID as  Integer[long]and shows as 
PK.
Same with ADO/JET connection.
Create ODBC connection to same nwind.mdb file, Shows all records. The ODBC
driver recognize ProductID as  Integer[Counter] and not PK.

This happens with latest DEV300m99 version, too. I found it when checked issue
115384, on win7. (where I copied table with two records, shows only one in mdb
connected file).

@fdany in your tables which ID types shows in OOo table edit mode with different
drivers.

 

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116572] calc listbox entries are lost on open *.ods file

2011-02-03 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116572





--- Additional comments from f...@openoffice.org Thu Feb  3 13:59:57 + 
2011 ---
note: reading the cell binding broke between m96 and m97.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 76572] using calc cells as data source for listbox - ignore empty cells ...

2011-02-03 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76572





--- Additional comments from f...@openoffice.org Thu Feb  3 13:48:53 + 
2011 ---
for the record: This issue was never explicitly fixed, at least not to my 
knowledge.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 66846] Out of memory when opening large tables

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66846


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |FIXED





--- Additional comments from o...@openoffice.org Thu Feb  3 13:39:25 + 
2011 ---
Fixed in cws dba34d.

I tried it with a 1 mio rows csv file which now takes only 1-2 sec on my machine
to open.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116543] MySQL native driver 1.0.1 version not working with 3.2.1 and older versions of OOo

2011-02-03 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116543





--- Additional comments from f...@openoffice.org Thu Feb  3 13:01:17 + 
2011 ---
In fact, 1.0.1 seems to have been linked against a cppuhelper library versioned
with UDK_3.6, where the one in OOo 3.2.1 has version UDK_3.5 only.

Not sure what to do best here: We need a extension version which has a
"min-version"-dependency of OOo 3.3. However, naming this extension version
1.0.1 too would not be good - it would cause confusion. Naming it with any other
name would also be bad, as it wouldn't solve the problem for those upgrading
from 1.0.0 to 1.0.1.

Need to discuss this ...

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 116695] [Regression] MozAB query: operator LIKE broken

2011-02-03 Thread fs
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116695


User fs changed the following:

What|Old value |New value

  Status|UNCONFIRMED   |RESOLVED

  Resolution|  |FIXED





--- Additional comments from f...@openoffice.org Thu Feb  3 12:41:18 + 
2011 ---
can reproduce in OOo 3.3 and DEV300.m98. Cannot reproduce in DEV300.m99, where
CWS dba34b has been integrated. Assuming fixed.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 102719] Chart in report can have negativ Y-position

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102719


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |FIXED





--- Additional comments from o...@openoffice.org Thu Feb  3 10:59:10 + 
2011 ---
Fixed in cws dba34d

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 107096] In a macro, SQL order "Shutdown compact" fails

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=107096


User oj changed the following:

What|Old value |New value

Priority|P3|P5





--- Additional comments from o...@openoffice.org Thu Feb  3 09:48:45 + 
2011 ---
Change prio.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 113251] Must be able to use Run SQL Command Directly in all views

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113251


User oj changed the following:

What|Old value |New value

Priority|P3|P5





--- Additional comments from o...@openoffice.org Thu Feb  3 09:29:29 + 
2011 ---
Change prio.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 109269] [HSQLdb] Modulo Function Only Returns an Integer

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109269


User oj changed the following:

What|Old value |New value

  Status|RESOLVED  |CLOSED





--- Additional comments from o...@openoffice.org Thu Feb  3 09:17:14 + 
2011 ---
closing it.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org



[dba-issues] [Issue 109269] [HSQLdb] Modulo Function Only Returns an Integer

2011-02-03 Thread oj
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109269


User oj changed the following:

What|Old value |New value

  Status|NEW   |RESOLVED

  Resolution|  |INVALID





--- Additional comments from o...@openoffice.org Thu Feb  3 09:16:47 + 
2011 ---
That's what the SQL standard says:

 operates on two exact numeric arguments with scale 0 (zero)
and returns the modulus
(remainder) of the first argument divided by the second argument as an exact
numeric with scale 0 (zero).

So the other dbs don't follow the standard.

PS: HSQLDB 2.0 returns also 16

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org