COMPUSPEC
| Code | Output | |
|---|---|---|
| 11.9.2 | 12.5.3 | |
| select replicate('ABCDE', -1) | NULL | NULL |
| select replicate('ABCDE', 0) | NULL | NULL |
| select replicate('ABCDE', 1) | ABCDE | ABCDE |
| select replicate('ABCDE', 2) | ABCDEABCDE | ABCDEABCDE |
| select char_length( replicate('x', 250) ) | 250 | 250 |
| select char_length( replicate('x', 500000) ) | 255 | 16384 |
| select char_length( replicate('1234567890', 250) ) | 250 | 250 |
| select char_length( replicate('1234567890', 5000) ) | 250 | 16380 |
| select char_length( replicate('', 10) ) | 10 | 10 |
| select char_length( replicate(' ', 10) ) | 10 | 10 |
| select replicate(NULL, 10) | NULL | NULL |
| select replicate(0x12, 5) | 1212121212 | 1212121212 |
| select replicate(0x123, 3) | 012301230123 | 012301230123 |
|
|
Roger Hall COMPUSPEC |
|