Question: I am using MariaDB and I would like to generate a dummy result set of a number range. The following works well:

```
select 0.0 as x
union select 0.1
union select 0.2
union select 0.3
union select 0.4
union select 0.5
union select 0.6
union select 0.7
union select 0.8
union select 0.9
union select 1.0
from dual

```

But is there a shorter form?

Answer: 
Using `VALUES`:

```
VALUES (0.0),(0.1),(0.2),(0.3),(0.4),(0.5),(0.6),(0.7),(0.8),(0.9),(1.0)

```

It makes sense when the list is static.

**[db<>fiddle demo](https://dbfiddle.uk/?rdbms=mariadb_10.5&fiddle=bb0ef7b2ef72b9b6b45dcea64779217b)**

---

MySQL version will require adding `ROW`

```
VALUES ROW(0.0), ROW(0.1), ...

```
You could use a recursive CTE here:

```sql
WITH RECURSIVE cte (n) AS (
    SELECT 0.0
    UNION ALL
    SELECT n + 0.1 FROM cte WHERE n < 1.0
)

SELECT * FROM cte;

```

[![screen capture from demo link below](https://i.stack.imgur.com/Is7MH.png)](https://i.stack.imgur.com/Is7MH.png)

[Demo
----](https://dbfiddle.uk/?rdbms=mariadb_10.5&fiddle=01228da7bf32b6d78c00fe79090908c9)