Re: "sum" in MySQL querry
Tom Schindl <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Although I have no idea of OO-Internals it's maybe bug in the MySQL-JDBC-Driver which has some bugs in 3.1.10 when it comes to encoding, collation, ... as well as MySQL 4.1 where some bugs are targeted to 5.1. Some encoding bugs/problems are fixed in the latest dev-snapshot http://downloads.mysql.com/snapshots.php#connector-j Tom Juraj Trenkler schrieb: > OOo121, MySQL 5.0.6-beta-standard, jdbc driver. > > I tried to run some of my older querries in my database but I got problem with > "sum" function which worked previously. > > With sql querry > "select rok, sum(etnikum=3) from hlasenie group by rok" > I got error: > Unknown type 246 in column 1 of 2 in binary-encoded result set. > > juraj > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFC6J7SkVPeOFLgZFIRAmG+AJ4yV+rsW6IS56aJnjW5lP26GSJb1wCgkB4s RxhVi/T+RHmj2l7q7cI62ZA= =DhHH -----END PGP SIGNATURE-----