Unknown. I'm on my iPhone & only have sqlite?
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
No comments:
Post a Comment