| *** grantc has joined #ingres | 00:58 | |
| *** ChanServ sets mode: +o grantc | 00:58 | |
| *** grantc has quit IRC | 00:59 | |
| *** withdefault has joined #ingres | 03:29 | |
| *** ChanServ sets mode: +o withdefault | 03:29 | |
| *** thiagomz has joined #ingres | 04:06 | |
| *** thiagomz has quit IRC | 04:23 | |
| *** DarylM has joined #ingres | 05:39 | |
| *** atrofast has joined #ingres | 05:42 | |
| *** rossand has joined #ingres | 05:55 | |
| *** ChanServ sets mode: +o rossand | 05:55 | |
| *** toumi01 has joined #ingres | 06:34 | |
| *** mull has joined #ingres | 06:39 | |
| *** Alex| is now known as Alex|off | 06:54 | |
| atrofast | Any OME gurus here? :) | 08:27 |
|---|---|---|
| DarylM | .me cowers at the thought of learning anything at all about OME | 08:28 |
| atrofast | It's that bad eh? | 08:29 |
| DarylM | Mostly because I fear ad-hoc custom modifications to the core iidbms | 08:30 |
| atrofast | Any idea if it's possisble to create an SQL function in OME with a variable number of parameters? | 08:31 |
| *** grantc has joined #ingres | 08:35 | |
| *** ChanServ sets mode: +o grantc | 08:35 | |
| grantc | morning/afternoon peeps | 08:35 |
| atrofast | Hey grantc | 08:44 |
| grantc | how's it going atrofast | 08:44 |
| grantc | ? | 08:44 |
| atrofast | Okay, I ran into an issue with Drupal and the search module | 08:44 |
| atrofast | It uses an SQL function called GREATEST | 08:45 |
| atrofast | Takes a list of numbers, returns the largest | 08:45 |
| atrofast | Ingres doesn't have that as far as I know | 08:45 |
| DarylM | as in "select max(value) from list | 08:46 |
| grantc | yeah what DarylM says :) | 08:46 |
| atrofast | max only takes one value | 08:47 |
| atrofast | Here's the offending line: GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) | 08:48 |
| grantc | i guess you could re-write that as a subselect | 08:50 |
| atrofast | I could... That would be the fourth regex in there to work around Ingres issues heh | 08:50 |
| grantc | btw alison has submitted an IP for the update problem | 08:50 |
| grantc | are you documenting these issues? | 08:51 |
| atrofast | They're documented in the code | 08:51 |
| grantc | it would be *nice* for there to be another record.. of these problems otherwise the next "port" will have to discover them all over | 08:52 |
| atrofast | Where would be a good place to put them? Drupal/Ingres wiki? | 08:52 |
| atrofast | grantc: Did you figure out why the CVS head version of the PHP driver is causing issues during the install? | 08:56 |
| grantc | where to document the problems - the drupal wiki page would be a good start - from there I can pass the info on to teresa... | 08:57 |
| grantc | the problem with CVS head is down to the update problem | 08:58 |
| grantc | i.e. update of a page spanning row | 08:58 |
| grantc | not much i can do about that ... it's possible it was working before due to a bug in the driver | 08:59 |
| atrofast | Heh a bug that made it work? :) | 08:59 |
| atrofast | CVS ingres.c 1.24 + the most recent patch you sent me doesn't give me any issues, as long as I don't use LOBs | 09:00 |
| atrofast | CVS ingres.c 1.25, update fails during install | 09:01 |
| grantc | yup a bug that made it work - if you enable 64k pages and set max_tuple_length to 0 it will install | 09:32 |
| grantc | so i was told ... i have not done it but the underlying problem is the update of page spanning rows... I guess how the query gets sent matters ... | 09:35 |
| *** rossand has quit IRC | 09:37 | |
| atrofast | Okay I tried that, enabled 64k pages, set max_tuple_length to 0, restarted Ingres... It still doesn't work | 09:44 |
| *** Alex|off is now known as Alex| | 10:27 | |
| *** grantc has quit IRC | 10:41 | |
| *** rossand has joined #ingres | 11:03 | |
| *** ChanServ sets mode: +o rossand | 11:03 | |
| *** atrofast has quit IRC | 12:28 | |
| *** atrofast has joined #ingres | 12:34 | |
| *** rossand has quit IRC | 13:41 | |
| *** withdefault has left #ingres | 14:52 | |
| *** DarylM has quit IRC | 14:54 | |
| *** mull has quit IRC | 15:20 | |
| *** toumi01 has left #ingres | 16:43 | |
| *** micksale has joined #ingres | 16:53 | |
| *** micksale has quit IRC | 16:54 | |
| *** micksale has joined #ingres | 16:54 | |
| *** Alex| is now known as Alex|off | 17:05 | |
| *** Alex|off is now known as Alex| | 22:09 | |
| *** Alex| is now known as Alex|off | 22:55 | |
| *** Alex|off is now known as Alex| | 23:24 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!