AnsweredAssumed Answered

How does FM Really Handle Cartesian Products?

Question asked by disabled_morkus on May 6, 2012
Latest reply on May 9, 2012 by Sorbsbuster

Title

How does FM Really Handle Cartesian Products?

Post

If you have two tables, tableA and TableB where TableA has 10 rows and TableB has 10 rows, then the cartesian product would have 100 rows (TableA's size * TableB's size).

For cartesian products, please refer to the first question here: http://www.techinterviews.com/database-management-interview-questions

Based on replies on this form, then, I'm a bit confused how FileMaker Pro handles cartesian products.

I just created two tables in MySQL. TableA has values 1…10 and tableB has values 11…20. With no Join clause, and SQL like this:

SELECT * FROM TABLEA, TABLEB, we get the result set below (100 rows).

Does FM use the term cartesian product in a different way?

Cartesian products are generally something to actively avoid in most database situations.

FM may be smoothing out the rough edges here so cartesian products aren't to be avoided (in FM), I don't know.

Can anyone clarify this?

- m

1    11
2    11
3    11
4    11
5    11
6    11
7    11
8    11
9    11
10    11
1    12
2    12
3    12
4    12
5    12
6    12
7    12
8    12
9    12
10    12
1    13
2    13
3    13
4    13
5    13
6    13
7    13
8    13
9    13
10    13
1    14
2    14
3    14
4    14
5    14
6    14
7    14
8    14
9    14
10    14
1    15
2    15
3    15
4    15
5    15
6    15
7    15
8    15
9    15
10    15
1    16
2    16
3    16
4    16
5    16
6    16
7    16
8    16
9    16
10    16
1    17
2    17
3    17
4    17
5    17
6    17
7    17
8    17
9    17
10    17
1    18
2    18
3    18
4    18
5    18
6    18
7    18
8    18
9    18
10    18
1    19
2    19
3    19
4    19
5    19
6    19
7    19
8    19
9    19
10    19
1    20
2    20
3    20
4    20
5    20
6    20
7    20
8    20
9    20
10    20

Outcomes