Claus Pedersen
Member³
I open a new SQL window and copy-paste the following select (including comments):
Note that 92 lines have been left out, so to reproduce, please copy the line above it 92 times. The total number of characters in the code must sum up to 10312 characters.
When placing the cursor on the first part of the table name in line 4 of the select (the line with first occurrence of "user_tables"), e.g. on "u" or "s", highlighting of lines 4 and 5 work fine.
But when you move the cursor in line 4 to e.g. "b" or "l" in "user_tables" the highlight loses its stamina and ceases to work. Lines 7 and 8 can not be highlighted at all. When you delete a couple of the number lines in the remark, the highlighting works again.
There seems to be a limit of how long a select can be of approx. 10000 characters.
This is not a made-up scenario. I have cursors or OPEN-cursor-FOR-SELECT with selects consisting of more than more than 200 lines and more than 10000 characters including spaces, comments etc. and have found that highlighting always stops to work in the last parts of the selects.
It took me some time to figure out that it was the physical number of characters in the select that was the limitation.
Please raise the number 10000 to 'infinity' (or as high as the programming language allows) so selects like the one above can be parsed and highlighted.
SQL:
/*
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
<... 92 similar lines left out ...>
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
12345678901234567890123456789012345678901234567890123 */
/* line 1: */ SELECT *
/* line 2: */ FROM user_objects
/* line 3: */ WHERE EXISTS (SELECT NULL
/* line 4: */ FROM user_tables -- <- place cursor here
/* line 5: */ WHERE user_tables.table_name = user_objects.object_name)
/* line 6: */ AND NOT EXISTS (SELECT NULL
/* line 7: */ FROM user_tables
/* line 8: */ WHERE user_tables.table_name != user_objects.object_name);Note that 92 lines have been left out, so to reproduce, please copy the line above it 92 times. The total number of characters in the code must sum up to 10312 characters.
When placing the cursor on the first part of the table name in line 4 of the select (the line with first occurrence of "user_tables"), e.g. on "u" or "s", highlighting of lines 4 and 5 work fine.
But when you move the cursor in line 4 to e.g. "b" or "l" in "user_tables" the highlight loses its stamina and ceases to work. Lines 7 and 8 can not be highlighted at all. When you delete a couple of the number lines in the remark, the highlighting works again.
There seems to be a limit of how long a select can be of approx. 10000 characters.
This is not a made-up scenario. I have cursors or OPEN-cursor-FOR-SELECT with selects consisting of more than more than 200 lines and more than 10000 characters including spaces, comments etc. and have found that highlighting always stops to work in the last parts of the selects.
It took me some time to figure out that it was the physical number of characters in the select that was the limitation.
Please raise the number 10000 to 'infinity' (or as high as the programming language allows) so selects like the one above can be parsed and highlighted.
)
