Scientific number notation causes error

[Anonymous]

Hi,

First of all: I just started to use SQLeo and it really helped me forward quickly where I hed been stuck for along time with building queries, so hats off!

In a query I am multiplying a field with 1e6, like so:

SELECT blabla * 1e6 AS 'blabla'

Executing works fine and gives the desired result, however when I then update the Designer, it splits the 1e6 by adding a space, yielding:

SELECT blabla * 1 e6 AS 'blabla'

Executing this gives an error due to the space inserted between 1 and e6.

Please advice!

[Anu]

Thanks for using SQLeo, we will try to fix this case to handle scientific keywords.

As a workaround you can enclose scientific number in quotes as '1e6'
SELECT blabla * '1e6' AS 'blabla'

[Anonymous]

Cheers for the fast response!

[PAscal]

ticket https://sourceforge.net/p/sqleo/tickets/303/ created