| *** perftuning has joined #ingres | 01:30 | |
| *** rossand has quit IRC | 01:54 | |
| *** toumi01 has quit IRC | 02:07 | |
| *** rossand has joined #ingres | 02:12 | |
| *** ChanServ sets mode: +o rossand | 02:12 | |
| *** rossand has quit IRC | 02:38 | |
| *** grantc_offline has quit IRC | 07:05 | |
| *** grantc_offline has joined #ingres | 07:06 | |
| *** irc.freenode.net sets mode: +o grantc_offline | 07:06 | |
| *** Alex|off is now known as Alex| | 07:06 | |
| *** grantc_offline is now known as grantc | 08:05 | |
| pboro | is there a way to disable referential checks during a session? | 08:14 |
|---|---|---|
| Alex| | isn't that done with norules? | 08:15 |
| pboro | ah, thanks! :) | 08:15 |
| *** withdefault has joined #ingres | 08:27 | |
| *** ChanServ sets mode: +o withdefault | 08:27 | |
| *** Gerhard has joined #ingres | 09:12 | |
| *** troal01 has joined #ingres | 12:16 | |
| troal01 | Hey has anyone used the offsetof macro in C? | 12:16 |
| *** [1]Gerhard has joined #ingres | 13:23 | |
| *** rossand has joined #ingres | 13:39 | |
| *** ChanServ sets mode: +o rossand | 13:39 | |
| *** Gerhard has quit IRC | 13:40 | |
| *** [1]Gerhard is now known as Gerhard | 13:40 | |
| *** DarylM has joined #ingres | 13:54 | |
| *** elPiola has joined #ingres | 14:15 | |
| *** [1]Gerhard has joined #ingres | 14:22 | |
| *** Gerhard has quit IRC | 14:25 | |
| *** [1]Gerhard is now known as Gerhard | 14:25 | |
| *** toumi01 has joined #ingres | 14:59 | |
| *** Gerhard has quit IRC | 14:59 | |
| troal01 | Hrm select count(*) from tab returned a negative integer | 15:16 |
| pboro | nice :D | 15:16 |
| DarylM | Just a wild guess on my part, but that seems like a problem. | 15:16 |
| Alex| | so you owe it some data... | 15:16 |
| troal01 | LOL | 15:16 |
| troal01 | This table has more rows than an i4 can handle | 15:17 |
| troal01 | could that be the problem? | 15:17 |
| SlimeyPete | if you're selecting it into an i4 | 15:17 |
| SlimeyPete | I'd've thought count() would return a long by default... | 15:18 |
| SlimeyPete | 've never tested this hypothesis though ;) | 15:18 |
| DarylM | >2 billion rows? I'm impressed. | 15:18 |
| grantc | SlimeyPete, long = i4 | 15:18 |
| grantc | depending on the arch | 15:18 |
| troal01 | Heh | 15:18 |
| grantc | aggregates should return an i8 | 15:19 |
| SlimeyPete | oh right. | 15:19 |
| SlimeyPete | for some reason I thought a long was an i8. | 15:19 |
| troal01 | yeah I was using a sequence to assign id, but it ran out of numbers so I made it an 8 byte integer sequence | 15:19 |
| troal01 | Okay so if it isn't overflowing, and it took a bloody long time to do a count(*) what else could it be then? | 15:19 |
| DarylM | A bug? | 15:20 |
| DarylM | lol | 15:20 |
| grantc | long long int is 64 bit | 15:20 |
| grantc | unless you are on a 64 bit machine in which case sizeof(long) could be 8 | 15:21 |
| troal01 | size_t is also 8 bytes on 64 bit machines, but 4 on 32 bit | 15:21 |
| troal01 | I figured that out after segfaulting a few times on my 64 bit machine :P | 15:22 |
| grantc | :) | 15:22 |
| *** Alex| is now known as Alex|off | 16:14 | |
| *** rossand1 has joined #ingres | 16:47 | |
| *** rossand has quit IRC | 16:51 | |
| *** Alex|off is now known as Alex| | 17:20 | |
| *** DerMeister has joined #ingres | 17:36 | |
| *** grantc is now known as grantc_offline | 17:59 | |
| *** Alex| is now known as Alex|off | 18:40 | |
| *** rossand1 is now known as rossand | 20:39 | |
| *** DerMeister has quit IRC | 22:09 | |
| *** withdefault has left #ingres | 22:38 | |
| *** DarylM has quit IRC | 22:48 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!