BiTel

Server version: 5.5.25a-27.1 Percona Server (GPL), Release rel27.1, Revision 277
mysql  Ver 14.14 Distrib 5.5.25a, for Linux (x86_64) using readline 5.1

 Last_Error: Error 'BIGINT UNSIGNED value is out of range in '(`bgbilling`.`contract_balance`.`mm` - 1)'' on query. Default database: 'bgbilling'. Query: 'CREATE TEMPORARY TABLE _validator_balance_dump( UNIQUE(cid) ) SELECT cid, MAX(yy*12+(mm-1))%12 + 1 AS mm,FLOOR(MAX(yy*12+(mm-1)) / 12) AS yy FROM contract_balance WHERE (yy*12 + mm)<(2012*12 + 10) GROUP BY cid'

mysql> SELECT 9223372036854775807 + 1;
+-------------------------+
| 9223372036854775807 + 1 |
+-------------------------+
|    -9223372036854775808 |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT 9223372036854775807 + 1;
ERROR 1690 (22003): BIGINT value is out of range in '(9223372036854775807 + 1)'
mysql>

mysql> SELECT id FROM contract ORDER BY id LIMIT 3;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
+----+
3 rows in set (0.00 sec)

mysql> SELECT * FROM contract_balance ORDER BY cid LIMIT 3;
+------+----+-----+---------+--------+--------+--------+
| yy   | mm | cid | summa1  | summa2 | summa3 | summa4 |
+------+----+-----+---------+--------+--------+--------+
| 2012 |  4 |   1 |    0.00 |   0.00 |   0.00 |   0.00 |
| 2008 |  9 |   2 |    0.00 |   0.00 | 441.70 |   0.00 |
| 2008 | 10 |   2 | -441.70 |   0.00 | 341.52 |   0.00 |
+------+----+-----+---------+--------+--------+--------+
3 rows in set (0.02 sec)