Re: Works in sqlite.

This works as well:


Select x, a3.a, a1.a, a2.a
From a_s a1, a_s a2, x_s, a_s a3
Where (a3.a*x*x) + (a1.a*x) + a2.a = 170995
Limit 5

Now I have reverse polynomials.  Groovy.

On Tuesday, May 15, 2012, John Smith <jsmith27182@gmail.com> wrote:
> Aha!  If I restrict the query to four rows it works.
>
> Select x, a3.a, a1.a, a2.a
> From a_s a1, a_s a2, x_s, a_s a3
> Where (a3.a*x*x) + (a1.a*x) + a2.a = 409835
> and a1.a =0
>
> But if I remove the 'a1.a=0' I get the 'Error 0:'.
>
> Is there a limit to the number of rows the SQL Console will display?
>
> On Tuesday, May 15, 2012, Ken Ashcraft <kash@google.com> wrote:
>> Does it work with mysql on your local machine?
>>
>> On Tue, May 15, 2012 at 1:01 PM, John Smith <jsmith27182@gmail.com> wrote:
>>>
>>> I dunno.  I don't think it's a syntax error.  They will occur during parsing.  This query runs a while before displaying the error.  Do you think it could be because of an unindexed scan of 255x255x256x255 rows?
>>>
>>> On Tuesday, May 15, 2012, Joe Faith <joefaith@google.com> wrote:
>>> > Hi 
>>> > Cloud SQL uses MySQL as the database engine and there are some syntax differences with SQLite.
>>> > Have a look at http://dev.mysql.com/doc/refman/5.5/en/select.html for more details on the correct syntax for MySQL SELECTs
>>> > j
>>> >
>>> > On Tue, May 15, 2012 at 7:46 AM, JK Winkler <jsmith27182@gmail.com> wrote:
>>> >>
>>> >> This SQL works fine in sqlite but not in the Cloud SQL Console.
>>> >>
>>> >> Select  x, a3.a,  a1.a, a2.a
>>> >> From a_s a1, a_s a2, x_s, a_s a3
>>> >> Where (a3.a * x*x) + (a1.a * x) + a2.a = 32777
>>> >>
>>> >> I get the following error:
>>> >>
>>> >> Error 0: Unable to execute statement
>>> >>
>>> >> There are only 255 rows and one column in each table.
>>> >
>>> >
>>> >
>>> > --
>>> > Joe Faith | Product Manager | Google Cloud
>>> >
>>>
>>> --
>>> Sent from Gmail Mobile
>>
>>
>
> --
> Sent from Gmail Mobile
>

--
Sent from Gmail Mobile