[PHP-DEV] Question for Zeev, Zak or Georg - mysql_query and possible integeroverflow?

2003-03-25 Thread Matt Flaherty
Hi, I have a question for the authors of the mysql extension. I'm sure you gentlemen are very busy, but I'd appreciate your insight if you can spare a moment. I'm developing a stand-alone php application running in an infinite loop from the command line interface. A mysql database is polled

Re: [PHP-DEV] Question for Zeev, Zak or Georg - mysql_query andpossible integer overflow?

2003-03-25 Thread Wez Furlong
Hi Matt, Yes, there is a risk of overflow. From my understanding, the id is signed, so you will hit overflow at 2G rather than 4G resources. This applies to any/all PHP/ZE resources. I'm not sure what happens when it overflows; it seems like the query would fail. You could design your

Re: [PHP-DEV] Question for Zeev, Zak or Georg - mysql_query andpossible integer overflow?

2003-03-25 Thread Matt Flaherty
Thanks Wez, If all that happens is the query will fail, I can live with that. It's a simple SELECT query called over and over again. If the integer wraps around negative, I'm guessing that would probably have undesirable effects. If not, then I can let it run forever. What I don't want is

Re: [PHP-DEV] Question for Zeev, Zak or Georg - mysql_query and possible integer overflow?

2003-03-25 Thread Zak Greant
On Tue, Mar 25, 2003 at 01:50:17PM +, Matt Flaherty wrote: Hi, I have a question for the authors of the mysql extension. I'm sure you gentlemen are very busy, but I'd appreciate your insight if you can spare a moment. I'm developing a stand-alone php application running in an infinite

[PHP-DEV] Is this a bug?

2003-03-25 Thread Tony Bibbs
Are there instances you all can think of where doing a header('location: $url'); causes a loss of all session data? I have a case I can reproduce consistently where doing a header() refresh or echoing out an HTML page with a meta refresh both cause resulting page to lose session. My hunch is

Re: [PHP-DEV] Is this a bug?

2003-03-25 Thread Chris Shiflett
--- Tony Bibbs [EMAIL PROTECTED] wrote: Are there instances you all can think of where doing a header('location: $url'); causes a loss of all session data? This is most likely not a bug. You can (hopefully) find more people to help with this type of question on [EMAIL PROTECTED] Good luck.

Re: [PHP-DEV] Question for Zeev, Zak or Georg - mysql_query and possible integer overflow?

2003-03-25 Thread Zeev Suraski
I believe he meant the query id's that the engine uses, and not the auto increment id's. Wez's response was accurate, we'll overflow at some point. This is basically because PHP was designed with short requests in mind. We could probably fix it relatively easily for ZE2. Zeev At 13:15

Re: [PHP-DEV] Question for Zeev, Zak or Georg - mysql_query and possible integer overflow?

2003-03-25 Thread Zak Greant
D'oh - read too little, too fast. :) On Tue, Mar 25, 2003 at 05:55:42PM -0800, Zeev Suraski wrote: I believe he meant the query id's that the engine uses, and not the auto increment id's. Wez's response was accurate, we'll overflow at some point. This is basically because PHP was designed