Lines Matching refs:limits
115 my %limits;
122 $self->{'limits'} = \%limits;
130 $limits{'NEG'} = 1; # Supports -id
131 $limits{'alter_add_multi_col'}= 1; #Have ALTER TABLE t add a int,add b int;
132 $limits{'alter_table'} = 1; # Have ALTER TABLE
133 $limits{'alter_table_dropcol'}= 1; # Have ALTER TABLE DROP column
134 $limits{'alter_table_after'}= 1; # Have ALTER TABLE .. AFTER other_column
135 $limits{'column_alias'} = 1; # Alias for fields in select statement.
136 $limits{'func_extra_%'} = 1; # Has % as alias for mod()
137 $limits{'func_extra_if'} = 1; # Have function if.
138 $limits{'func_extra_in_num'} = 1; # Has function in
139 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
140 $limits{'func_odbc_mod'} = 1; # Have function mod.
141 $limits{'functions'} = 1; # Has simple functions (+/-)
142 $limits{'group_by_position'} = 1; # Can use 'GROUP BY 1'
143 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
144 $limits{'group_func_extra_std'} = 1; # Have group function std().
145 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
146 $limits{'group_functions'} = 1; # Have group functions
147 $limits{'having_with_alias'} = 1; # Can use aliases in HAVING
148 $limits{'having_with_group'} = 1; # Can use group functions in HAVING
149 $limits{'insert_multi_value'} = 1; # Have INSERT ... values (1,2),(3,4)
150 $limits{'insert_select'} = 1;
151 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
152 $limits{'left_outer_join'} = 1; # Supports left outer joins
153 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
154 $limits{'limit'} = 1; # supports the limit attribute
155 $limits{'truncate_table'} = 1;
156 $limits{'load_data_infile'} = 1; # Has load data infile
157 $limits{'lock_tables'} = 1; # Has lock tables
158 $limits{'max_column_name'} = 64; # max table and column name
159 $limits{'max_columns'} = 2000; # Max number of columns in table
160 $limits{'max_conditions'} = 9999; # (Actually not a limit)
161 $limits{'max_index'} = 16; # Max number of keys
162 $limits{'max_index_parts'} = 16; # Max segments/key
163 $limits{'max_tables'} = (($machine || '') =~ "^win") ? 5000 : 65000;
164 $limits{'max_temporary_tables'}= 400;
165 $limits{'max_text_size'} = 1000000; # Good enough for tests
166 $limits{'multi_drop'} = 1; # Drop table can take many tables
167 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
168 $limits{'order_by_unused'} = 1;
169 $limits{'query_size'} = 1000000; # Max size with default buffers.
170 $limits{'select_without_from'}= 1; # Can do 'select 1';
171 $limits{'subqueries'} = 0; # Doesn't support sub-queries.
172 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
173 $limits{'unique_index'} = 1; # Unique index works or not
174 $limits{'working_all_fields'} = 1;
175 $limits{'working_blobs'} = 1; # If big varchar/blobs works
176 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
182 $limits{'working_blobs'} = 0; # HEAP tables can't handle BLOB's
188 $limits{'working_blobs'} = 0; # MEMORY tables can't handle BLOB's
203 $limits{'working_blobs'} = 0; # Blobs not implemented yet
204 $limits{'max_tables'} = 500;
205 $limits{'max_temporary_tables'}= $limits{"max_tables"};
396 my %limits;
401 $self->{'limits'} = \%limits;
405 $self->{'blob'} = "text(" . $limits{'max_text_size'} .")";
406 $self->{'text'} = "text(" . $limits{'max_text_size'} .")";
408 $limits{'max_conditions'} = 74;
409 $limits{'max_columns'} = 75;
410 $limits{'max_tables'} = 65000; # Should be big enough
411 $limits{'max_temporary_tables'}= $limits{"max_tables"};
412 $limits{'max_text_size'} = 32000;
413 $limits{'query_size'} = 65535;
414 $limits{'max_index'} = 5;
415 $limits{'max_index_parts'} = 10;
416 $limits{'max_column_name'} = 35;
418 $limits{'join_optimizer'} = 0; # Can't optimize FROM tables
419 $limits{'load_data_infile'} = 0;
420 $limits{'lock_tables'} = 0;
421 $limits{'functions'} = 0;
422 $limits{'group_functions'} = 0;
423 $limits{'group_distinct_functions'}= 0; # Have count(distinct)
424 $limits{'multi_drop'} = 0;
425 $limits{'select_without_from'}= 0;
426 $limits{'subqueries'} = 0;
427 $limits{'left_outer_join'} = 0;
428 $limits{'table_wildcard'} = 0;
429 $limits{'having_with_alias'} = 0;
430 $limits{'having_with_group'} = 0;
431 $limits{'like_with_column'} = 1;
432 $limits{'order_by_position'} = 1;
433 $limits{'group_by_position'} = 1;
434 $limits{'alter_table'} = 0;
435 $limits{'alter_add_multi_col'}= 0;
436 $limits{'alter_table_dropcol'}= 0;
437 $limits{'group_func_extra_std'} = 0;
438 $limits{'limit'} = 1; # supports the limit attribute
439 $limits{'unique_index'} = 1; # Unique index works or not
440 $limits{'insert_select'} = 0;
442 $limits{'func_odbc_mod'} = 0;
443 $limits{'func_extra_%'} = 0;
444 $limits{'func_odbc_floor'} = 0;
445 $limits{'func_extra_if'} = 0;
446 $limits{'column_alias'} = 0;
447 $limits{'NEG'} = 0;
448 $limits{'func_extra_in_num'} = 0;
449 $limits{'working_blobs'} = 1; # If big varchar/blobs works
450 $limits{'order_by_unused'} = 1;
451 $limits{'working_all_fields'} = 1;
452 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
599 my %limits;
604 $self->{'limits'} = \%limits;
611 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
612 $limits{'load_data_infile'} = 0;
614 $limits{'NEG'} = 1;
615 $limits{'alter_add_multi_col'}= 0; # alter_add_multi_col ?
616 $limits{'alter_table'} = 1;
617 $limits{'alter_table_dropcol'}= 0;
618 $limits{'column_alias'} = 1;
619 $limits{'func_extra_%'} = 1;
620 $limits{'func_extra_if'} = 0;
621 $limits{'func_extra_in_num'} = 1;
622 $limits{'func_odbc_floor'} = 1;
623 $limits{'func_odbc_mod'} = 1; # Has %
624 $limits{'functions'} = 1;
625 $limits{'group_by_position'} = 1;
626 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
627 $limits{'group_func_extra_std'} = 0;
628 $limits{'group_func_sql_min_str'}= 1; # Can execute MIN() and MAX() on strings
629 $limits{'group_functions'} = 1;
630 $limits{'having_with_alias'} = 0;
631 $limits{'having_with_group'} = 1;
632 $limits{'insert_select'} = 1;
633 $limits{'left_outer_join'} = 1;
634 $limits{'like_with_column'} = 1;
635 $limits{'lock_tables'} = 0; # in ATIS gives this a problem
636 $limits{'max_column_name'} = 128;
637 $limits{'max_columns'} = 1000; # 500 crashes pg 6.3
638 $limits{'max_conditions'} = 9999; # This makes Pg real slow
639 $limits{'max_index'} = 64; # Big enough
640 $limits{'max_index_parts'} = 16;
641 $limits{'max_tables'} = 65000;
642 $limits{'max_temporary_tables'}= $limits{"max_tables"};
644 $limits{'max_text_size'} = 65000; # Good enough for test
645 $limits{'multi_drop'} = 1;
646 $limits{'order_by_position'} = 1;
647 $limits{'order_by_unused'} = 1;
648 $limits{'query_size'} = 16777216;
649 $limits{'select_without_from'}= 1;
650 $limits{'subqueries'} = 1;
651 $limits{'table_wildcard'} = 1;
652 $limits{'truncate_table'} = 1;
653 $limits{'unique_index'} = 1; # Unique index works or not
654 $limits{'working_all_fields'} = 1;
655 $limits{'working_blobs'} = 1; # If big varchar/blobs works
656 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
879 my %limits;
884 $self->{'limits'} = \%limits;
891 $limits{'max_conditions'} = 9999; # Probably big enough
892 $limits{'max_columns'} = 2000; # From crash-me
893 $limits{'max_tables'} = 65000; # Should be big enough
894 $limits{'max_temporary_tables'}= $limits{"max_tables"};
896 $limits{'max_text_size'} = 65492; # According to tests
897 $limits{'query_size'} = 65535; # Probably a limit
898 $limits{'max_index'} = 64; # Probably big enough
899 $limits{'max_index_parts'} = 64;
900 $limits{'max_column_name'} = 80;
902 $limits{'join_optimizer'} = 1;
903 $limits{'load_data_infile'} = 0;
904 $limits{'lock_tables'} = 0;
905 $limits{'functions'} = 1;
906 $limits{'group_functions'} = 1;
907 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
908 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
909 $limits{'select_without_from'}= 0; # Can do 'select 1' ?;
910 $limits{'multi_drop'} = 0;
911 $limits{'subqueries'} = 1;
912 $limits{'left_outer_join'} = 1;
913 $limits{'table_wildcard'} = 1;
914 $limits{'having_with_alias'} = 0;
915 $limits{'having_with_group'} = 1;
916 $limits{'like_with_column'} = 1;
917 $limits{'order_by_position'} = 0; # 2.30.0018 can this
918 $limits{'group_by_position'} = 0;
919 $limits{'alter_table'} = 1;
920 $limits{'alter_add_multi_col'}= 0;
921 $limits{'alter_table_dropcol'}= 0;
923 $limits{'group_func_extra_std'} = 0; # Have group function std().
925 $limits{'func_odbc_mod'} = 1;
926 $limits{'func_extra_%'} = 0;
927 $limits{'func_odbc_floor'} = 1;
928 $limits{'column_alias'} = 1;
929 $limits{'NEG'} = 1;
930 $limits{'func_extra_in_num'} = 1;
931 $limits{'unique_index'} = 1; # Unique index works or not
932 $limits{'insert_select'} = 1;
933 $limits{'working_blobs'} = 1; # If big varchar/blobs works
934 $limits{'order_by_unused'} = 1;
935 $limits{'working_all_fields'} = 1;
936 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
1110 my %limits;
1115 $self->{'limits'} = \%limits;
1122 $limits{'max_conditions'} = 1258;
1123 $limits{'max_columns'} = 226; # server is disconnecting????
1126 $limits{'max_tables'} = 65000; # Should be big enough
1127 $limits{'max_temporary_tables'}= $limits{"max_tables"};
1128 $limits{'max_text_size'} = 4095; # max returned ....
1129 $limits{'query_size'} = 65535; # Not a limit, big enough
1130 $limits{'max_index'} = 64; # Big enough
1131 $limits{'max_index_parts'} = 64; # Big enough
1132 $limits{'max_column_name'} = 31;
1134 $limits{'join_optimizer'} = 1;
1135 $limits{'load_data_infile'} = 0;
1136 $limits{'lock_tables'} = 1;
1137 $limits{'functions'} = 1;
1138 $limits{'group_functions'} = 1;
1139 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
1140 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
1141 $limits{'select_without_from'}= 0;
1142 $limits{'multi_drop'} = 0;
1143 $limits{'subqueries'} = 1;
1144 $limits{'table_wildcard'} = 0;
1145 $limits{'having_with_alias'} = 0; # AS isn't supported in a select
1146 $limits{'having_with_group'} = 1;
1147 $limits{'like_with_column'} = 1;
1148 $limits{'order_by_position'} = 1;
1149 $limits{'group_by_position'} = 0;
1150 $limits{'alter_table'} = 1;
1151 $limits{'alter_add_multi_col'}= 0;
1152 $limits{'alter_table_dropcol'}= 0;
1154 $limits{'group_func_extra_std'}= 0; # Have group function std().
1156 $limits{'func_odbc_mod'} = 0;
1157 $limits{'func_extra_%'} = 1;
1158 $limits{'func_odbc_floor'} = 1;
1159 $limits{'func_extra_if'} = 0;
1160 $limits{'column_alias'} = 0;
1161 $limits{'NEG'} = 1;
1162 $limits{'func_extra_in_num'} = 0;
1163 $limits{'unique_index'} = 1; # Unique index works or not
1164 $limits{'insert_select'} = 1;
1165 $limits{'working_blobs'} = 1; # If big varchar/blobs works
1166 $limits{'order_by_unused'} = 1;
1167 $limits{'working_all_fields'} = 1;
1168 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
1387 $self->{'limits'} = \%limits;
1421 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
1422 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
1423 $limits{'group_by_position'} = 0;
1424 $limits{'alter_table'} = 1;
1425 $limits{'alter_add_multi_col'}= 0;
1426 $limits{'alter_table_dropcol'}= 0;
1428 $limits{'group_func_extra_std'} = 0; # Have group function std().
1430 $limits{'func_odbc_mod'} = 0; # Oracle has problem with mod()
1431 $limits{'func_extra_%'} = 0; # Has % as alias for mod()
1432 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
1433 $limits{'func_extra_if'} = 0; # Have function if.
1434 $limits{'column_alias'} = 1; # Alias for fields in select statement.
1435 $limits{'NEG'} = 1; # Supports -id
1436 $limits{'func_extra_in_num'} = 1; # Has function in
1437 $limits{'unique_index'} = 1; # Unique index works or not
1438 $limits{'insert_select'} = 1;
1439 $limits{'working_blobs'} = 1; # If big varchar/blobs works
1440 $limits{'order_by_unused'} = 1;
1441 $limits{'working_all_fields'} = 1;
1442 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
1637 $self->{'limits'} = \%limits;
1664 $limits{'join_optimizer'} = 1; # Can optimize FROM tables (always 1 only for msql)
1665 $limits{'left_outer_join'} = 0; # Supports left outer joins (ANSI)
1666 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
1667 $limits{'load_data_infile'} = 0; # Has load data infile
1668 $limits{'lock_tables'} = 1; # Has lock tables
1669 $limits{'max_conditions'} = 1214; # (Actually not a limit)
1670 $limits{'max_column_name'} = 18; # max table and column name
1671 $limits{'max_columns'} = 994; # Max number of columns in table
1672 $limits{'max_tables'} = 65000; # Should be big enough
1673 $limits{'max_temporary_tables'}= $limits{"max_tables"};
1675 $limits{'max_index'} = 64; # Max number of keys
1676 $limits{'max_index_parts'} = 15; # Max segments/key
1677 $limits{'max_text_size'} = 65535; # Max size with default buffers. ??
1678 $limits{'multi_drop'} = 0; # Drop table can take many tables
1679 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
1680 $limits{'query_size'} = 32766; # Max size with default buffers.
1681 $limits{'select_without_from'}= 0; # Can do 'select 1';
1682 $limits{'subqueries'} = 1; # Doesn't support sub-queries.
1683 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
1684 $limits{'unique_index'} = 1; # Unique index works or not
1685 $limits{'insert_select'} = 1;
1686 $limits{'working_blobs'} = 1; # If big varchar/blobs works
1687 $limits{'order_by_unused'} = 1;
1688 $limits{'working_all_fields'} = 1;
1689 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
1853 $self->{'limits'} = \%limits;
2040 $self->{'limits'} = \%limits;
2072 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
2073 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
2074 $limits{'group_by_position'} = 0; # Can use 'GROUP BY 1'
2075 $limits{'alter_table'} = 1;
2076 $limits{'alter_add_multi_col'}= 0;
2077 $limits{'alter_table_dropcol'}= 0;
2079 $limits{'group_func_extra_std'} = 0; # Have group function std().
2081 $limits{'func_odbc_mod'} = 0; # Have function mod.
2082 $limits{'func_extra_%'} = 1; # Has % as alias for mod()
2083 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
2084 $limits{'func_extra_if'} = 0; # Have function if.
2085 $limits{'column_alias'} = 1; # Alias for fields in select statement.
2086 $limits{'NEG'} = 1; # Supports -id
2087 $limits{'func_extra_in_num'} = 0; # Has function in
2088 $limits{'unique_index'} = 1; # Unique index works or not
2089 $limits{'insert_select'} = 1;
2090 $limits{'working_blobs'} = 1; # If big varchar/blobs works
2091 $limits{'order_by_unused'} = 1;
2092 $limits{'working_all_fields'} = 1;
2093 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
2228 my %limits;
2237 $self->{'limits'} = \%limits;
2245 $limits{'max_conditions'} = 1030; # We get 'Query is too complex'
2246 $limits{'max_columns'} = 250; # Max number of columns in table
2247 $limits{'max_tables'} = 65000; # Should be big enough
2248 $limits{'max_temporary_tables'}= $limits{"max_tables"};
2250 $limits{'max_text_size'} = 9830; # Max size with default buffers.
2251 $limits{'query_size'} = 9830; # Max size with default buffers.
2252 $limits{'max_index'} = 64; # Max number of keys
2253 $limits{'max_index_parts'} = 15; # Max segments/key
2254 $limits{'max_column_name'} = 30; # max table and column name
2256 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
2257 $limits{'load_data_infile'} = 0; # Has load data infile
2258 $limits{'lock_tables'} = 0; # Has lock tables
2259 $limits{'functions'} = 1; # Has simple functions (+/-)
2260 $limits{'group_functions'} = 1; # Have group functions
2261 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
2262 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
2263 $limits{'select_without_from'}= 1; # Can do 'select 1';
2264 $limits{'multi_drop'} = 1; # Drop table can take many tables
2265 $limits{'subqueries'} = 1; # Supports sub-queries.
2266 $limits{'left_outer_join'} = 1; # Supports left outer joins
2267 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
2268 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
2269 $limits{'having_with_group'} = 1; # Can't use group functions in HAVING
2270 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
2271 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
2272 $limits{'group_by_position'} = 0; # Can use 'GROUP BY 1'
2273 $limits{'alter_table'} = 1;
2274 $limits{'alter_add_multi_col'}= 0;
2275 $limits{'alter_table_dropcol'}= 0;
2277 $limits{'group_func_extra_std'} = 0; # Have group function std().
2279 $limits{'func_odbc_mod'} = 0; # Have function mod.
2280 $limits{'func_extra_%'} = 1; # Has % as alias for mod()
2281 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
2282 $limits{'func_extra_if'} = 0; # Have function if.
2283 $limits{'column_alias'} = 1; # Alias for fields in select statement.
2284 $limits{'NEG'} = 1; # Supports -id
2285 $limits{'func_extra_in_num'} = 0; # Has function in
2286 $limits{'unique_index'} = 1; # Unique index works or not
2287 $limits{'insert_select'} = 1;
2288 $limits{'working_blobs'} = 1; # If big varchar/blobs works
2289 $limits{'order_by_unused'} = 1;
2290 $limits{'working_all_fields'} = 1;
2291 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
2467 my %limits;
2472 $self->{'limits'} = \%limits;
2479 $limits{'max_conditions'} = 50; # (Actually not a limit)
2480 $limits{'max_columns'} = 254; # Max number of columns in table
2481 $limits{'max_tables'} = 65000; # Should be big enough
2482 $limits{'max_temporary_tables'}= $limits{"max_tables"};
2484 $limits{'max_text_size'} = 2000; # Limit for blob test-connect
2485 $limits{'query_size'} = 65525; # Max size with default buffers.
2486 $limits{'max_index'} = 16; # Max number of keys
2487 $limits{'max_index_parts'} = 16; # Max segments/key
2488 $limits{'max_column_name'} = 32; # max table and column name
2490 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
2491 $limits{'load_data_infile'} = 0; # Has load data infile
2492 $limits{'lock_tables'} = 0; # Has lock tables
2493 $limits{'functions'} = 1; # Has simple functions (+/-)
2494 $limits{'group_functions'} = 1; # Have group functions
2495 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
2496 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
2497 $limits{'select_without_from'}= 0;
2498 $limits{'multi_drop'} = 0;
2499 $limits{'subqueries'} = 1;
2500 $limits{'left_outer_join'} = 0; # This may be fixed in the query module
2501 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
2502 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
2503 $limits{'having_with_group'} = 1; # Can't use group functions in HAVING
2504 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
2505 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
2506 $limits{'group_by_position'} = 1;
2507 $limits{'alter_table'} = 1;
2508 $limits{'alter_add_multi_col'}= 2; #Have ALTER TABLE t add a int, b int;
2509 $limits{'alter_table_dropcol'}= 1;
2511 $limits{'group_func_extra_std'} = 0; # Have group function std().
2513 $limits{'func_odbc_mod'} = 0; # Oracle has problem with mod()
2514 $limits{'func_extra_%'} = 0; # Has % as alias for mod()
2515 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
2516 $limits{'func_extra_if'} = 0; # Have function if.
2517 $limits{'column_alias'} = 1; # Alias for fields in select statement.
2518 $limits{'NEG'} = 1; # Supports -id
2519 $limits{'func_extra_in_num'} = 1; # Has function in
2520 $limits{'unique_index'} = 1; # Unique index works or not
2521 $limits{'insert_select'} = 1;
2522 $limits{'working_blobs'} = 1; # If big varchar/blobs works
2523 $limits{'order_by_unused'} = 1;
2524 $limits{'working_all_fields'} = 1;
2525 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
2669 my %limits;
2678 $self->{'limits'} = \%limits;
2685 $limits{'max_conditions'} = 418; # We get 'Query is too complex'
2686 $limits{'max_columns'} = 500; # Max number of columns in table
2687 $limits{'max_tables'} = 65000; # Should be big enough
2688 $limits{'max_temporary_tables'}= $limits{"max_tables"};
2690 $limits{'max_text_size'} = 254; # Max size with default buffers.
2691 $limits{'query_size'} = 254; # Max size with default buffers.
2692 $limits{'max_index'} = 48; # Max number of keys
2693 $limits{'max_index_parts'} = 15; # Max segments/key
2694 $limits{'max_column_name'} = 18; # max table and column name
2696 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
2697 $limits{'load_data_infile'} = 0; # Has load data infile
2698 $limits{'lock_tables'} = 0; # Has lock tables
2699 $limits{'functions'} = 1; # Has simple functions (+/-)
2700 $limits{'group_functions'} = 1; # Have group functions
2701 $limits{'group_func_sql_min_str'}= 1;
2702 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
2703 $limits{'select_without_from'}= 0; # Can do 'select 1';
2704 $limits{'multi_drop'} = 0; # Drop table can take many tables
2705 $limits{'subqueries'} = 1; # Supports sub-queries.
2706 $limits{'left_outer_join'} = 1; # Supports left outer joins
2707 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
2708 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
2709 $limits{'having_with_group'} = 1; # Can't use group functions in HAVING
2710 $limits{'like_with_column'} = 0; # Can use column1 LIKE column2
2711 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
2712 $limits{'group_by_position'} = 0; # Can use 'GROUP BY 1'
2713 $limits{'alter_table'} = 1;
2714 $limits{'alter_add_multi_col'}= 0;
2715 $limits{'alter_table_dropcol'}= 0;
2717 $limits{'group_func_extra_std'} = 0; # Have group function std().
2719 $limits{'func_odbc_mod'} = 1; # Have function mod.
2720 $limits{'func_extra_%'} = 0; # Has % as alias for mod()
2721 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
2722 $limits{'func_extra_if'} = 0; # Have function if.
2723 $limits{'column_alias'} = 1; # Alias for fields in select statement.
2724 $limits{'NEG'} = 1; # Supports -id
2725 $limits{'func_extra_in_num'} = 0; # Has function in
2726 $limits{'unique_index'} = 1; # Unique index works or not
2727 $limits{'insert_select'} = 1;
2728 $limits{'working_blobs'} = 1; # If big varchar/blobs works
2729 $limits{'order_by_unused'} = 1;
2730 $limits{'working_all_fields'} = 1;
2731 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
2851 my %limits;
2856 $self->{'limits'} = \%limits;
2865 $limits{'max_conditions'} = 9999; # (Actually not a limit)
2866 $limits{'max_columns'} = 252; # Max number of columns in table
2867 $limits{'max_tables'} = 65000; # Should be big enough
2868 $limits{'max_temporary_tables'}= $limits{"max_tables"};
2869 $limits{'max_text_size'} = 15000; # Max size with default buffers.
2870 $limits{'query_size'} = 1000000; # Max size with default buffers.
2871 $limits{'max_index'} = 32; # Max number of keys
2872 $limits{'max_index_parts'} = 16; # Max segments/key
2873 $limits{'max_column_name'} = 128; # max table and column name
2875 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
2876 $limits{'load_data_infile'} = 1; # Has load data infile
2877 $limits{'lock_tables'} = 0; # Has lock tables
2878 $limits{'functions'} = 1; # Has simple functions (+/-)
2879 $limits{'group_functions'} = 1; # Have group functions
2880 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
2881 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
2882 $limits{'select_without_from'}= 0; # Cannot do 'select 1';
2883 $limits{'multi_drop'} = 0; # Drop table cannot take many tables
2884 $limits{'subqueries'} = 1; # Supports sub-queries.
2885 $limits{'left_outer_join'} = 1; # Supports left outer joins
2886 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
2887 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
2888 $limits{'having_with_group'} = 1; # Can use group functions in HAVING
2889 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
2890 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
2891 $limits{'group_by_position'} = 0; # Cannot use 'GROUP BY 1'
2892 $limits{'alter_table'} = 1; # Have ALTER TABLE
2893 $limits{'alter_add_multi_col'}= 0; # Have ALTER TABLE t add a int,add b int;
2894 $limits{'alter_table_dropcol'}= 1; # Have ALTER TABLE DROP column
2895 $limits{'insert_multi_value'} = 0; # Does not have INSERT ... values (1,2),(3,4)
2896 $limits{'multi_distinct'} = 0; # Does not allow select count(distinct a),count(distinct b)..
2898 $limits{'group_func_extra_std'} = 0; # Does not have group function std().
2900 $limits{'func_odbc_mod'} = 1; # Have function mod.
2901 $limits{'func_extra_%'} = 0; # Does not have % as alias for mod()
2902 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function
2903 $limits{'func_extra_if'} = 0; # Does not have function if.
2904 $limits{'column_alias'} = 1; # Alias for fields in select statement.
2905 $limits{'NEG'} = 1; # Supports -id
2906 $limits{'func_extra_in_num'} = 1; # Has function in
2907 $limits{'limit'} = 0; # Does not support the limit attribute
2908 $limits{'unique_index'} = 1; # Unique index works or not
2909 $limits{'insert_select'} = 1;
2910 $limits{'working_blobs'} = 1; # If big varchar/blobs works
2911 $limits{'order_by_unused'} = 0;
2912 $limits{'working_all_fields'} = 1;
3054 my %limits;
3059 $self->{'limits'} = \%limits;
3068 $limits{'max_conditions'} = 9999; # (Actually not a limit)
3069 $limits{'max_columns'} = 252; # Max number of columns in table
3070 $limits{'max_tables'} = 65000; # Should be big enough
3071 $limits{'max_temporary_tables'}= $limits{"max_tables"};
3072 $limits{'max_text_size'} = 15000; # Max size with default buffers.
3073 $limits{'query_size'} = 1000000; # Max size with default buffers.
3074 $limits{'max_index'} = 65000; # Max number of keys
3075 $limits{'max_index_parts'} = 8; # Max segments/key
3076 $limits{'max_column_name'} = 128; # max table and column name
3078 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
3079 $limits{'load_data_infile'} = 0; # Has load data infile
3080 $limits{'lock_tables'} = 0; # Has lock tables
3081 $limits{'functions'} = 1; # Has simple functions (+/-)
3082 $limits{'group_functions'} = 1; # Have group functions
3083 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings
3084 $limits{'group_distinct_functions'}= 1; # Have count(distinct)
3085 $limits{'select_without_from'}= 0; # Cannot do 'select 1';
3086 $limits{'multi_drop'} = 0; # Drop table cannot take many tables
3087 $limits{'subqueries'} = 1; # Supports sub-queries.
3088 $limits{'left_outer_join'} = 1; # Supports left outer joins
3089 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
3090 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
3091 $limits{'having_with_group'} = 1; # Can use group functions in HAVING
3092 $limits{'like_with_column'} = 0; # Can use column1 LIKE column2
3093 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
3094 $limits{'group_by_position'} = 0; # Cannot use 'GROUP BY 1'
3095 $limits{'alter_table'} = 1; # Have ALTER TABLE
3096 $limits{'alter_add_multi_col'}= 1; # Have ALTER TABLE t add a int,add b int;
3097 $limits{'alter_table_dropcol'}= 1; # Have ALTER TABLE DROP column
3098 $limits{'insert_multi_value'} = 0; # Does not have INSERT ... values (1,2),(3,4)
3100 $limits{'group_func_extra_std'} = 0; # Does not have group function std().
3102 $limits{'func_odbc_mod'} = 0; # Have function mod.
3103 $limits{'func_extra_%'} = 0; # Does not have % as alias for mod()
3104 $limits{'func_odbc_floor'} = 0; # Has func_odbc_floor function
3105 $limits{'func_extra_if'} = 0; # Does not have function if.
3106 $limits{'column_alias'} = 1; # Alias for fields in select statement.
3107 $limits{'NEG'} = 0; # Supports -id
3108 $limits{'func_extra_in_num'} = 0; # Has function in
3109 $limits{'limit'} = 0; # Does not support the limit attribute
3110 $limits{'working_blobs'} = 1; # If big varchar/blobs works
3111 $limits{'order_by_unused'} = 1;
3112 $limits{'working_all_fields'} = 1;
3113 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
3251 my %limits;
3256 $self->{'limits'} = \%limits;
3264 $limits{'max_conditions'} = 5427; # (Actually not a limit)
3266 $limits{'max_columns'} = 150; # Max number of columns in table
3267 $limits{'max_tables'} = 5000; # 10000 crashed FrontBase
3268 $limits{'max_temporary_tables'}= $limits{"max_tables"};
3269 $limits{'max_text_size'} = 65000; # Max size with default buffers.
3270 $limits{'query_size'} = 8000000; # Max size with default buffers.
3271 $limits{'max_index'} = 38; # Max number of keys
3272 $limits{'max_index_parts'} = 20; # Max segments/key
3273 $limits{'max_column_name'} = 128; # max table and column name
3275 $limits{'join_optimizer'} = 1; # Can optimize FROM tables
3276 $limits{'load_data_infile'} = 1; # Has load data infile
3277 $limits{'lock_tables'} = 0; # Has lock tables
3278 $limits{'functions'} = 1; # Has simple functions (+/-)
3279 $limits{'group_functions'} = 1; # Have group functions
3280 $limits{'group_distinct_functions'}= 0; # Have count(distinct)
3281 $limits{'select_without_from'}= 0;
3282 $limits{'multi_drop'} = 0; # Drop table cannot take many tables
3283 $limits{'subqueries'} = 1; # Supports sub-queries.
3284 $limits{'left_outer_join'} = 1; # Supports left outer joins
3285 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
3286 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING
3287 $limits{'having_with_group'} = 0; # Can use group functions in HAVING
3288 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2
3289 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1'
3290 $limits{'group_by_position'} = 0; # Use of 'GROUP BY 1'
3291 $limits{'alter_table'} = 1; # Have ALTER TABLE
3292 $limits{'alter_add_multi_col'}= 0; # Have ALTER TABLE t add a int,add b int;
3293 $limits{'alter_table_dropcol'}= 0; # Have ALTER TABLE DROP column
3294 $limits{'insert_multi_value'} = 1;
3296 $limits{'group_func_extra_std'} = 0; # Does not have group function std().
3298 $limits{'func_odbc_mod'} = 0; # Have function mod.
3299 $limits{'func_extra_%'} = 0; # Does not have % as alias for mod()
3300 $limits{'func_odbc_floor'} = 0; # Has func_odbc_floor function
3301 $limits{'func_extra_if'} = 0; # Does not have function if.
3302 $limits{'column_alias'} = 1; # Alias for fields in select statement.
3303 $limits{'NEG'} = 1; # Supports -id
3304 $limits{'func_extra_in_num'} = 0; # Has function in
3305 $limits{'limit'} = 0; # Does not support the limit attribute
3306 $limits{'insert_select'} = 0;
3307 $limits{'order_by_unused'} = 0;
3310 $limits{'unique_index'} = 0; # Unique index works or not
3312 $limits{'working_blobs'} = 0;
3314 $limits{'group_func_sql_min_str'} = 0;
3316 $limits{'working_all_fields'} = 0;
3317 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..
3464 my %limits;
3469 $self->{'limits'} = \%limits;
3478 $limits{'max_conditions'} = 9999; # (Actually not a limit) *
3479 $limits{'max_columns'} = 1023; # Max number of columns in table *
3480 $limits{'max_tables'} = 65000; # Should be big enough * unlimited actually
3481 $limits{'max_temporary_tables'}= $limits{"max_tables"};
3482 $limits{'max_text_size'} = 15000; # Max size with default buffers.
3483 …$limits{'query_size'} = 64*1024; # Max size with default buffers. *64 kb by default. May be set b…
3484 $limits{'max_index'} = 510; # Max number of keys *
3485 $limits{'max_index_parts'} = 16; # Max segments/key *
3486 $limits{'max_column_name'} = 32; # max table and column name *
3488 $limits{'join_optimizer'} = 1; # Can optimize FROM tables *
3489 $limits{'load_data_infile'} = 0; # Has load data infile *
3490 $limits{'lock_tables'} = 1; # Has lock tables
3491 $limits{'functions'} = 1; # Has simple functions (+/-) *
3492 $limits{'group_functions'} = 1; # Have group functions *
3493 $limits{'group_func_sql_min_str'} = 1; # Can execute MIN() and MAX() on strings *
3494 $limits{'group_distinct_functions'}= 1; # Have count(distinct) *
3495 $limits{'select_without_from'}= 0; # Cannot do 'select 1'; *
3496 $limits{'multi_drop'} = 0; # Drop table cannot take many tables *
3497 $limits{'subqueries'} = 1; # Supports sub-queries. *
3498 $limits{'left_outer_join'} = 1; # Supports left outer joins *
3499 $limits{'table_wildcard'} = 1; # Has SELECT table_name.*
3500 $limits{'having_with_alias'} = 0; # Can use aliases in HAVING *
3501 $limits{'having_with_group'} = 1; # Can use group functions in HAVING *
3502 $limits{'like_with_column'} = 1; # Can use column1 LIKE column2 *
3503 $limits{'order_by_position'} = 1; # Can use 'ORDER BY 1' *
3504 $limits{'group_by_position'} = 0; # Cannot use 'GROUP BY 1' *
3505 $limits{'alter_table'} = 1; # Have ALTER TABLE *
3506 $limits{'alter_add_multi_col'}= 1; # Have ALTER TABLE t add a int,add b int; *
3507 $limits{'alter_table_dropcol'}= 1; # Have ALTER TABLE DROP column *
3508 $limits{'insert_multi_value'} = 0; # INSERT ... values (1,2),(3,4) *
3510 $limits{'group_func_extra_std'} = 0; # Does not have group function std().
3512 $limits{'func_odbc_mod'} = 0; # Have function mod. *
3513 $limits{'func_extra_%'} = 0; # Does not have % as alias for mod() *
3514 $limits{'func_odbc_floor'} = 1; # Has func_odbc_floor function *
3515 $limits{'func_extra_if'} = 0; # Does not have function if. *
3516 $limits{'column_alias'} = 1; # Alias for fields in select statement. *
3517 $limits{'NEG'} = 1; # Supports -id *
3518 $limits{'func_extra_in_num'} = 0; # Has function in *
3519 $limits{'limit'} = 0; # Does not support the limit attribute *
3520 $limits{'working_blobs'} = 1; # If big varchar/blobs works *
3521 $limits{'order_by_unused'} = 1; #
3522 $limits{'working_all_fields'} = 1; #
3523 $limits{'multi_distinct'} = 1; # allows select count(distinct a),count(distinct b)..